EGO_EXT_FWK_PUB and EGO_USER_ATTRS_COMMON_PVT are invalid during the R12 upgrade

Hi All


During the last upgrade to 12.1.1 (u6678700.drv)  there are some workers failed with errors. Here the some of them:


csegoflx.ldt FAILED
egoefagt.ldt FAILED
arhzexft.ldt FAILED
rrsefagt.ldt FAILED
bomefagt.ldt FAILED
rrsflexlvl.ldt FAILED
mthudaafd.ldt FAILED


In the log there is the following error:
Error loading seed data for DATA_LEVEL: APPLICATION_SHORT_NAME = XX, DESCRIPTIVE_FLEXFIELD_NAME = XXXXXX, DATA_LEVEL_NAME = XXXXXX, ORA-06508: PL/SQL: could not find program unit being called


I opened the ctl file for the ldt's and find that EGO_EXT_FWK_PUB and EGO_USER_ATTRS_COMMON_PVT  packages are in invalid state.


Reason:
The TYPE EGO_ATTR_GROUP_METADATA_OBJ not exists.


Here the action plan to fix this issue:

1. cd $EGO_TOP/patch/115/sql
2. sqlplus apps/.. @EGOPEFCS.pls
3. sqlplus apps/.. @EGOPEFCB.pls
4. @EGOSEFD2.sql <SYSTEM> <SYSTEM_PWD> <APPS>
5. SELECT OWNER
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'TYPE'
AND OBJECT_NAME = 'EGO_ATTR_GROUP_METADATA_OBJ';
(you need to get 1 row "APPS")

6. alter package APPS.EGO_USER_ATTRS_COMMON_PVT compile;

7. alter package APPS.EGO_EXT_FWK_PUB compile;
8. Restart the failed workers



Good Luck ...