A Frequently Asked Questions
Refer to these Frequently Asked Questions if you have questions about the behavior of Fusion Analytics Warehouse.
Topics:
-
Why is the Payments Discount Lost metric in Accounts Payables only populated for the primary ledger?
-
Why can I only see some unaccounted transactions in Payables?
-
Why do different subject areas in Accounts Payables show different levels of detail?
- 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.
- Why I can't see depreciation transactions in the Assets subject area?
- Why was my budget balance reset?
- Why do Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics show a zero value?
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?
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 I can't see depreciation transactions in the Assets subject area?
Depreciation transactions such as Periodic Depreciation, Bonus Depreciation, and Accelerated Depreciation aren't currently included in the Assets Transactions subject 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.