My Oracle Support Banner

Unable To Load Replenishment Data For Data Conversion With Failed Constraint Check Error (Doc ID 2706179.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms


Unable to load any replenishment data using the data conversion tool, with below error during data validation: 

Error:

Failed constraint check: (((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or REJECT_STORE_ORD_IND IS NULL) ).

Steps To Recreate:


1) Build conversion file for MASTER_REPL_ATTR.
2) Use REPL_METHOD as 'M' and REJECT_STORE_ORD_IND as NULL.
3) Import the file in data conversion tool.
4) Preform data validation with tool, fails with error mentioned.

Failed constraint check: (((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or REJECT_STORE_ORD_IND IS NULL) ) OR (REJECT_STORE_ORD_IND IS NULL OR ((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or REJECT_STORE_ORD_IND IS NULL) )



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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