Invalid Objects After Applying Patch 33527700
(Doc ID 2989427.1)
Last updated on DECEMBER 04, 2023
Applies to:
Oracle Trade Management - Version 12.2.12 and laterInformation in this document applies to any platform.
Goal
Invalid objects after applying patch 33527700.
OZF_CLAIMS_HISTORY_PKG
The error during compilation is:
SQL> alter package apps.OZF_CLAIMS_HISTORY_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.OZF_CLAIMS_HISTORY_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
199/4 PL/SQL: SQL Statement ignored
295/12 PL/SQL: ORA-00904: "LETTER_DATE": invalid identifier
657/5 PL/SQL: SQL Statement ignored
752/15 PL/SQL: ORA-00904: "LETTER_DATE": invalid identifier
1018/5 PL/SQL: Statement ignored
1299/27 PLS-00302: component 'LETTER_ID' must be declared
SQL>
How to clear these Invalids?
Solution
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
| Goal |
| Solution |
| References |