"CS_ESTIMATE_DETAILS_PKG" Invalid After Patch 30566914:R12.CS.C (Doc ID 2807212.1)

Last updated on SEPTEMBER 15, 2021

Applies to:

Symptoms

On : 12.2.5 version, Charges UI, APIs, and schema

ACTUAL BEHAVIOR
---------------
New Invalid after Patch 30566914:R12.CS.C

Below is the new Invalid after patching.

SQL> alter package APPS.CS_ESTIMATE_DETAILS_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.CS_ESTIMATE_DETAILS_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
243/4 PL/SQL: SQL Statement ignored
424/5 PL/SQL: ORA-00904: "PRICE_ADJ_DETAILS": invalid identifier
901/5 PL/SQL: SQL Statement ignored
1271/73 PL/SQL: ORA-00904: "PRICE_ADJ_DETAILS": invalid identifier
SQL>
SQL>
 

EXPECTED BEHAVIOR
-----------------------
Expect the object to be invalid


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 30566914:R12.CS.C
2. Check for invalids

Cause

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