R12: AP: Unable To Complie Objects After Patch Application, Receive Error SYS_PLSQL_54180_87_1 is invalid after applying a patch
(Doc ID 1152013.1)
Last updated on JULY 10, 2020
Applies to:
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
Symptoms
Invalid object after applying patch:
SYS_PLSQL_54180_87_1 fails to compile
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
SYS_PLSQL_54180_87_1
TYPE APPS
SQL> alter type SYS_PLSQL_54180_87_1 compile;
Warning: Type altered with compilation errors.
SQL> show errors;
Errors for TYPE SYS_PLSQL_54180_87_1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/46 PLS-00201: identifier 'APPS.SYS_PLSQL_54140_2348_1' must be
declared
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
SYS_PLSQL_54180_87_1
TYPE APPS
SQL> alter type SYS_PLSQL_54180_87_1 compile;
Warning: Type altered with compilation errors.
SQL> show errors;
Errors for TYPE SYS_PLSQL_54180_87_1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/46 PLS-00201: identifier 'APPS.SYS_PLSQL_54140_2348_1' must be
declared
Changes
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 |
| Standard Patching Process |
| Patch Wizard |
| Have more questions? |
| References |