My Oracle Support Banner

APP-PO-14142: GET_RESOURCE_DEFAULTS-10: ORA-01422: when Opening Distribution in Enter PO or Enter Requisition Form (Doc ID 1996911.1)

Last updated on MARCH 02, 2023

Applies to:

Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.


Using Purchasing, querying the purchase order - in the PO Summary - then opening the purchase order and navigating the to the purchase order distribution - raises an error as the distribution form is opened.
Alternatively, the same error can occur in a Requisition form as well.

APP-PO-14142: get_resource_defaults-10: ORA-01422: exact fetch returns more than requested number of rows.

Cause: A SQL error has occurred in get_resource_defaults. The SQL error is ORA-01422: exact fetch returns more than
requested number of rows.

Action: Take note of both this error number and the actions you were trying to perform.
Contact your system administrator for further assistance.

1. Login to the E-Business Suite and choose the Purchasing Module.
2. Purchase Order Summary - query the purchase order
3. Choose the Open button
4. Choose the Lines button - shipment button - and then distribution button
5. Error appears


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.