Payment Status shows ~No Value~ in CAA

Question

My user often creates payables subledger analyses. After migrating reports to CAA, I can no longer view the Payment Status of an invoice when adding invoice journal details to the analysis. Key fields used are journal name, batch, invoice number, net transaction amount, payment status. When pulling payment status into this query, the value shows as "~No Value~". The correct value appears only for payments journals, but these are not the accounts being analyzed. Can we add something else to the visualization to make the payment status for an invoice appear?

RVohra · Answer

I agree this ( approach suggested by Sushil )  might work in this situation. I have not got a chance to work on it so would like to see if it works for you. Thanks

Sushil Dhoot-Oracle · Answer

You may consider using Semantic Model extensions and validate the results, it should work if there is a one to one relationship between payments and invoices.

RVohra · Answer

If you're limited in what the CAA subject area exposes and open to BIP Model:

* Create a BI Publisher Data Model that joins:* AP_INVOICES_ALL
* AP_INVOICE_PAYMENTS_ALL
* AP_PAYMENT_SCHEDULES_ALL
* AP_CHECKS_ALL
* XLA_AE_HEADERS and XLA_AE_LINES (for journal info)

From here, you can build a report that:

* Pulls invoice journal entries
* Joins them to payments (if available)
* Displays Payment Status alongside journal details