My Oracle Support Banner

R12.1:CE: Bank Statement File Failing In Seeded Program (Doc ID 2262027.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

On : 12.1.1 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.

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
Cause
Solution


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