Home » Applications » Oracle Fusion Apps & E-Business Suite » PO_SYSTEM_PARAMETERS returning multiple rows (EBS 12.2.5)
PO_SYSTEM_PARAMETERS returning multiple rows [message #658372] Mon, 12 December 2016 00:13 Go to next message
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 #658380 is a reply to message #658372] Mon, 12 December 2016 06:24 Go to previous messageGo to next message
BlackSwan
Messages: 25748
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]$
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658395 is a reply to message #658372] Mon, 12 December 2016 09:01 Go to previous messageGo to next message
John Watson
Messages: 7184
Registered: January 2010
Location: Global Village
Senior Member
If you post the query, perhaps someone can help.
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658398 is a reply to message #658395] Mon, 12 December 2016 19:24 Go to previous messageGo to next message
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.
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658401 is a reply to message #658398] Tue, 13 December 2016 01:31 Go to previous messageGo to next message
John Watson
Messages: 7184
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?
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658406 is a reply to message #658401] Tue, 13 December 2016 03:23 Go to previous messageGo to next message
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.
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658407 is a reply to message #658406] Tue, 13 December 2016 03:27 Go to previous messageGo to next message
John Watson
Messages: 7184
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
select * from po_system_parameters
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658410 is a reply to message #658407] Tue, 13 December 2016 03:56 Go to previous messageGo to next message
knsreedevi
Messages: 25
Registered: May 2012
Location: Bangalore
Junior Member
The error is in this query used in the after parameter trigger of the report. There are multiple other main queries and groups in the report.
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658411 is a reply to message #658410] Tue, 13 December 2016 03:57 Go to previous messageGo to next message
John Watson
Messages: 7184
Registered: January 2010
Location: Global Village
Senior Member
Sorry, man. If you won't show the problem, I do not see how anyone can assist.
Re: PO_SYSTEM_PARAMETERS returning multiple rows [message #658413 is a reply to message #658411] Tue, 13 December 2016 04:55 Go to previous message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello.

How many O.U on your MOAC ?

Previous Topic: Implementation Module Sequence
Next Topic: Advice for printing 2016 1099's on 11.5 without patch
Goto Forum:
  


Current Time: Thu Dec 14 09:39:16 CST 2017

Total time taken to generate the page: 0.01438 seconds