CFAS Migrate Script Fails with ORA-01400 Error
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.
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 hundreds of Community platforms