Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amounts

Summary:

Payables Invoices –Transactions Real Time Subject Area is not returning correct 

The OTBI Report with subject area Payables Invoices – Transactions Real Time has columns 

Header Level
Business unit, Supplier, Supplier number, General information invoice description, Invoice number, Invoice date, Invoice cancelled date, 

Invoice hold name, Invoice hold reason, Hold release name, Line hold name, Line hold reason, line release name. 

Line Level
Invoice line amounts, Invoice line details Purchase order number, PO line num, 

Distributions Level
Invoice distribution details purchase buyer name

The Prompt for the report is Business Unit. The filters used are Line hold release name is null and Invoice cancelled date is null and Hold release name is null and hold name is not null or line hold name is not null.