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

Last updated on JULY 31, 2017

Applies to:

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

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

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