OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » PO_SYSTEM

Home » Applications » Oracle Fusion Apps & E-Business Suite » PO_SYSTEM_PARAMETERS returning multiple rows (EBS 12.2.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PO_SYSTEM_PARAMETERS returning multiple rows [message #658372]

Mon, 12 December 2016 00:13

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

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658380 is a reply to message #658372]

Mon, 12 December 2016 06:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

[oracle@vbgeneric dbs]$ oerr ora 1422
01422, 00000, "exact fetch returns more than requested number of rows"
// *Cause: The number specified in exact fetch is less than the rows returned.
// *Action: Rewrite the query or change number of rows requested
[oracle@vbgeneric dbs]$

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658395 is a reply to message #658372]

Mon, 12 December 2016 09:01

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

If you post the query, perhaps someone can help.

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658398 is a reply to message #658395]

Mon, 12 December 2016 19:24

knsreedevi
Messages: 25
Registered: May 2012
Location: Bangalore

Junior Member

Select * from po_system_parameters

The query is only so much. As per my understanding it should return only one row for an operating unit.

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658401 is a reply to message #658398]

Tue, 13 December 2016 01:31

John Watson
Messages: 8962
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?

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658406 is a reply to message #658401]

Tue, 13 December 2016 03:23

knsreedevi
Messages: 25
Registered: May 2012
Location: Bangalore

Junior Member

PO_SYSTEM_PARAMETERS_ALL has 8 rows in our application for different operating units.
as mentioned in my prev reply... select * from po_system_parameters is the query in the report.

Report message to a moderator

Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658407 is a reply to message #658406]

Tue, 13 December 2016 03:27

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

CAn you please just how what you are doing? Copy/paste the query and the error? You said it was a custom report. Are you saying that this report is nothing more than