R12.1:CE: Bank Statement File Failing In Seeded Program
(Doc ID 2262027.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Cash Management - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.X version, Bank Statement Load and Import
When attempting to Load Bank Statement Data,
the following error occurs.
Cause: FDPSTP failed due to ORA-01407: cannot update ("CE"."CE_STMT_INT_TMP"."REC_ID_NO") to NULL
ORA-06512: at "APPS.CE_BANK_STATEMENT_LOADER", line 3665
ORA-06512: at line 1
The issue can be reproduced at will with the following steps:
1. Responsibility: Cash Management
Production and Development/Test instances
2. Path: Other -> Requests -> Run
3. Run the Load Bank Statement Data
Bank statement file failing in seeded program with the errors:
Cause: FDPSTP failed due to ORA-01407: cannot update ("CE"."CE_STMT_INT_TMP"."REC_ID_NO") to NULL
ORA-06512: at "APPS.CE_BANK_STATEMENT_LOADER", line 3665
ORA-06512: at line 1
NOTE: This issue is occurring with only one specific file.
The user receives a file from this same account daily, and this file is the only one that is having this error.
WORKAROUND: None
The issue has the following business impact:
Due to this issue, users cannot import the transactions.
This file is needed as soon as possible.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |