Last updated on JULY 03, 2017
Applies to:Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.
scmplildsde.ksh job loads the stage table W_RTL_SUPPCM_IT_LC_DY_FS and the job scmplildsil.ksh loads the records in W_RTL_SUPPCM_IT_LC_DY_TMP table from stage and then merge all the records of temp table to W_RTL_SUPPCM_IT_LC_DY_F target table. Supplier Compliance Data rejected in error table in RA. All the records from stage table got rejected while inserting in temp table.
Steps To Recreate:
1. Run scmplildsde.ksh job.
2. Run scmplildsil.ksh and prddimlkuptmpplp.ksh at the same time. If W_PRODUCT_D_RTL_TMP table is in truncated state and at the same time supplier compliance fact records are inserting, there will be product dimension lookup failure.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms