1. Reference for Fusion ERP Analytics
  2. Frequently Asked Questions

A Frequently Asked Questions

Refer to these Frequently Asked Questions if you have questions about the behavior of Fusion Analytics Warehouse.

Topics:

Why can’t I use receivables unaccounted transactions?

All Receivables subject areas support only accounted transactions.

Why can’t I use a secondary ledger in all subject areas?

If a secondary ledger is set up with a Subledger Conversion level, then you can analyze data for a secondary ledger in the AR Revenue, AR Receipts and Applications, AR Credit Memo Applications, and AR Adjustments subject areas that are at the Accounting distribution grain. The AR Transactions and AR Aging subject areas are at the schedule level and 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 Applications Cloud?

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 Applications Cloud.

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 Applications Cloud 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.

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 Applications Cloud?

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 can’t I see backdated transactions in the AP and AR Aging subject areas in historical aging snapshots?

When an incremental run is executed on the last day of the fiscal period, Fusion Analytics Warehouse creates the monthly aging snapshot for that period. Any transaction created in Oracle Fusion Cloud Applications in the prior period isn't included in the prior period snapshot in Fusion Analytics Warehouse. These are included only in the current aging snapshot.

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 aren’t Accounting distributions with a net-zero amount in the Account Analysis subject area transferred to the general ledger for posting?

Accounting distributions with net-zero amounts in the Account Analysis subject area aren't transferred to the general ledger for posting. To work around this issue, use an expression filter to eliminate accounting distribution lines that are accounted but aren't transferred to the general ledger. 
case 
when "Financials - GL Account Analysis"."Journal Details"."Journal Source" is null and "Financials - GL Account Analysis"."Subledger Accounting Details"."Transfer to GL Status Code" in ('NT', 'Y') then 0 
else 1 end=1

Why isn't the Budgets subject area available? I don't see budget data in the GL Profitability or GL Balance Sheet subject area variance analyses.

To make the Budgets subject area available, you need to activate the Budget functional area as well as the GL functional area.

Why was my budget balance reset?

The budget balance for Balance Sheet Accounts is reset at the beginning of each fiscal year. Unlike Actual balances, Budget balances aren't carried forward to the next fiscal year.

Why do Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics show a zero value?

The Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics in the PPM - Projects Costs subject area require the GL Account Combination attribute. If the GL Account Combination attribute isn't included, the Debit and Credit entries negate each other and the metric value shows as zero.

Why can't I validate data in AR Adjustments and AR Credit Memo Applications for Primary Ledgers?

When you perform data validation on the Adjustments Amount metric in AR Adjustments and the Credit Memo Application Amount metric in AR Credit Memo Applications for non-primary ledgers, the source value is null even though there's a value. These data validations only support primary ledgers.

What are the transaction details expected for a depreciation-related record?

In the Asset Transactions subject area, the Active Asset Indicator for depreciation distributions is null while the Active Assignment Indicator and Active Financial Indicator are both populated. The Asset Adjustment Type, Asset Source Type Code, Transaction Type, and Amortize are for depreciation records. The Transaction Number is -99999. Depreciation related data is populated with the default Transaction Date as the corresponding period start date. To compare Fusion depreciation distributions, the use the Fiscal Calendar that's anchored on the XLA, or Subledger Accounting, accounting date.

Where can I see records related to account class Intracompany, Balance?

These records aren't part of the subledger subject areas. These entries are created in the Subledger Accounting Engine and not the Subledger Applications such as Accounts Payables, Accounts Receivables, Assets, etc.

Why do the data validation results for GL Account Analysis show inaccurate information?

By default, the GL Account Analysis subject area has only 4 months of data (Current period + 3 prior months). So when selecting the fiscal date range filter for Data Validation of metrics, be sure you select a fiscal date within that period. Also, exclude the NO VALUE event class since journal only distributions aren't currently supported in data validation. If these filters aren't properly configured, the data validation results may be incorrect.

Why isn't the unit of measure (UOM) conversion showing any data?

Run the Oracle Enterprise Scheduler (ESS) job, Generate Item UOM Conversions for Primary Units. This job creates and maintains the set of UOM conversions for the primary unit of measure for every item in Fusion Cloud SCM. This is a prerequisite to see the UOM conversions for the primary unit of measure for every item.

Why isn't the unit of measure (UOM) conversion correct or current?

There are two possible scenarios for an incorrect UOM conversion:
  • Scenario 1: Only Standard UOM conversions initially exist, and the Inter or intra class UOM conversion is defined later in Fusion Cloud SCM.
  • Scenario 2: The UOM conversion is end dated in Fusion Cloud SCM before or after a load happens in Fusion Analytics Warehouse.

In both scenarios, unless you apply the updates to transactions in Fusion Analytics Warehouse, Fusion Cloud SCM won't consider the latest UOM conversion.

Why are Fiscal Calendar and Receiver Fiscal Calendar anchored to the same date and calendar in Project Budgets and Forecasts subject areas?

The Project Budgets and Project Forecasts subject areas have Fiscal Calendar and Receiver Fiscal Calendar attributes in the Time dimension. Both set of attributes are anchored to the same Plan Line Detail Start Date and Project Calendar. Receiver Fiscal Calendar is defined separately because it's a common dimension that can be used across PPM subject areas, and can be used for analysis to compare Project Costs (Actuals) data with Budgets or Forecasts. xTD metrics are also calculated using the Receiver Fiscal Calendar.

How are item details fetched in the Project Costs and Commitments subject areas?

An Item can be assigned to multiple inventory organizations. In order to fetch the item details in Project Costs and Project Commitments subject areas,the Inventory Organization is matched with the Expenditure Organization. If the Expenditure Organization isn't an Inventory Organization, then item details won't be populated even though the Fusion source has the data.