Supplier Compliance Data Rejected in Error Table in RA (Doc ID 2217984.1)

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.

Symptoms

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.

Changes

 

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