My Oracle Support Banner

After Upgrade to R12.PJ_PF.C.Delta.13, PA_IGT_GTC_PKG is Invalid and Errors With 'ORA-00904: "BIZ_APP_TYPE": invalid identifier' (Doc ID 3045510.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

Oracle Project Billing - Version 12.2.13 and later
Information in this document applies to any platform.

Symptoms

After applying R12.PJ_PF.C.Delta.13, package PA_IGT_GTC_PKG is invalid.  When manually recompiling, the following error is received: 

SQL> alter package PA_IGT_GTC_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY PA_IGT_GTC_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10/3 PL/SQL: SQL Statement ignored
82/5 PL/SQL: ORA-00904: "BIZ_APP_TYPE": invalid identifier

 

Steps to Reproduce:

1.  Apply R12.PJ_PF.C.Delta.13 and note PA_IGT_GTC_PKG is invalid
2.  Manually recompile PA_IGT_GTC_PKG and get the above error

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.