Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Payables Invoices - Transactions Real Time - does not return all invoices

in Reporting and Analytics for ERP 2 comments

Summary:

Payables Invoices - Transactions Real Time - does not return all invoices

Content (please ensure you mask any confidential information):

Hi - if I run this SQL in a data model, 17 invoices are returned:

select invoice_id
from ap_invoices_all
where invoice_id between 260150 and 260170
order by invoice_id

If I create an Analysis and use the "Payables Invoices - Transactions Real Time" Subject Area, and add a filter on Invoice ID, only 4 invoices are returned:

Is anyone able to explain why the OTBI results are different to the SQL results?

The invoices returned by SQL all have associated invoice lines, distributions, have a supplier etc. etc. But for some reason, the OTBI Analysis doesn't return the same invoices.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!