Payment Status shows ~No Value~ in CAA

Molly P

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?

Sushil Dhoot-Oracle

Hi Molly, the "Payment Status" that you see in CAA currently or even GL Account Account Analysis earlier is the status of payment transaction like Issued, Void, Reconciled, Negotiated, etc. and it works with Payment transactions and related journals. If you are looking for Invoice Payment Status, then its not supported as a column by design because Payment Status is at the Invoice Installment level and the data grain of AP Invoices in CAA is at the distributions.

Molly P

@Sushil Dhoot-Oracle Thank you for this explanation. So there is no workaround to achieve this because of the level the subjects are designed at?

Thanks,

Molly

RVohra

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

Sushil Dhoot-Oracle

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

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