My Oracle Support Banner

R12: AP: Invoice Import Rejected With Error "ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows" (Doc ID 2635889.1)

Last updated on FEBRUARY 10, 2020

Applies to:

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

Symptoms

PO matched Invoice import was rejected with below error:

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

Steps to reproduce the issue:

1. Populate the Payables Interface tables with the PO matched Invoice data.

2. Execute the 'Payables Open Interface Import' program.

3. Verify the below error in the output of the program:

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

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


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