My Oracle Support Banner

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

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Receivables - Version 11.5.9 to 11.5.10.3 [Release 11.5.9 to 11.5.10]
Information in this document applies to 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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.