My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2021

Applies to:

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


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

Inside the loop of merge vendor_contact :2543554
ORA-01422: exact fetch returns more than requested number of rows


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'


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.