Payables Payments – Disbursements Real Time Subject Area Join/data Issue (Doc ID 2482154.1)

Last updated on AUGUST 01, 2022

Applies to:

Goal

When working in the Payables Payments – Disbursements Real Time subject area, user is seeing strange behavior where invoices are inner joined to the payments.
Using this subject area to see payables invoices and payables payments associated with the invoices is the intended use by end users.
The subject area will restrict row count to invoices that have payments and does not show a full listing of invoices (outer joined to the payments).

Is this intended functionality and if so, what is the suggested workaround to achieve the functionality described to use a cross-subject area analysis with invoice information pulled from 'Payables Invoices - Transactions Real Time' and payment information from 'Payables Payments – Disbursements Real Time'?
 

Solution

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