Invoices Are Not Generating Upon Submitting the Intergovernmental Performance Integration To Payables Program Due to Error - ORA-01422 (Doc ID 3064472.1)

Last updated on DECEMBER 21, 2024

Applies to:

Symptoms

Using G-Invoicing, upon submitting the Intergovernmental Performance Integration to Payables Program to generate the Government invoice, the invoice is not created and an error is encountered.
This issue occurs when the performance transaction has more than one line/schedule and is matched to an Order with FOB Destination.

Error:

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

Replication Steps:
1. Submit Intergovernmental Performance Integration to Payables Program request to generate the payables invoice
2. The invoice is note created.

Cause

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