My Oracle Support Banner

R12: AP: Supplier Merge Errors ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1956530.1)

Last updated on AUGUST 20, 2024

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Merging two supplier sites results in the following error:

MSG-07460: Error in function Duplicate_sites
MSG-03060: Failure in function BeforeReport
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-03000: Start Before Reports Trigger.
MSG-03010: After SRWINIT
MSG-03011: Checking whether from vendor id and vendor site id are passed or not
MSG-03020: Check CHV installation status.
MSG-03030: Check MRP installation status.
MSG-03040: CHV status: Y and MRP status: Y
MSG-03050: Call function get_company_name
MSG-03070: Call function GET_NLS_STRINGS
MSG-03090: Call function get_base_curr_data
MSG-03110: Call

Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call
Inside the loop of merge vendor_contact :2543554
ORA-01422: exact fetch returns more than requested number of rows



STEPS

1. Payables Super User > Suppliers > Supplier Merge
2. Fill in from supplier, supplier site and to supplier, supplier s ite details and click on 'Merge'

Cause

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
Symptoms
Cause
Solution
References


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