When Attempting To Pull In Two Seller Originated IFOs, ORA-01403:No Data Found Error is Generated (Doc ID 3010378.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Symptoms

When attempting to pull in two Seller Originated IFOs, the process results in the following error:

ERROR
-----------------------
ORA-01403: No Data Found Error Encountered while autocreating IGT Order or Modification

STEPS
-----------------------
1. Created a new .xls file for the Seller Originating order upload with an Advance and PPQ Amount.
2. Uploaded this file in the G-Invoicing-QA instance. The file is successfully uploaded and two orders are created.
3. Download this file and copy the orders created in step 2 into the new Requesting side .xls file.
4. The Requesting side uploads the new .xls file into G-Invoicing-QA and the two orders are now in an Open status and ready to be pulled into Oracle.
5. Logged into Oracle and select the DM Purchasing Super User responsibility.
6. Ran the Intragovernmental Orders Interface Program to pull in the two Seller Originated IFOs created from the upload.
7. The pull request completes normally.
8. Navigate to the Oracle Worklist and the notification generated
9. The pull request indicates one of the IFO orders did not pull in due to error

Cause

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