My Oracle Support Banner

Intragovernmental Performance Integration To Payables Program Errors With FDPSTP failed due to ORA-04063 (Doc ID 2853608.1)

Last updated on MARCH 08, 2022

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

After applying recent controlled IGT Receiving side patch 33677950:R12.PO.D, the Intragovernmental Performance Integration to Payables Program errors


ERROR
-------------------
[09-FEB-2022 16:26:23]: **Starts**
[09-FEB-2022 16:26:24]: **SQL error and free**
[09-FEB-2022 16:26:24]: ORACLE error 4063 in FDPSTP

Cause: FDPSTP failed due to ORA-04063: package body "APPS.PO_IGT_PERF_INV_INTG_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PO_IGT_PERF_INV_INTG_PKG"
ORA-06512: at line 1

Upon compilation "APPS.PO_IGT_PERF_INV_INTG_PKG" we received error
Error(1615,4): PLS-00201: identifier 'IGT_PERF_INTG_ERR_PKG.INITIALIZE' must be declared

STEPS
-------------------
1. Apply Patch 33677950:R12.PO.D
2. Using Purchasing responsibility, navigate to Reports -> Run
2. Run Intragovernmental Performance Integration to Payables Program
3. Errors occur

BUSINESS IMPACT
-----------------------
Expectation is that the patch would not cause errors

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.