My Oracle Support Banner

Bank Statement Loader Errors With FDPSTP failed due to ORA-01400: cannot insert NULL into ("CE"."CE_SQLLDR_ERRORS"."BANK_ACCT_CURRENCY_CODE") (Doc ID 2004391.1)

Last updated on NOVEMBER 14, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Bank Statement Load and Import

When attempting to submit the Bank Statement Loader the following occurs:

ERROR
-----------------------
ORACLE error 1400 in FDPSTP

Cause: FDPSTP failed due to ORA-01400: cannot insert NULL into ("CE"."CE_SQLLDR_ERRORS"."BANK_ACCT_CURRENCY_CODE")
ORA-06512: at "APPS.CE_SQLLDR_ERRORS_PKG", line 10
ORA-06512: at "APPS.CE_BANK_STATEMENT_LOADER", line 371

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Submit the Bank Statement Loader.
2. Note the Errors in the Log File.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load bank statements into the interface tables, and proceed with reconciliation of transactions.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.