Plp_retailnetprofitfactload Fails with Error 'Unique Constraint (PRDRADM.pk_w_rtl_nprof_it_lc_dy_f) (Doc ID 2266690.1)

Last updated on MAY 23, 2017

Applies to:

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

Symptoms

PLP_RETAILNETPROFITFACTLOAD Fails with unique constraint pk_w_rtl_nprof_it_lc_dy.

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