My Oracle Support Banner

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

Last updated on MARCH 15, 2019

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.