AR To GL Reconciliation Report Completes in Error - ORA-01756: Quoted String Not Properly Terminated ORA-06512 (Doc ID 1916060.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Reconciliation

Attempting to run the AR to GL Reconciliation report and receive the following error:

ERROR
-----------------------
java.sql.SQLSyntaxErrorException: ORA-01756: quoted string not properly terminated
ORA-06512: at "APPS.ARP_RECON_REP", line 4402
ORA-01756: quoted string not properly terminated
ORA-06512: at line 1

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Control > Run
Run the AR to GL Reconciliation report
Click on button 'Language Settings'
Change ".," in ".'" before running the report

Changes


 

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