After R12 Upgrade EGO_ITEM_ASSOCIATIONS Is Empty And Has Only The New Records Created After Upgrade

(Doc ID 2364267.1)

Last updated on MAY 07, 2018

Applies to:

Oracle Fusion Product Hub - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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;
 
  COUNT(*)
----------
  3
 
SQL> select count(*) From FUSION.EGO_ITEM_ASSOCIATIONS_REL8;
 
  COUNT(*)
----------
338494

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.

Cause

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