General Ledger Frequently Asked Questions
The Oracle Fusion ERP Analytics Frequently Asked Questions (FAQs) provide answers to the most commonly asked questions about your analytics experience.
General Ledger Topics:
- Does Profitability Analysis - YTD represent current year YTD or prior year YTD?
- Why are some accounts types not reflecting correctly in FDI DW_GL_CODE_COMBINATION after changing its account type in Fusion Applications?
- Why aren’t Accounting distributions with a net-zero amount in the Account Analysis subject area transferred to the general ledger for posting?
- Why do the data validation results for GL Account Analysis show inaccurate information?
- Why does the Configurable Account Analysis (CAA) subject area sometimes not show in the subject area list?
- Why is there a discrepancy in a few transactions between Configurable Account Analysis and GL Details transactions subject areas?
- 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 was my budget balance reset?
- Why do I not see Encumbrance Journals and Balances even though I enabled the Encumbrance Accounting feature?
- Why are Analytic Currency and Ledger Currency metrics not populated for Statistical currency data in the General Ledger subject areas and facts?
- Why do I see multiple currencies in the Ledger Currency when I do an analysis using the GL Balance Sheet and GL Profitability for a specific ledger?
Does Profitability Analysis - YTD represent current year YTD or prior year YTD?
Year to Date (YTD) metrics represent the current year's YTD. Before verifying YTD results, open the period in the application.
Why are some accounts types not reflecting correctly in FDI DW_GL_CODE_COMBINATION after changing its account type in Fusion Applications?
You may see this issue when the account types are inconsistent in Fusion Applications because the reclassified account type isn't reflecting in related GL code combinations. Confirm the process for correcting misclassified accounts in Fusion Applications. See Correct Misclassified Accounts.
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 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 does the Configurable Account Analysis (CAA) subject area sometimes not show in the subject area list?
When multiple full loads are running, you may check the system in between runs, in which case you may see an incomplete subject area list. The final full run and the incremental run that follows it verify all extensions. Wait until all runs are complete to check subject areas and extensions.
Why is there a discrepancy in a few transactions between Configurable Account Analysis and GL Details transactions subject areas?
Configurable Account Analysis (CAA) corresponds to XLA AE Lines data, and the GL Detail Transactions Subject Area corresponds to GL_JE_LINES data. A discrepancy might occur when the Account code combinations are different between the subledger accounting (XLA_AE_LINES) and GL Journals (GL_JE_LINES).
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 I not see Encumbrance Journals and Balances even though I enabled the Encumbrance Accounting feature?
Reset the General Ledger functional area if you enable the Encumbrance Accounting feature after activating the General Ledger functional area to ensure all Encumbrance Balances and journals from the Initial extract extract into the warehouse.
Also, you need to use the Balance Type or Encumbrance type filters in your analysis to view the encumbrance data. If your analysis requires Actuals and Encumbrance, add Actuals and Encumbrance to the Balance Type filter. Then you can add any additional filters in your analysis. If the Balance Type or Encumbrance type filter ist set, you will only see data related to Actuals.
Why are Analytic Currency and Ledger Currency metrics not populated for Statistical currency data in the General Ledger subject areas and facts?
The Statistical (STAT) currency is used to record statistical data and Fusion Data Intelligence has a separate Statistical Currency fact folder with metrics for analyzing statistical currency data. Analytic Currency and Ledger currency metrics only show data in the respective currencies and STAT currency rows shows null for these metrics.
In the GL Detail Transactions subject area, Document currency metrics show STAT currency data, but you need to make sure that you're using the Document currency as an attribute in the analysis or have a filter to restrict document currency to STAT to see the correct data.
Why do I see multiple currencies in the Ledger Currency when I do an analysis using the GL Balance Sheet and GL Profitability for a specific ledger?
The GL Balance Sheet and GL Profitability subject areas provide the ability to analyze reporting currency balances along with ledger currency balances if you've defined reporting currencies for your ledger in Fusion Applications.
The Ledger Currency attribute in the Currency folder in the GL Balance Sheet and GL Profitability subject areas shows reporting currency for the translated balance rows. Ledger Currency amounts for such translated row also show the amounts in reporting currency. For all other balance rows, ledger currency is the functional currency of the ledger.
If you want to analyze the balances in reporting currency, add a filter using the ledger currency attribute in the currency folder.
If you only want to see the functional currency of the ledger, you can either use the ledger currency filter and assign a currency value, or add an expression filter to check if the ledger currency in the ledger folder equals the ledger currency in the currency folder. This condition only brings in rows in the functional currency of the ledger and removes all reporting currencies.