Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Payment Status shows ~No Value~ in CAA

Received Response
41
Views
4
Comments
Molly P
Molly P Rank 5 - Community Champion
in Oracle Fusion ERP Analytics

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?

Tagged:

Answers

  • Sushil Dhoot-Oracle
    Sushil Dhoot-Oracle Mod

    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
    Molly P Rank 5 - Community Champion

    @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
    RVohra Rank 6 - Analytics Lead

    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
    Sushil Dhoot-Oracle Mod

    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.