After R12 Upgrade EGO_ITEM_ASSOCIATIONS Is Empty And Has Only The New Records Created After Upgrade
Last updated on MARCH 08, 2018
Applies to:Oracle Fusion Product Hub - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Test Environment is Clone of Production which has been currently upgraded to R12. Noticed that :
Select * from ego_item_associations;
has only 3 records which was created for testing after the upgrade and is missing all the data from R9 PROD environment from where this has been cloned.
On further analysis, we found that the table has been created as part of R12 upgrade script on RUP2 phase during when a backup table of EGO_ITEM_ASSOCIATIONS_REL8 has been created and has the complete records as per R9 PROD:
SQL> select count(*) From FUSION.EGO_ITEM_ASSOCIATIONS;
SQL> select count(*) From FUSION.EGO_ITEM_ASSOCIATIONS_REL8;
There is a difference in the table structure of R12 EGO_ITEM_ASSOCIATIONS (additional column of STYLE_ITEM_ID) & R9 EGO_ITEM_ASSOCIATIONS and hence cannot import it from EGO_ITEM_ASSOCIATIONS_REL8 to EGO_ITEM_ASSOCIATIONS.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms