Common Frequently Asked Questions
The Oracle Fusion ERP Analytics Frequently Asked Questions (FAQs) provide answers to the most commonly asked questions about your analytics experience.
Common Topics:
- After a recent change in the exchange rates in Oracle Fusion Cloud Applications, why am I unable to view the order amount in analytics currency for some purchase orders even though the received dates for those purchase orders are after the exchange rates date change?
- Can I view assignment-related details of a person inactive in Fusion Applications in the snapshot table DW_WRKFRC_ASG_SNAPSHOT_F?
- Does time series functions such as TODATE and AGO work across different calendars in Fusion Data Intelligence?
- How can I assign data security in Fusion Data Intelligence?
- How do I synchronize data security from Oracle Fusion Cloud Applications with Fusion Data Intelligence?
- How is Analytic Currency metrics calculated in Oracle Fusion ERP Analytics subject areas?
- Where can I see records related to account class Intracompany, Balance?
- Why can’t I see backdated transactions in the AP and AR Aging subject areas in historical aging snapshots?
- Why can’t I use a secondary ledger in all subject areas?
- Why do I see the messge "Error getting fiscal time details" on decks related to Finance and Procurement after a recent application update?
- Why isn't the unit of measure (UOM) conversion correct or current?
- Why isn't the unit of measure (UOM) conversion showing any data?
- Why am I not able to see the Tree Code and Version attribute in the flexfield segment hierarchy folders under the Segments folder in the subject areas?
After a recent change in the exchange rates in Oracle Fusion Cloud Applications, why am I unable to view the order amount in analytics currency for some purchase orders even though the received dates for those purchase orders are after the exchange rates date change?
Currency conversion is based on document date (creation date). If the exchange rates are available post the document creation date for those purchase orders, then the amounts aren’t available in analytical currency. This is expected behaviour.
Can I view assignment-related details of a person inactive in Fusion Applications in the snapshot table DW_WRKFRC_ASG_SNAPSHOT_F?
The snapshot table DW_WRKFRC_ASG_SNAPSHOT_F doesn't return data on inactive person numbers. It only returns data on all active persons as of the last extract, transform, and load (ETL) run.
Does time series functions such as TODATE and AGO work across different calendars in Fusion Data Intelligence?
Time Series and AGO don't work across calendars. Select a calendar as the first level filter. Using the calendar, restrict the year and period, and then re-run the Time Series and AGO metrics.
How can I assign data security in Fusion Data Intelligence?
- Assign security context to users manually. See Create a Security Assignment.
- Assign security context to users by downloading and uploading the data security assignments. See Upload and Download Data Security Assignments.
- Propagate data security from Oracle Fusion Cloud Applications (Cloud ERP). See How do I synchronize data security from Oracle Fusion Cloud Applications with Fusion Data Intelligence?.
How do I synchronize data security from Oracle Fusion Cloud Applications with Fusion Data Intelligence?
To synchronize data security, you must create a pipeline for the "Security Configuration Option" functional area in the "ERP Security Configurations" offering. This pipeline enables Fusion Data Intelligence to extract the user security assignment details from Oracle Fusion Cloud Applications (Cloud ERP) and load it into Fusion Data Intelligence. Based on the user configuration in Oracle Fusion Cloud Applications (Cloud ERP), the synchronization process assigns the ledger, business unit, project organization, and procurement business unit (PO Agent) values to the users in Fusion Data Intelligence.
To ensure that synchronization happens frequently, you must schedule the incremental refreshes. See Set Up the Pipeline Parameters.
- Sign in to your service.
- In Fusion Data Intelligence, click the Navigator.
- In the Navigator menu, click Console.
- On the Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Enterprise Resource Planning.
- On the service page, click Create, select
ERP Security Configurations in
Offering, select Security
Configuration Option in Functional
Area, and then click Next.
- Review the parameters and click one of the options:
- Cancel: To cancel the data pipeline for the functional area.
- Save: To save the data pipeline for the functional area but not activate it.
- Activate: To schedule when to run the data pipeline for the functional area. See Activate a Data Pipeline for a Functional Area.
How is Analytic Currency metrics calculated in Oracle Fusion ERP Analytics subject areas?
For Oracle Fusion ERP Analytics subject areas, analytic currency metrics are calculated by converting the ledger currency metric amounts to analytic currency using the exchange rate defined in Oracle Fusion ERP Analytics. The exchange rate is derived from the exchange rate type defined in the pipeline configuration parameters. The exchange rate date basis for each subject area is listed in Subject Area Metric Details.
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 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 Data Intelligence 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 Data Intelligence. These are included only in the current aging snapshot.
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 do I see the messge "Error getting fiscal time details" on decks related to Finance and Procurement after a recent application update?
This error shows if a calendar which was used in the source has been deleted. Review the calendars shown in Fusion Applications. In Setup and Maintenance select Financials, then select Financial Reporting Structures, and then select Manage Accounting Calendars. If there is a mismatch in Calendars, perform a reset of the General Ledger Functional Area.
Why isn't the unit of measure (UOM) conversion correct or current?
- 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 Data Intelligence.
In both scenarios, unless you apply the updates to transactions in Fusion Data Intelligence, Fusion Cloud SCM won't consider the latest UOM conversion.
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 am I not able to see the Tree Code and Version attribute in the flexfield segment hierarchy folders under the Segments folder in the subject areas?
The Tree Code and Version" attribute in flexfield segment hierarchies is hidden in subject areas starting in release 24.R2. Replace the Tree Code and Version attribute in your custom analysis or metrics with the Tree Code Filter attribute.