CS_CHARGE_DETAILS_PVT Invalid After Patch 21368064 (Doc ID 2078814.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Install issues in TEST instance

After applying patch Patch 21368064 The following object became invalid

OBJECT_NAME OBJECT_TYPE OWNER
---------------------------------------- -------------------- ---------------
CS_CHARGE_DETAILS_PVT PACKAGE BODY APPS

When trying to compile the same manually the following error occurs


ERROR
-----------------------
Errors for PACKAGE BODY CS_CHARGE_DETAILS_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4074/1 PL/SQL: SQL Statement ignored
4074/8 PL/SQL: ORA-00904: "ORDER_HEADER_ID": invalid identifier
15482/3 PL/SQL: SQL Statement ignored
15482/17 PL/SQL: ORA-00904: "INC"."BUSINESS_PROCESS_ID": invalid
identifier

15524/5 PL/SQL: Statement ignored
15524/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15525/5 PL/SQL: Statement ignored
15525/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15526/5 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
15526/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15527/5 PL/SQL: Statement ignored
15527/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15528/5 PL/SQL: Statement ignored
15528/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15529/5 PL/SQL: Statement ignored
15529/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15530/5 PL/SQL: Statement ignored
15530/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
15531/5 PL/SQL: Statement ignored
15531/34 PLS-00364: loop index variable 'V_INCIDENTS_DEF' use is invalid
SQL>




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 21368064
2. Check for invalids
3. Try to recompile PACKAGE CS_CHARGE_DETAILS_PVT manually



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms