My Oracle Support Banner

Cash Position Data Transfer Error ORA-01400 cannot insert NULL into FUSION CE_CP_BANK_DIM BANK_NAME (Doc ID 2432595.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion Cash Management Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to run Cash Position Data Extraction process it succeeds but the Cash Position Data Transfer process errors out.
The log shows

JDev Implemented Job Running, ID: 12345
processAllInterface(): Entering:Tue Jul 31 18:37:44 UTC 2018
Duplicated sys transactions deleted: 7
Duplicated statement lines deleted: 0
Duplicated statement headers deleted: 0
processAllInterface(): Finished mapping dimensions and deleting duplicate interface data: Tue Jul 31 18:37:45 UTC 2018
Enter validateInterfaceData()
Exit validateInterfaceData()
Max Stmt Header Id: 5000
Max sys trx Id: 6007
betterPerformDimensionMaintenance(): Entering...
recordDimensionMaintenance(): Entering...
ce_cp_gl_periods_dim recorded.
ORA-01400: cannot insert NULL into ("FUSION"."CE_CP_BANK_DIM"."BANK_NAME")

Performing dimension maintenance failed,rolling back...
ORA-01400: cannot insert NULL into ("FUSION"."CE_CP_BANK_DIM"."BANK_NAME")



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.