My Oracle Support Banner

Intragovernmental Agreements (GT&C) Interface Program Completes Successfully However Spin-off Intragovernmental Agreements (GT&C) Import Program Is Never Submitted and There are No Orders Created (Doc ID 2885451.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

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

Symptoms

Intragovernmental Agreements (GT&C) Interface Program completes with success and does transfer the data from the Treasury to the E-Business Suite tables.

During the execution of the  'Intragovernmental Agreements (GT&C) Interface Program', data is then inserted into the po_headers_interface, etc.. tables.

As the 'Intragovernmental Agreements (GT&C) Interface' completes it should submit a child request - 'Intragovernmental Agreements (GT&C) Import Program'.

This child request 'Intragovernmental Agreements (GT&C) Import' Program. is not found - it is not being submitted -

The following sql confirms the Order was pulled with success.

IGT_REQUEST_ID REQUEST_ID IGT_REQUEST_TYPE IGT_REQUEST_MODE REQUEST_STATUS ORG_ID IGT_DOCUMENT_ID
113 131189883 GET_GTC_BY_ID PULL SUCCESS 204 A###-###-###-03212321

 

 

Note: The request_status shows success, but Import is never submitted/completed - example output below.

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.