My Oracle Support Banner

Only a certain number of Invoices are showing under a Consolidated invoice (Doc ID 392976.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Lease and Finance Management - Version 11.5.10 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.

Symptoms


One is not able to view more than XXX (could be any number) invoices under a single consolidated
invoice that has been created from Lease Management.

Run the following query to find the number of invoices under a certain Consolidated invoice:

SELECT trx.INTERFACE_HEADER_ATTRIBUTE1 "Cons INV",
trx.trx_date, trx.trx_number,trx.INTERFACE_HEADER_CONTEXT
FROM ra_customer_trx_all trx
WHERE trx.INTERFACE_HEADER_ATTRIBUTE1='&enter_consolidated_invoice_number'
order by 3


From Lease Management User

Operations > Invoices

Search Based On : Consolidated Invoice

Only XXX  Invoices are visible. Which is less than what has been returned by the previous query.







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

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