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

Last updated on NOVEMBER 25, 2016

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 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) - 55106619_CAMT_Bank_Statement_Loader_261016_log.txt
B) Bank Statement Import (ARPLABIM) - 55106620_Bank_Statement_Import_261016_log.txt
C) Bank Statement Import Execution Report (CEIMPERR) - 55106621_Bank_Statement_Import_Executio_261016_log.tx

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.

 

Cause

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 hundreds of Community platforms