My Oracle Support Banner

R12:CE: CEJECRN Bank Statement Cashflow Creation Program Ends In Error "ORA-06512" "EXCEPTION in Determine_exchange_info" (Doc ID 2973608.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Oracle Cash Management - Version 12.1 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Bank Statement Cashflow Creation Program ends in error

ERROR
-----------------------

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.CE_JE_CREATION", line 1043
ORA-06512: at "APPS.CE_JE_CREATION", line 840
ORA-06512: at "APPS.CE_JE_CREATION", line 511
ORA-065
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
>> create_journal
>>lock_statement_line
>>Process_statement_line
>>Determine_cleared_date
>>valid_accounting_date
cleared date sl effective date: xx-xx-xx
<>> Currency_type
sys xchange_rate_date=CFD
calling gl_currency_api
>>Determine_exchange_info
ba_curr=USD
sys_curr=CAD
cf_clared_ex_date=XX-XX-XX
stmt_line_id=230348
cf_cleared_ex_type=Spot
EXCEPTION in Determine_exchange_info
1User-Defined Exception
EXCEPTION in processing statement line
1User-Defined Exception
Exception in create_journal
1User-Defined Exception


Steps to Reproduce:
--------------------------
1)Login to Cash Management Responsibility.
2)Other > Requests > Run > Run Bank Statement Cashflow Creation program, it ends in error

 

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.