Oracle Fusion Analytics (Fusion Analytics), a part of the Oracle Fusion Data Intelligence Platform, is a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications that provide ready-to-use insights to help improve decision-making. It’s extensible and customizable, allowing customers to ingest data and expand the base semantic model with additional content.

In addition to the pre-built content FDI offers in each pillar, we have an ongoing effort to provide more reusable artifacts for FDI which is described in this blog.

In this post we are sharing a reusable workbook that analyses AP Aging amounts, both current and overdue amounts, by Suppliers, Business Units. The target audience is a Payables Manager who can analyze the outstanding and aging payments and take decisions on improving the payables related KPIs. 

NOTE: If you experience any issues importing this workbook or running it, it may be likely that your environment is on a version of FDI and/or OAC that is lower than the version used for developing this workbook. Update/upgrade timings are dependent on the data center your instance is in. We recommend waiting until your instance is upgraded to the latest version before importing and using this workbook.

Functional Areas

Accounts Payable

Subject Areas

• Financials – AP Aging

Business Use Case

Empower Payables Managers to analyze Aging Amounts by Time, Supplier, Aging Buckets and Supplier Country. 

Pre-Requisites:

• Before using this workbook ensure that filter values are appropriately set for fiscal calendar, Payables Invoicing Business Unit Name, Supplier Name and Aging Period Name, to run the optimal query. Validate the data for accuracy before rolling out to business users.

Attachments

“Financials – AP Aging Details” workbook details.

This Dashboard analyses AP invoices, including debit and credit memos, with respect to aging details, current, and overdue positions. Also, this workbook analyses the historic trend of AP balances at an aggregate level over time. You can split the invoice details and AP balances by time, supplier details, business units, invoice details, GL account, GL balancing segments, GL cost center, and non-qualifying GL segments of chart of accounts.

Balances Trend: This canvas shows the AP balances trending for a particular supplier over last eight quarters..

Average Time to Pay: This canvas provides details of the average time available to pay off outstanding AP invoices. 

Aging: This canvas provides details of the summary of AP invoices across aging buckets, count, and value. 

AP Invoices Overdue: This canvas provides the AP Invoices Overdue count as well as amount by Fiscal Quarter and Payables Business Unit Name. From here, user can right-click on a Fiscal Quarter data point and navigate to the Invoice Overdue details for that Fiscal Quarter.

Right-Click on any of the bar and select AP Invoice Overdue Details

AP Invoice Overdue Details – This canvas provides the details of the AP Overdue invoices.

General Guidelines and Best PracticesHere some guidelines and recommendations to adapt these workbooks to your environment. Additionally, review the information provided on the workbook Help page (if any) to ensure the workbook renders data after you select the appropriate options and filters.

• Download the workbook from the above attachment section and import the workbooks to your instance. Note: These workbooks don’t have passwords, in general. Password, if any will be explicitly called out.
• Ensure you download only the workbooks relevant to the pillar and functional areas activated for your FDI instance.
• All the workbooks will have a Help page containing required information and guidance on how to use the workbook. Be sure to follow these instructions before using the workbooks on your instance.
• Note, workbooks cover only generic use case / business scenario. Review the workbook content, make any changes as needed, and set the appropriate filters – especially those related to time dimensions and other dimensions based on the pillar / functional area.
• While making modifications, follow the best practices and generic / pillar specific authoring tips. Here are the pillar specific authoring tips link. Ensure to use the latest FDI documentation links for latest information on authoring tips and guidelines -

- Fusion CX Analytics Authoring Tips

- Fusion ERP Analytics Authoring Tips

- Fusion HCM Analytics Authoring Tips

- Fusion SCM Analytics Authoring Tips

• It is highly recommended that you perform basic sanity checks and data validity before rolling out workbooks to business users and analysts.