My Oracle Support Banner

Intragovernmental Agreements (GT&C) Import Program Errors with ORA-06512 APPS.PO_PDOI_GRP (Doc ID 2782411.1)

Last updated on MARCH 02, 2023

Applies to:

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

Symptoms

On : 12.2.9 version, in G-Invoicing enabled Operating Unit

Intragovernmental Agreements (GT&C) Import Program fails for Intragovernment (IGT) Orders with the following error message visible in the program log file :

ERROR
-----------------------
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at "APPS.PO_PDOI_GRP", line 383
ORA-06512: at line 1

The error occurs when the GT&C (General Terms and Conditions) do not include Vendor and Vendor Site information


Steps to Reproduce :
-----------------------

1. Navigate to Purchasing Responsibility

2. Navigate to request submission page

3. Submit Intragovernmental Agreements (GT&C) Interface Program. This program then triggers the Intragovernmental Agreements (GT&C) Import Program.

4. Intragovernmental Agreements (GT&C) Import Program completes in error and the above error is visible in the program log file

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.