Bank Reconciliation Error: FRM-40734: Internal Error: Pl/Sql Error when Reconciling Receipt Batches (Doc ID 421156.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 22-Jul-2013
CEXCABMR.fmb


Symptoms

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

  1. Query a bank statement
  2. Click on Lines button
  3. Click on Find button
  4. Click on Available button
  5. Get error: APP-CE-53021: AR period not open or future (GL_DATE=)
  6. Change the date to a valid period
  7. Click on Reconcile button
  8. 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 :



Changes

When reconciling manually, the fields provided in the Bank Statement Lines window - Exchange tab have to be used for entering the exchange information.

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