Bank Reconciliation Error: FRM-40734: Internal Error: Pl/Sql Error when Reconciling Receipt Batches
(Doc ID 421156.1)
Last updated on MAY 31, 2018
Applies to:Oracle Receivables - Version 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Information in this document applies to any platform.
Manually reconciling a remittance batch in a currency different than functional currency in Cash Management raises the following error:
FRM-40734 Internal Error: PL/SQL ERROR OCCURRED
Steps to Reproduce:
Responsibility: Cash Management User
Navigation: Bank Reconciliation > Bank statements
- Query a bank statement
- Click on Lines button
- Click on Find button
- Click on Available button
- Get error: APP-CE-53021: AR period not open or future (GL_DATE=)
- Change the date to a valid period
- Click on Reconcile button
- Get error: FRM-40734: INTERNAL ERROR: PL/SQL ERROR OCCURRED
The error seems to be caused by table GL_DAILY_RATES. The trace file shows the select below returns no rows :
When reconciling manually, the fields provided in the Bank Statement Lines window - Exchange tab have to be used for entering the exchange information.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!