Home » Applications » Oracle Fusion Apps & E-Business Suite » APP-PO-14142: get_startup_values-030: ORA-01422 (Oracle Application (Purchasing))
APP-PO-14142: get_startup_values-030: ORA-01422 [message #469245] Wed, 04 August 2010 01:28 Go to next message
ahsangt
Messages: 3
Registered: August 2010
Location: Pakistan
Junior Member
Dear All,
In Oracle Purchasing, Supply Base-Apporved Supplier List, there is coming as error that:
APP-PO-14142: get_startup_values-030: ORA-01422: exact fetch returns more than requested number of rows.
kinldy help to resolve the error.
thanks

Report message to a moderator

Re: APP-PO-14142: get_startup_values-030: ORA-01422 [message #469248 is a reply to message #469245] Wed, 04 August 2010 01:36 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
 
ORA-01422: 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


Please copy paste your snippet .

Report message to a moderator

Re: APP-PO-14142: get_startup_values-030: ORA-01422 [message #469278 is a reply to message #469248] Wed, 04 August 2010 02:14 Go to previous messageGo to next message
ahsangt
Messages: 3
Registered: August 2010
Location: Pakistan
Junior Member
dear rahulvb,
please find attachment of Snap shot
thanks

Report message to a moderator

Re: APP-PO-14142: get_startup_values-030: ORA-01422 [message #469356 is a reply to message #469245] Wed, 04 August 2010 05:56 Go to previous message
Alien
Messages: 292
Registered: June 1999
Senior Member
Looks like you're using R11i.

The SQL-statement that errors is:
SELECT past.status_id,
past.status,
plc.lookup_code,
plc.displayed_field,
fsp.inventory_organization_id
FROM po_asl_statuses past,
po_lookup_codes plc,
financials_system_parameters fsp
WHERE past.asl_default_flag = 'Y'
AND plc.lookup_type = 'ASL_VENDOR_BUSINESS_TYPE'
AND plc.lookup_code = 'DIRECT'

This returns more than one row. Run it for your Operating Unit and see which table returns more than one row.

Regards,

Arian

Report message to a moderator

Previous Topic: Error relating to creating a requisition---- ORA-00001
Next Topic: Conditionally mandatory parameters using value sets.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:06:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.