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:
Oracle Receivables - Version 12.1.3 and laterInformation 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 "A's Customer"
STEPS TO REPRODUCE:
- Navigate to Reports / Accounting
- Query Receipt Journal Report
- Choose parameters:
Customer Name Low: A's Customer
Customer Name High: A's Customer
- Submit
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
Still Have Questions? |
References |