ORA-01400 Error Running Reverse Population (Batch_Member_Load) for General Ledger Dimension
(Doc ID 1903215.1)
Last updated on APRIL 29, 2021
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.
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