My Oracle Support Banner

R12.1:CE: 25097742 Error In 'CAMT Bank Statement Loader' (Doc ID 2207631.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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


On : 12.1.3 version, Bank Statement Load and Import

When attempting to run the Bank Statement Import Execution Report,
the following error occurs.

The exchange rate type is invalid.

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

1. Responsibility: Cash Management - 12.1.3
2. Path: Other -> Requests -> Run
3. Run the following programs:

A) CAMT Bank Statement Loader (CECAMTLD)
B) Bank Statement Import (ARPLABIM)
C) Bank Statement Import Execution Report (CEIMPERR)

The issue happens due to the hardcoding in concurrent program CAMT Bank Statement Loader.
The records are loaded into table CE_STATEMENT_LINES_INTERFACE with USER_EXCHANGE_RATE_TYPE = User.
The value 'User' does not match the records in GL_DAILY_CONVERSION_TYPES table.

The issue has the following business impact:
Due to this issue, users cannot run the Bank Statement Import Execution Report successfully.

Use of ISO20022/SEPA is a new requirement in Norway.



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.