G-invoicing: After Running “Intragovernmental Orders Interface Program”, the IGT_DOCUMENT_REQUESTS Table Has the INTERNAL_DOCUMENT_STATUS Column With “ORA-01403: No Data Found” (Doc ID 3022542.1)

Last updated on MAY 14, 2024

Applies to:

Symptoms

After running the PO_IGT_SERVICE_INVOKER_ORDER Intragovernmental Orders Interface Program,
the IGT_DOCUMENT_REQUESTS table has the INTERNAL_DOCUMENT_STATUS column with "ORA-01403: no data found".

Steps to reproduce:

1. Using a Projects responsibility navigate to Other-->Requests

2. Submit "Intragovernmental Orders Interface Program" with parameters:
Agency Type = Servicing Agency
Requesting Mode = Pull
Request Type = Get Order List
Operating Unit = <>
Agency Location Code = <>

The program completed without error.

3. However, the error "ORA-01403: no data found" is shown in IGT_DOCUMENT_REQUESTS.INTERNAL_DOCUMENT_STATUS column.

Cause

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