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

Last updated on JULY 31, 2017

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 John's Coffee or FROG'S Electronics

STEPS TO REPRODUCE:

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

   Customer Name Low: John's Coffee

   Customer Name High: John's Coffee

4. Submit

Cause