Payables Frequently Asked Questions
The Oracle Fusion ERP Analytics Frequently Asked Questions (FAQs) provide answers to the most commonly asked questions about your analytics experience.
Payable Topics:
- How should I use the Prepayment metrics in the AP Expenses subject area?
- In which document currency can I see the Discount Remaining amount?
- My AP invoice liability amount is split between multiple liability accounts generated based on the SLA accounting rules set up in Oracle Fusion Cloud Applications. Why do I not see all those liability accounts in the AP Aging subject area?
- When does Invoice not show in AP subject areas?
- Why can I see only some unaccounted transactions in Payables?
- Why can’t I reconcile the AP Aging outstanding balance with the Payables trial balance in Oracle Fusion Cloud Applications?
- Why do different subject areas in Accounts Payables show different levels of detail?
- Why doesn’t the invoice amount for invoices with Retainage in Accounts Payables match the invoice amount in the user interface of Oracle Fusion Cloud Applications?
- Why don't I see future dated invoices in AP Aging?
- Why is the Accounting Date in AP Invoices subject area not matching with the actual accounting date?
- Why is the Payments Discount Lost metric in Accounts Payables populated only for the primary ledger?
- Why am I missing month-end snapshots from AR Aging and AP Aging? or What frequency should I run the pipeline data extract for Accounts Receivable and Accounts Payable Functional areas?
- Why do some of the Aging metrics sow the same value in all Aging buckets?
How should I use the Prepayment metrics in the AP Expenses subject area?
Prepayment amount, Applied Prepayment amount, and Available Prepayment amount metrics are available in the AP Expenses subject area. These metrics are designed to work with Prepayment attributes such as Prepayment Number and Prepayment Line Number.
Prepayment Number and Prepayment Line Number attributes are populated for the Prepayment Invoice type as well as for the Applied Prepayment lines in the Standard Invoice.
Prepayment Amount is calculated using the Prepayment Invoice type. Applied Prepayment amount is calculated using the Applied prepayment lines in the Standard Invoice, and the net amount shows the Available Prepayment Amount for a Prepayment Number and Prepayment Line Number.
In which document currency can I see the Discount Remaining amount?
Discount Remaining Amount metric in AP Payments subject area is calculated using "Discount Offered Amount" from AP Invoices fact and "Discount Taken Amount" and "Discount Lost Amount" from AP Payments fact. The formula is Discount Offered Amount - Discount Taken Amount - Discount Lost Amount. For a cross-currency payment (Invoice currency and Payment currency are different), the AP Payment subject area shows the Invoice currency and payment currency when Document currency is selected. Discount Remaining Amount is calculated only in Invoice currency and not Payment currency.
My AP invoice liability amount is split between multiple liability accounts generated based on the SLA accounting rules set up in Oracle Fusion Cloud Applications. Why do I not see all those liability accounts in the AP Aging subject area?
The AP Aging subject area is at the schedule level and can only show one liability account for each schedule. If an invoice has the amount split between multiple liability accounts, it'll only show the default liability account that's populated in the AP invoice header in Oracle Fusion Cloud Applications. If the SLA Accounting also generates only one liability account per invoice, then it'll show the liability account generated by the accounting process.
If your use case is to analyze the liability amount by GL Account and reconcile with General ledger, then use the AP Liabilities subject area.
When does Invoice not show in AP subject areas?
If there are invoices dated prior to the Initial Extract Date (IED), ACCTS_PAY_CODE_COMBINATION_ID is found to be null in AP_Invoices_all, and the Invoiced_on_date is a future period, then the invoice isn't available at the Payment schedules grain.
Why can I see only some unaccounted transactions in Payables?
The AP Invoices and AP Aging subject areas include all invoices (even unaccounted) with a payment schedule. The AP Liability, AP Expense, and AP Payment subject areas include only those invoices that are accounted. The AP Holds subject area includes only those invoices with hold details.
Why can’t I reconcile the AP Aging outstanding balance with the Payables trial balance in Oracle Fusion Cloud Applications?
Fusion Payables Trial balance uses SLA account and accounting date from the accounting distributions. AP Aging is at the invoice schedule level and has the Account code combination and accounting date from the invoice header level. AP Aging supports historical aging and current aging by Invoice date and Schedule date. It can't be used for reconciling account balances with General Ledger.
Why do different subject areas in Accounts Payables show different levels of detail?
If the secondary ledger is set up with a Subledger Conversion level, then you can analyze data for the secondary ledger in the AP Liabilities, Expenses, and Payments subject areas, which use the Accounting Distribution grain. The AP Invoices and AP Aging subject areas use the schedule level, and the AP Holds subject area contains Invoice hold details. These subject areas support only the primary ledger.
Why doesn’t the invoice amount for invoices with Retainage in Accounts Payables match the invoice amount in the user interface of Oracle Fusion Cloud Applications?
AP Invoice shows the invoice amount based on the scheduled payment. Retainage amount is excluded from the payment schedule so the invoice amount in the AP Invoice subject area shows only the invoice amount without Retainage and the amount is different from Oracle Fusion Cloud Applications.
Why don't I see future dated invoices in AP Aging?
The AP Aging subject area only includes open AP invoices with an invoice date until the current open period. Future dated invoices aren't included. If any invoice is created with a future date, it'll be picked up only when invoices are processed for that future date/period.
Why is the Accounting Date in AP Invoices subject area not matching with the actual accounting date?
In the AP Invoices subject area, the Accounting date is from the AP_Invoices_All table, where the Accounting Date is an estimated date and is pre-subledger accounting (SLA). To find the actual Accounting date, refer to the distribution accounting date in the AP Expenses and AP Liabilities subject areas since they are captured only for accounted data.
Why is the Payments Discount Lost metric in Accounts Payables populated only for the primary ledger?
The Discount Lost amount isn't an accounting metric and is calculated by Oracle Fusion Cloud Applications for the Primary Ledger only. For non-Primary Ledgers, this metric doesn't have a value populated. This is the amount that was lost because the payment to the supplier wasn't made by the discount due date.