ORA-01400 Error Running Reverse Population (Batch_Member_Load) for General Ledger Dimension

(Doc ID 1903215.1)

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:

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