Supplier Merge Errors ORA-01422: exact fetch returns more than requested number of rows
Last updated on DECEMBER 08, 2016
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-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
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
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'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms