RI Load nprftildplp.ksh Batch Failed For W_RTL_NPROF_IT_LC_DY_TMP Table

(Doc ID 2347867.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

RI load nprftildplp.ksh batch failed for W_RTL_NPROF_IT_LC_DY_TMP table with below error:

PLP_RetailNetProfitFactLoad
--ORA-00001: unique constraint (RADMPRD.PK_W_RTL_NPROF_IT_LC_DY_F) violated


Steps To Recreate:
1.  Run the package PLP_RETAILNETPROFITFACT.
2. The package fails with the error: unique constraint (RADM01.PK_W_RTL_NPROF_IT_LC_DY_F) violated


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