PO_SYSTEM_PARAMETERS returning multiple rows [message #658372] |
Mon, 12 December 2016 00:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
knsreedevi
Messages: 25 Registered: May 2012 Location: Bangalore
|
Junior Member |
|
|
Hi all,
We are on R12.2.5 EBS version.
On running one of the custom reports, the query on po_system_parameters go into exception.
Error : ORA-01422: exact fetch returns more than requested number of rows
Can anyone explain what is the issue.
Thanks
|
|
|
|
|
|
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658401 is a reply to message #658398] |
Tue, 13 December 2016 01:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If you follow the synonym back to the original table, you find that it is the po.po_system_parameters_all table. According to the ETRM,Quote:PO_SYSTEM_PARAMETERS_ALL stores default, control, and option
information you provide to customize Oracle Purchasing to your
company's needs. PO_SYSTEM_PARAMETERS_ALL corresponds to the
Purchasing Options window. This table has no primary key. The
table should never have more than one row.
Are you saying that you have several rows in it?
And to report, what is the query you are running that throws the error?
|
|
|
|
|
|
|
|