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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms