When Customer Names Greater Than 50 Characters, Reports With This Parameter Have No Output Or Error
Last updated on AUGUST 28, 2017
Applies to:Oracle Receivables - Version: 11.5.9
This problem can occur on any platform.
REPORT:ARXBPH - Billing and Receipt History
REPORT: ARXAGE - Aging 4 Bucket Report
REPORT:ARXASR.RDF - Account Status Report
This occurs on Multiple Reports.
While Generating the Billing and Receipts History (ARXBPH) Report:
Running the Report using Parameter = Customer Name High / Low:
Get "No Data Found" on the Output file when the Customer Name contains More than 50 Characters.
Running the same report using that same customer's NUMBER in the Parameter Customer Number High/Low, the report returns valid data.
Submission Parameter Example:
Customer Name Low = ORACLE TEST CUSTOMER NAME THAT CONTAINS 1OVER FIFTY
Customer Name High = ORACLE TEST CUSTOMER NAME THAT CONTAINS 1OVER FIFTY
The No Data Found is present in the Output file of the Report
While generating ARXASR.RDF - Account Status Report the log contains:
REP-0091: Invalid value for parameter 'P_CUSTOMER_NAME_LOW'
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