Receipt Journal Report Ends in Rep-4 Error When Customer name Parameter Contains the Quote Character (') (Doc ID 2031838.1)

Last updated on AUGUST 25, 2020

Applies to:

Symptoms

On : 12.1 version, Reports Issues

When attempting to run RECEIPT JOURNAL REPORT the following error is showing in the report log

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

Enter Password:
REP-4: Warning: Unable to open user preference file.
MSG-01001: Checking if there any periods other than closed and closed pending
ORA-933: SQL command not properly ended
lk.unrounded_accounted_dr, lk.unrounded_entered_dr) ) C_AMOUNT FROM
ar_cash_receipt_history crh , ar_distributions d , xla_ae_headers hd ,
xla_distribution_links lk , xla_ae_lines ae , gl_code_combinations gc ,
ar_bat
REP-69: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: MSG-01001: Checking if there any periods other than closed and
closed pending
ORA-933: SQL command not properly ended
lk.unrounded_accounted_dr, lk.unrounded_entered_dr) ) C_AMOUNT FROM
ar_cash_receipt_history crh , ar_distributions d , xla_ae_headers hd ,
xla_distribution_links lk , xla_ae_lines ae , gl_code_combinations gc ,
ar_bat

This error happens only for customer with quote character (')  in the customer's name, like "A's Customer" 

STEPS TO REPRODUCE:

1. Navigate to Reports / Accounting
2. Query Receipt Journal Report
3. Choose parameters:

   Customer Name Low: A's Customer

   Customer Name High: A's Customer

4. Submit

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.