ORA-01400 Error Running Reverse Population (Batch_Member_Load) for General Ledger Dimension
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA), the Reverse Population program (Batch_Member_Load) always fails for the General Ledger dimension and the tables OFSA_LEAF_DESC and OFSA_DETAIL_OTHER_COA are not populated. The following error exists in FSI_MESSAGE_LOG:
Oracle Error. ORA-01400: cannot insert NUL into ("<atomic user>"."OFSA_DETAIL_OTHER_COA"."COMMON_COA_ID")
This prevents you from running programs that use the data in OFSA_LEAF_DESC and OFSA_DETAIL_OTHER_COA.
Steps to Reproduce:
1. Go to Operations > Batch Maintenance
2. Create a new Batch and Task with the following:
Component: TRANSFORM DATA
Rule Name: Batch_Member_Load
Parameter List: 2,null,2
3. Go to Batch Execution and run the batch.
The batch fails.
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