Unable to link multiple subject areas in OTBI report

Hi,

I created an OTBI report with PO and Invoice details such as PO number, PO lines, PO amount, Invoice number, Invoice amount, Transaction currency and Ledger/Accounting currency.

I added the PO details such as PO number, BU, PO line number, line amount, Invoice number and Invoice amount from Subject area - Procurement Procure to pay real time and added Total PO Amount from Procurement - Purchasing Real time subject area and the report showed the data properly.

For the Invoice and Ledger currency I added columns from subject area - Payables Invoice - Transaction real time, but the data is showing as blank (Ref. Image below), even the data from existing columns - Invoice number, amount and ID became blank when I added the Invoice ID and number columns from the payables subject area.