My Oracle Support Banner

Issue in Data Conversion During Data Validation For Items (Doc ID 2668044.1)

Last updated on MAY 19, 2020

Applies to:

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

Symptoms

Items Data Conversion fails with the below data validation errors.

1) Failed constraint check: (orderable_ind = 'N' and pack_type is null) or (orderable_ind = 'Y' and pack_type in ('V','B'))
2) Failed constraint check: ((orderable_ind = 'Y' and pack_type = 'B' and order_as_type is not null) or (orderable_ind = 'N' and order_as_type is null) or (sellable_ind = 'Y' and order_as_type is null) or (pack_type = 'V' and order_as_type is null)) and order_as_type in ('E','P')

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
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.