My Oracle Support Banner

Error ORA-01422 Exact Fetch Returns More Than Requested Number of Rows While Running the Invoice Import Program (Doc ID 2633768.1)

Last updated on FEBRUARY 23, 2020

Applies to:

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

Symptoms

The Payables Invoice Import program is failing with the following error




Error:
-------

ORA-01422: exact fetch returns more than requested number of rows get_overbill_for_shipment<-AP_IMPORT_VALIDATION_PKG.v_check_line_ext_po_info2<-AP_IMPORT_VALIDATION_PKG.v_check_line_ext_po_info<-Import_invoicest Trigger



Steps to Reproduce the Issue
-----------------------------------

1. Login to PAYABLES
2. launch the import invoices program 

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.