1. Cloud
  2. Guides
  3. Tours
  4. Concepts
  5. Tools
  6. References
  7. Integrations
  8. Data applications
    1. Incorta Data Delivery
    2. Oracle Cloud ERP data app
      1. Installation and Configuration
      2. Analyze Financials and Supply Chain
      3. Analyze Human Capital Management
      4. FAQs and Troubleshooting
    3. Oracle EBS data app
    4. Salesforce data app
    5. BlackLine
    6. XLCubed Excel plugin dashboards for SAP ECC
    7. NetSuite data app
    8. SAP S/4HANA Financials and Supply Chain data app
    9. Data app Data Wizard
  9. Releases

Data Applications → Oracle Cloud ERP Financials and Supply Chain

Learn how this data application helps meet your business goals.

Overview

The Incorta Oracle Cloud Enterprise Resource Planning (ERP) data application provides a new, faster, more effective option for analyzing and understanding your data, with no data modeling or extracting, transforming, and loading (ETL) required. You will get instant access to up-to-date, consolidated ERP data and can build all the high-performance reports you need.

With an extensive library of prebuilt content, Oracle Cloud ERP users gain immediate access to rich content areas and sample dashboards that are easily customizable and logically grouped by department and persona to help answer the most-pressing business questions quickly.

In addition, the Oracle Cloud ERP data applications expedite your organization’s migration from legacy reporting tools and drastically speed up your Oracle Cloud ERP-based reporting and analytics project’s time to value. They also let you add new data sources to your Oracle Cloud ERP analysis more quickly.

For business benefits, refer to the data application on Incorta.com.

Modules and dashboards

This data application consists of these Oracle Cloud ERP financials and supply chain planning modules:

  • Payables
  • Receivables
  • General Ledger (GL)
  • Fixed Assets
  • Purchasing

It includes customizable dashboards for these business flows:

  • Order to Cash
  • Procure to Pay

Requirements

Before configuring this data application, your Oracle Cloud ERP administrator must create a single user with access to the Oracle Cloud ERP Business Intelligence Cloud Connector (BICC) and Universal Content Management (UCM). The Oracle Cloud ERP BICC URL must be accessible by Incorta.

For instructions, refer to the Create BICC user and assign roles and Create UCM user and assign roles in the Oracle Help Center.

Available Schemas

Below is a list of the physical and business schemas in Incorta available after you install the data application:

Business SchemaPhysical Schema
FusionARCashReceiptsFusion_AR
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_PARTY_COMMON
FusionBillingAndTaxFusion_AR
Fusion_AR_MV
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_PARTY_COMMON
Fusion_ITEM_COMMON
Fusion_HR_COMMON
FusionCollectionsManagerFusion_AR
Fusion_AR_SNP
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_PARTY_COMMON
Fusion_HR_COMMON
FusionEmployeeExpenseManagementFusion_AP
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_HR_COMMON
FusionFixedAssetsDetail
Fusion_FA
Fusion_PARTY_COMMON
FusionGeneralLedgerFusion_GL
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_PARTY_COMMON
FusionInventoryItemFusion_INV
Fusion_ITEM_COMMON Fusion_PARTY_COMMON
Fusion_CAL_COMMON
Fusion_HR_COMMON
FusionItemListFusion_ITEM_COMMON
Fusion_FLX_COMMON
FusionMaterialTransactionsFUSION_INV
Fusion_ITEM_COMMON
Fusion_PARTY_COMMON
Fusion_FLX_COMMON
FusionOrderManagementFusion_ONT
Fusion_AR
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_ITEM_COMMON
Fusion_HR_COMMON
Fusion_PARTY_COMMON
FusionPayablesHoldsAndDiscountFusion_AP
Fusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_ITEM_COMMON
Fusion_PO
Fusion_PARTY_COMMON
FusionPayablesTransactionsFusion_AP
Fusion_CAL_COMMON
Fusion_FIN_COMMON
Fusion_ITEM_COMMON
Fusion_PARTY_COMMON
Fusion_PO
Fusion_PRJ
FusionProjectFinancialsFusion_GMS
Fusion_PRJ
Fusion_CAL_COMMON
Fusion_FIN_COMMON
Fusion_PARTY_COMMON
Fusion_FLX_COMMON
FusionPurchaseOrderFusion_PO
Fusion_CAL_COMMON
Fusion_ITEM_COMMON
Fusion_HR_COMMON
Fusion_FLX_COMMON
Fusion_PARTY_COMMON
FusionReconciliationMetricsFusion_XLA
Fusion_XLA_MV
Fusion_AR
Fusion_AP
Fusion_FIN_COMMON
Fusion_HR_COMMON
Fusion_SourcingFusion_SRC
Fusion_HR_COMMON
Fusion_PARTY_COMMON
FusionSpendOverviewFusion_FIN_COMMON
Fusion_CAL_COMMON
Fusion_HR_COMMON
Fusion_ITEM_COMMON
Fusion_PO
Fusion_PARTY_COMMON
FusionSupplierPaymentsOverview
Fusion_AP
Fusion_FIN_COMMON
Fusion_HR_COMMON
Fusion_CAL_COMMON
Fusion_PARTY_COMMON

Available Dashboards

Below is a list of the dashboard in Incorta available after you install the data application in the Oracle Cloud ERP Data App folder:

Folder nameDashboard nameInsight name
1- Cloud Financials/Fixed Assets1 - Fixed Assets Overview
  ●  Asset Category
  ●  Asset Value by Book
  ●  Asset Value by Location
  ●  Details
  ●  Pivot
  ●  YoY Asset Count Trend
1- Cloud Financials/Fixed Assets2 - Fixed Assets Depreciation
  ●  Asset Category
  ●  Depreciation Expense Trend
  ●  Details
  ●  Pivot
  ●  Top 10 Account by Acc Depreciation
1- Cloud Financials/Fixed Assets3 - Fixed Assets Retirement
  ●  Details
  ●  Pivot
  ●  Retired Cost & Gain / Loss Trend
  ●  Retired Cost by Category
1- Cloud Financials/Fixed Assets4 - Fixed Assets Details
  ●  Category Summary, double click to drill
  ●  Details
  ●  Location Summary, double click to drill
1- Cloud Financials/GL/Reconciliation with Sub-Ledgers1 - AR Account SummaryAR Reconciliation Summary (Click on * to drill)
1- Cloud Financials/GL/Reconciliation with Sub-Ledgers2 - AP Account SummaryAP Reconciliation Summary (Click on * to drill)
1- Cloud Financials/GL/Reconciliation with Sub-Ledgers/Drill Reports1 - Fusion AR Account Mismatches
  ●  In GL Not in XLA
  ●  In XLA Not in GL (Click on * to drill)
  ●  Unposted Journals
1- Cloud Financials/GL/Reconciliation with Sub-Ledgers/Drill Reports2 - Fusion AP Account Mismatches
  ●  In GL Not in XLAIn XLA Not in GL (Click on * to drill)
  ●  Unposted Journals
1- Cloud Financials/GL/Reconciliation with Sub-Ledgers/Drill ReportsFusion AR drill
  ●  Invoice Details
  ●  Receipts
1- Cloud Financials/GL/Trial Balance and Journals0 - GL Summary
  ●  Journal Status by Batch
  ●  Journal Status by Source
  ●  Reconciliation Summary
  ●  Top 10 LE & Accounts by Unposted Journals
  ●  Trial Balance
1- Cloud Financials/GL/Trial Balance and Journals1 - GL Journals to AR
  ●  Journal Amount by Batch
  ●  Journal Amount by Category
  ●  Sub ledger Details
1- Cloud Financials/GL/Trial Balance and Journals2 - GL Journals to AP
  ●  Journal Amount by Account
  ●  Journal Amount by Batch
  ●  Journal Amount by Category
1- Cloud Financials/GL/Trial Balance and Journals3 - Balance Sheet
  ●  Details
  ●  Summary
1- Cloud Financials/GL/Trial Balance and Journals4 - Income statement
  ●  Details
  ●  Summary
1- Cloud Financials/GL/Trial Balance and Journals5 - Trial Balance
  ●  Trial Balance (Drill to Journal)
  ●  Trial Balance
1- Cloud Financials/GL/Trial Balance and Journals/Drill ReportsFusion AP PO Details
  ●  Invoice Details
  ●  PO Details
  ●  Supplier Summary
1- Cloud Financials/GL/Trial Balance and Journals/Drill ReportsFusion AR InvoicesInvoice Details
1- Cloud Financials/GL/Trial Balance and Journals/Drill ReportsGL Journal Details
  ●  Journal Amount by Batch
  ●  Journal Amount by Category
1- Cloud Financials/Payables1. Payables Overview
  ●  Invoice Details
  ●  Shipment Details
  ●  Top 20 Suppliers
  ●  Top Buyers
  ●  Top Supplier with Open Holds
1- Cloud Financials/Payables1. Payables Spend
  ●  Invoice Details
  ●  Spend Trend
  ●  Total Spend by Account
  ●  Which PO Items make up Top 80% of the Spend?
  ●  Which Suppliers make up the Top Spend?
1- Cloud Financials/Payables3 - Payables Effectiveness
  ●  Holds Aging
  ●  Holds by User and Age Bucket
  ●  Invoice Payment Cycle Days
  ●  Invoice Received Days
  ●  Invoices Processed by Source
  ●  Manual Invoices Trend
  ●  Top 10 Suppliers by Discount Lost
1- Cloud Financials/Payables4 - Supplier Payments
  ●  Item Receipt
  ●  Matching POs
  ●  Payment Details
  ●  Payment Due Aging
  ●  Payment Overdue Aging
  ●  Payment Status Flag Distribution
  ●  Top 10 Suppliers by Avg Payment Early Days
  ●  Top 10 Suppliers by Payment
  ●  Upcoming Payments
1- Cloud Financials/Payables5 - Employee Expenses
  ●  Credit Card Trxns %
  ●  Expense Filing Cycle Time
  ●  Expense Reimbursement Cycle Time
  ●  Expense Report Details
  ●  Expenses by Type
  ●  Top 10 Cost Centers by Expenses
  ●  Top 20 Expense Reasons
  ●  Top Violations by Type
  ●  Top Violators
1- Cloud Financials/PayablesInvoices - Drill to ERPAP Invoice Headers
1- Cloud Financials/Receivables1 - AR Aging Details
  ●  AR Aging by Bucket
  ●  AR Aging Details
  ●  AR Aging Trend
  ●  AR Overdue Aging
  ●  AR Overdue Invoice Count
  ●  Balance by Customer
  ●  Summary
1- Cloud Financials/Receivables2 - Invoice Details
  ●  Adjustment Details
  ●  AR Invoice Details
  ●  Receipt Details
  ●  Top Customer Invoice Amounts
  ●  Top Items
1- Cloud Financials/Receivables3 - Receivables Summary
  ●  What are the Country Wise Balances?
  ●  What are the Top 10 Receivables by Collectors?
  ●  Who are the Top 10 Customer by Receivables?
1- Cloud Financials/Receivables4 - Cash Receipt Register
  ●  Details
  ●  Top Customer Reciepts
1- Cloud Financials/Receivables5 - AR Customer Summary
  ●  AR Snapshot table
  ●  Outstanding Amounts
  ●  Payment Schedules
  ●  Receipts
1- Cloud Financials/Receivables6 - Adjustment Register
  ●  Adjustment Debit USD by OU
  ●  Adjustment Debit USD by Trx Type
1- Cloud Financials/Receivables/Drill ReportsInvoice DrillInvoice Details
2 - Cloud Supply Chain/InventoryInventory
  ●  Detail
  ●  Inventory On Hand Summary
  ●  Inventory QTY by Site
  ●  On Hand Inventory by BU
  ●  On Hand Quantity by Subinventory
  ●  Top Inventory Items
  ●  Total Inventory On Hand
  ●  Transaction Details
2 - Cloud Supply Chain/InventoryMaterial Transactions
  ●  Details
  ●  Items Txn Type Summary
  ●  Movement Summary
2 - Cloud Supply Chain/Inventory/On Hand Quantity SnapshotsOn Hand Quantity SnapshotsOn Hand Quantities Snapshot by Week
2 - Cloud Supply Chain/Order Management1. Booking Backlog and Billing
  ●  BBB Metrics
  ●  Billing Details
  ●  Cash Receipt Details
  ●  Country Summary of Backlog Amount
  ●  Fulfillment Details
  ●  Order Details
  ●  Return Details
  ●  Return Summary
  ●  Summary
  ●  Summary by Various attributes
  ●  Top 25 Customer Billing Summary
  ●  Top Category > Item Summary
  ●  Top Customers/Items By On-Time Shipped Amount
  ●  Top Customers/Items By Return Amount
  ●  Top Items By Return Amount
2 - Cloud Supply Chain/Order Management2. Order Summary
  ●  Fill Rate by Customer
  ●  Fulfillment Details
  ●  Monthly Performance
  ●  Order and Sales Revenue by Customer
  ●  Order and Sales Revenue by Item
  ●  Order Details
  ●  Order Trend By Year
  ●  Orders Completion Performance
  ●  Top 10 Customers by Orders
  ●  Top 10 Items
  ●  Top Warehouse Performance
2 - Cloud Supply Chain/Order Management3. Open Sales Orders
  ●  Fulfillment Details
  ●  Orders By Age Bucket
  ●  Orders by Customer
  ●  Orders by Items
  ●  Sales Orders Details
  ●  Top 10 Orders
2 - Cloud Supply Chain/Order Management3.1.Order To Cash Cycle
  ●  Delivery Details
  ●  Fill Rate by Customer
  ●  Invoice Summary
  ●  Order Details
  ●  Order Status
  ●  Orders Past Due
  ●  Qty By Status
  ●  Top Customer Orders
  ●  Top Customer Receivables (Drill to Aging)
  ●  Top Products
2 - Cloud Supply Chain/Order Management4. Daily Inventory
  ●  Inventory Details
  ●  Total Qty & Weight by Org
  ●  Total Qty by Item Category
2 - Cloud Supply Chain/Order Management6. Delivery Performance (With Drills)
  ●  Delivery Performance By Customer
  ●  Dollars
  ●  Pounds
  ●  Total
  ●  Units
2 - Cloud Supply Chain/Order Management7. Orders InquiryOrder Header Report
2 - Cloud Supply Chain/Order Management/Drill ReportsDelivery Performance By CustomerDelivery Performance By Customer
2 - Cloud Supply Chain/Order Management/Drill ReportsDelivery Performance By Order NumberDelivery Performance By Order Number
2 - Cloud Supply Chain/Order Management/Drill ReportsOpen Order DetailsOrder Details
2 - Cloud Supply Chain/Order Management/Drill ReportsOrders Inquiry - detailOrder Details Report
2 - Cloud Supply Chain/Order Management/Drill ReportsRevenue - Billing and Tax Details
  ●  Customer Performance
  ●  Invoice Details
  ●  Revenue Performance
  ●  Which Customers contribute to Top 80% of Revenue
  ●  Which Parts contribute to Top 80% of Revenue
2 - Cloud Supply Chain/Purchasing0. Procure2Pay overview
  ●  AP Invoice Details
  ●  Details
  ●  Invoice Payment Details
  ●  Invoice Payment Schedules
  ●  Metrics
  ●  Payment Due Aging
  ●  PO Metrics
  ●  PO Receipts
  ●  Purchase Order Details
  ●  Requisition Details
  ●  Supplier Performance
  ●  Supplier Summary
  ●  Top 10 Suppliers by Outstanding Payment
  ●  Top Requisition Items
2 - Cloud Supply Chain/Purchasing1. Buyer Control Panel
  ●  AP Holds
  ●  AP Holds Aging
  ●  AP Holds by Supplier
  ●  Late PO Buckets
  ●  Late POs
  ●  Late POs Supplier Summary
  ●  POs not approved @ Header
2 - Cloud Supply Chain/Purchasing2. Buyer and Supplier Performance
  ●  Buyers with Open/Late POs
  ●  Supplier Evaluation
  ●  Supplier Evaluation Matrics
  ●  Top Vendors by Avg PO Amount
2 - Cloud Supply Chain/Purchasing3. PO Receipts
  ●  Details
  ●  PO Receipt Details
  ●  PO Receipts
  ●  PO Summary
  ●  Supplier Lag Days
  ●  Supplier Performance
2 - Cloud Supply Chain/Purchasing4. Late POs
  ●  By Buyer > Match Type
  ●  By Item Category
  ●  By Supplier
  ●  Open POs Past Due Date
  ●  Purchase Order Details
2 - Cloud Supply Chain/Purchasing5. Spend
  ●  Spend Trend
  ●  Total Spend by Categories
  ●  Which Items make up Top 80% of the Spend?
  ●  Which Suppliers make up the Top Spend (Drill to details)?
2 - Cloud Supply Chain/Purchasing6. PO Management
  ●  Late POs
  ●  Purchase Order Details
  ●  Suppliers contributing to Top 80% for all POs
  ●  Suppliers with Late POs
  ●  Top 10 Buyers by Open POs
  ●  Top 10 Items with Open POs
  ●  Top 10 Suppliers by Open POs
2 - Cloud Supply Chain/Purchasing7.Procure2Pay Cycle
  ●  # of Reqs Without PO
  ●  AP Holds
  ●  AP Holds by Supplier
  ●  AP Invoice Details
  ●  Invoice Payment Details
  ●  PO Metrics
  ●  PO Req Details
  ●  Purchase Order Details
  ●  Requisition Metrics
  ●  Requisitions Without PO
  ●  Supplier Payments
  ●  Supplier Summary
  ●  Top Supplier Outstanding Payments
2 - Cloud Supply Chain/Purchasing8. PO Details
  ●  Purchase Order Details
  ●  Top POs by % PO Released
  ●  Top Suppliers by % PO Released
2 - Cloud Supply Chain/Purchasing/Buyer Dashboards2. Item Attributes
  ●  Item Org Details (Active)
  ●  Master Item Details (Active)
3- Cloud Projects1 - Project Executive Dashboard
  ●  Cost Perf by Org
  ●  Cost Perf by Resource Class
  ●  Project count by status
  ●  Project Summary
  ●  Revenue Perf by Category
  ●  Top 10 customers
  ●  Top 10 Incurred By Person Costs
  ●  Top Projects
3- Cloud Projects2 - Project Manager Dashboard
  ●  Cost Details
  ●  Cost Perf by Resource Class
  ●  Funding By Project
  ●  Projects Cost Vs Budget
  ●  Revenue Details
  ●  Top 10 Incurred By Person Costs
  ●  Top Committed Costs
  ●  Top Task Costs
3- Cloud Projects4 - Project Cost Details
  ●  Costs
  ●  Top Org costs
  ●  Top Projects costs
3- Cloud Projects5 - GL Journals and AP Projects
  ●  Invoice Details (Drill to PO)
  ●  Payment Details
3- Cloud ProjectsAward based Project cost and budgets
  ●  Award Budgets
  ●  Award Costs
3- Cloud ProjectsCommitted Cost Transactions
  ●  Project Status
  ●  Projects by Commitment
3- Cloud ProjectsOpen Projects for Billing
  ●  Contracts by Customer
  ●  Top 10 Projects
3- Cloud ProjectsTrial Balance Details - Projects
  ●  Balances
  ●  Details
3- Cloud ProjectsWIP Analysis
  ●  Project Status
  ●  Top 10 Project Managers by Margin
  ●  Top 10 Projects by Margin
3- Cloud ProjectsWIP Contracts
  ●  Contract Completion Amount
  ●  Projects by Cost