11i (AR.O): Valueset AR_RAXINV_TRX_NUMBER Takes a Long Time to Populate

(Doc ID 1345760.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Report:RAXINVPR.RDF - Invoice Print Preview Report


Symptoms

Attempting to submit the concurrent program: Invoice Print Preview Report (RAXINVPR).
The parameter: Transaction Number Low takes around 90 minutes to populate. 
This Parameter is associated to the Value Set: AR_RAXINV_TRX_NUMBER.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Control > Run > Request
Select Concurrent Program: Invoice Print Preview Report
Enter Parameters:
a. Print Choice = 'All new Invoices' --- Any value
b. Open Invoices Only = 'Yes' --- Any value
c. Transaction Type = NULL
d. Transaction Number Low = '200000%'
3. List of Values on parameter 'Transaction Number Low' takes 50 to 90 min to execute

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