My Oracle Support Banner

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 later
Information in this document applies to any platform.

Symptoms

When attempting to apply patch 36048774, the following error occurs:

ERROR
-----------------------
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.