My Oracle Support Banner

R12: AP: Error "ORA-01422: Exact Fetch Returns More Than Requested Number of Rows" and Duplicate Supplier Affecting Payment Windows And Supplier Updates (Doc ID 1921608.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When entering a payment using an Employee Supplier on the Payments screen, the following error occurs:

ERROR 1
-----------------------
ORA-01422: exact fetch returns more than requested number of rows

Also, the Employee Supplier seems to be duplicated as seen on the Supplier page.
This affects the payment window and any updates of the particular employee returns the following error:

ERROR 2
-----------------------
ORA-01422: exact fetch returns more than requested number of rows in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor.



The issue can be reproduced at will with the following steps:
1. Payments > Entry > Payments
2. Select Employee Supplier
3. Proceed the entering the payment.


The issue has the following business impact:
Due to this issue, users cannot enter the payment for Employee Supplier.

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
 Have more questions?
References


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