PA_BILLING Package Body Invalid After Applying Patch 36048774
(Doc ID 3044639.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
Oracle Project Billing - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to apply patch 36048774, the following error occurs:
-----------------------
Errors for PACKAGE BODY APPS.PA_BILLING:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4904/1 PL/SQL: SQL Statement ignored
4911/6 PL/SQL: ORA-00904: "POBG_ID": invalid identifier
4953/3 PL/SQL: SQL Statement ignored
4955/12 PL/SQL: ORA-00904: "POBG_ID": invalid identifier
5221/4 PL/SQL: SQL Statement ignored
5225/5 PL/SQL: ORA-00904: "GTT"."POBG_ID": invalid identifier
5234/5 PL/SQL: SQL Statement ignored
5340/9 PLS-00364: loop index variable 'REV_GRP' use is invalid
5340/17 PL/SQL: ORA-00984: column not allowed here
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download patch 36048774
2. Apply patch 36048774
3. Check the error.
Changes
As per Bug 36986693 - PA_BILLING PACKAGE BODY INVALID AFTER APPLY PATCH 36048774,issue was caused by the helper for 2 tables (PA_REV_GRP_GTT and PA_REV_GRP_GTT) that were on APPS schema which failed during the dropping of old tables and creation of the synonyms.
Due to this resulted in two missing tables that package PA_BILLING requires.
The helper for 2 GTTs that were on APPS schema failed during the dropping of old tables and creation of the synonyms,resulting in 2 missing tables that package PA_BILLING requires.
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 |
Changes |
Cause |
Solution |
References |