There are around 1000 plus invalid objects, while looking further observed that this object do not exist in current run edition and there are
duplicate/multiple entries observed for RUN and PATCH edition in database which is strange.
SQL> alter package APPS.WSM_WLT_VALIDATE_PVT compile body;
alter package APPS.WSM_WLT_VALIDATE_PVT compile body
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of APPS.WSM_WIP_LOT_TXN_PVT
ORA-38802: edition does not exist
SQL> SELECT SYS_CONTEXT(‘USERENV’, ‘SESSION_EDITION_NAME’) AS edition FROM dual;
EDITION
——————————————————————————–
V_20181108_0332
Validated editions in database, $AD_TOP/sql/ADZDSHOWED.sql returns two rows for old and current edition
=========================================================================
= Editions
=========================================================================
Edition Name Type Status Current?
————— ——– ——– ——–
V_20171128_0547 ACTIVE
V_20180704_0342 ACTIVE
V_20180705_0253 ACTIVE
V_20181102_1332 OLD ACTIVE <<<<<<<<<<
V_20181102_1332 OLD ACTIVE <<<<<<<<<<
V_20181108_0332 RUN ACTIVE CURRENT <<<<<<<<<<
V_20181108_0332 RUN ACTIVE CURRENT <<<<<<<<<<
Cause:
Every time we perform online patching , there will an old database edition entry and this will accumulate as and when we do more online patching’s.
Oracle suggests that we perform actualize_all after this reaches a count of 25. However it would be time consuming to perform the cleanup after the count has increased.
If the number of these grows too large, system performance will start to be affected. When the number of old database editions reaches 25 or more, you should consider dropping all old database editions by running the adop actualize_all phase and then performing a full cleanup.
Solution:
The system has the recommended database patches and latest AD-TXK code level installed.
To proceed, run the following commands in the order shown:
$ adop phase=prepare
$ adop phase=actualize_all
$ adop phase=finalize finalize_mode=full
$ adop phase=cutover
$ adop phase=cleanup cleanup_mode=full
Compile invalid objects using utlrp script.
Edition Name Type Status Current?
————— ——– ——– ——–
V_20181108_0332 RUN ACTIVE CURRENT <<<<<<<<<<
V_20181108_0332 RUN ACTIVE CURRENT <<<<<<<<<<
