ODI Error : E-Business Suite Error Creating Index in Full Load With Flexfields Implemented

When you run FULL LOAD for Financial Analytics , you got an error related to flexfied 

Error step in load plan:

3 SDE General Flexfield ->Finalize Flexfield ->EXEC_TABLE_MAINT_PROC

Workaround

1. Do one of the following:
• Delete the duplicate and proceed with the load plan execution.
  Script:

  DELETE  FROM   W_FLEX_SQL_G A WHERE
    a.rowid >  ANY ( SELECT  B.rowid   FROM    W_FLEX_SQL_G B WHERE
       A.DOMAIN_CODE = B.DOMAIN_CODE  AND
       A.DOMAIN_MEMBER_CODE=B.DOMAIN_MEMBER_CODE AND
       A.DATASOURCE_NUM_ID = B.DATASOURCE_NUM_ID
          )     ;
       commit;  
  DELETE  FROM   W_FLEX_COLUMN_G A WHERE
    a.rowid >  ANY ( SELECT  B.rowid   FROM    W_FLEX_COLUMN_G B WHERE
  A.APPLICATION_ID =B.APPLICATION_ID AND
  A.FLEXFIELD_TYPE=B.FLEXFIELD_TYPE AND
  A.FLEXFIELD_CODE=B.FLEXFIELD_CODE AND
  A.CONTEXT_CODE=B.CONTEXT_CODE AND
  A.COLUMN_CODE=B.COLUMN_CODE AND
  A.DATASOURCE_NUM_ID=B.DATASOURCE_NUM_ID
  )     ;    
  commit;
  

• Before starting the load plan, disable bulk mode for steps 3 SDE General
  Flexfield and PRE-SDE:
  - Go to step 3 SDE General Flexfield in load plan and mark ETL_BULK_MODE to N.
  - Go to step 3 PRE-SDE General -> PRE-SDE in load plan and mark
  ETL_BULK_MODE to N.

Regards,

Zafar Habib