My Oracle Support Banner

Error "Failed constraint check" When Validating MASTER_REPL_ATTR (Doc ID 2710486.1)

Last updated on MAY 16, 2022

Applies to:

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

Symptoms

When validating a MASTER_REPL_ATTR.dat file, an error appear, but the file has the correct data.

ERROR
-----------------------
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) )

Steps to replicate:


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

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.