When Customer Names Greater Than 50 Characters, Reports With This Parameter Have No Output Or Error (Doc ID 307979.1)

Last updated on NOVEMBER 27, 2008

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

Symptoms

This occurs on Multiple Reports.

A.

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

 

B.

While generating ARXASR.RDF - Account Status Report the log contains:

REP-0091: Invalid value for parameter 'P_CUSTOMER_NAME_LOW'

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