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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!