My Oracle Support Banner

CFAS Migrate Script Fails with ORA-01400 Error (Doc ID 2388115.1)

Last updated on APRIL 20, 2018

Applies to:

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

Symptoms

In RMS 16.0.1, CFAS (Custom Flex Attributes Solution) Migrate script fails with the below error when running the migrate script in a different environment.

ERROR at line 1: ORA-01400: cannot insert NULL into ("RMS15"."CODE_DETAIL"."REQUIRED_IND").

Steps to reproduce:
1) Create any CFAS which is linked with the list from Code Details.
2) Try to run the migrate script with ALL option to migrate the data to different environment.
3) Run the cfa_all_metadata.sql generated by the migrate script.
4) Note the above error occurs.

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!


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