Frequently Asked Questions

Topics:

Why can’t I use receivables unaccounted transactions?

All Receivables subject areas except AR Transactions and AR Revenue only support accounted transactions. AR Transactions and AR Revenue subject areas support unaccounted transactions when the AR Unaccounted Transactions functional area is activated.

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

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

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

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

Why do I not see all employee expense reports in Employee Expense subject area?

The Existing Employee Expense subject area only extracts Employee Expense records that are processed in Payables. Therefore, expense reports in other statuses aren't available for analysis.

Why am I missing month-end snapshots from AR Aging and AP Aging? or What frequency should I run the pipeline data extract for Accounts Receivable and Accounts Payable Functional areas?

You must schedule pipeline incremental runs for Account Receivable and Accounts Payables functional areas daily. AR Aging and AP Aging fact tables (included in Accounts Receivables and Account Payables functional areas respectively) are designed for daily incremental runs.

When the incremental run happens after the fiscal month end date, it creates a snapshot for the previous month with the month-end data. If the incremental snapshot runs on a weekly basis, and the month-end date falls on a day on which the schedule doesn't run, then the month won't have an accurate month-end snapshot. Creating a snapshot as the last day of an incremental run for the month won't include open transactions that belong to that snapshot. To work around this issue, reset the functional area to build a snapshot that includes the month-end date.

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.

In which document currency can I see the Discount Remaining amount?

Discount Remaining Amount metric in AP Payments subject area is calculated using "Discount Offered Amount" from AP Invoices fact and "Discount Taken Amount" and "Discount Lost Amount" from AP Payments fact. The formula is Discount Offered Amount - Discount Taken Amount - Discount Lost Amount. For a cross-currency payment (Invoice currency and Payment currency are different), the AP Payment subject area shows the Invoice currency and payment currency when Document currency is selected. Discount Remaining Amount is calculated only in Invoice currency and not Payment currency.

Why do I not see all the project invoices in PPM - Project Invoices subject area?

Release 22.R4 included the PPM - Project Invoices subject area, and only Project Invoices that are transferred and Accepted in Receivables are extracted in Oracle Fusion ERP Analytics. In release 23.R2, to view Invoices with other statuses before Accepted in Receivables, activate the new Project Invoices Prior to Acceptance functional area.

Why do I see unaccounted transactions in AR Transactions and AR Revenue subject areas?

The AR Unaccounted Transactions functional area is new in Release 22.R4. When you activate this functional area, the AR Transactions and AR Revenue subject areas show both accounted transactions and unaccounted transactions as long as the transactions are complete and the revenue schedules are generated. Data validations of Total Transaction Amount in AR Transactions and Distribution Amount in AR Revenue fetch both accounted and unaccounted data from the source. If the AR Unaccounted Transactions functional area isn't activated, then there is a mismatch between the source and warehouse since the warehouse only has the accounted transactions.

To work around this issue, set the Accounted Indicator attribute to Yes for the data validation.

Why am I not able to see quantity metrics at subinventory and locator level in the PO Receipts subject area?

All the quantity metrics are at the Receipt line level and not at the Transaction level (Subinventory, Locator) in the PO Receipts subject area.

Why don't I see future dated invoices in AP Aging?

The AP Aging subject area only includes open AP invoices with an invoice date until the current open period. Future dated invoices aren't included. If any invoice is created with a future date, it'll be picked up only when invoices are processed for that future date/period.

My AP invoice liability amount is split between multiple liability accounts generated based on the SLA accounting rules set up in Oracle Fusion Cloud Applications. Why do I not see all those liability accounts in the AP Aging subject area?

The AP Aging subject area is at the schedule level and can only show one liability account for each schedule. If an invoice has the amount split between multiple liability accounts, it'll only show the default liability account that's populated in the AP invoice header in Oracle Fusion Cloud Applications. If the SLA Accounting also generates only one liability account per invoice, then it'll show the liability account generated by the accounting process.

If your use case is to analyze the liability amount by GL Account and reconcile with General ledger, then use the AP Liabilities subject area.

What is the purpose of AR Unaccounted Transactions functional area?

The AR Unaccounted Transactions functional area brings in AR Transactions, Line, and Distributions data for all completed transactions including unaccounted transactions. The Accounts Receivables subject area only brings in data for accounted transactions.

AR Transactions and AR Revenue have unaccounted transactions and distributions if the AR Unaccounted Transactions functional area is activated and this data is also used to calculate the Transaction Amount and Line Amount in the AR Revenue subject area. Therefore, be sure to activate the AR Unaccounted Transactions functional area after the Accounts Receivables functional area is activated.

Since the AR Unaccounted Transactions functional area has unaccounted transactions, if customers marks a completed transaction as incomplete in Oracle Fusion Cloud Applications and deletes it, this will leave orphan records in Oracle Fusion ERP Analytics which is handled as part of the daily incremental pipeline run. Be sure to reset the functional area in such cases.

Why do some of the Aging metrics sow the same value in all Aging buckets?

In AR and AP aging, only the below metrics calculate outstanding amounts based on the Aging buckets:

Aging Amount - Invoice Date Basis
Aging Count - Invoice Date Basis
Aging Amount - Schedule Date Basis
Aging Count - Schedule Date Basis

All other Aging metrics aren't designed to work based on the Aging buckets. Other Aging metrics should be used for analysis with the other dimensions and attributes in the Aging subject area.

Why do I see only total values when using GL Account and GL Segment-related attributes in the PPM - Project Costs and PPM - Project Revenue subject areas?

GL Account and GL Segment-related attributes and hierarchies are only for analyzing accounting-related metrics, therefore these attributes can be used only with metrics in the Project Accounting Costs folder in the PPM-Project Costs subject area and metrics in the Accounted Revenue folder in the PPM-Projects Revenue subject area. No other metrics can be analyzed using the GL Account and GL segment related attributes.

Why isn't there data validation for Projects Funding subject area metrics?

The Fusion OTBI subject area Project Billing - Funding Real Time has only the latest contract details which may include contract versions in Under Amendment status. In the Oracle Fusion ERP Analytics PPM - Projects Funding subject area, Under Amendment versions of contracts aren't shown unless the Contract doesn't have versioning enabled. Since the Contract versions in both subject areas are different, it isn't currently possible to have data validation for this subject area.

How should I use the Prepayment metrics in the AP Expenses subject area?

Prepayment amount, Applied Prepayment amount, and Available Prepayment amount metrics are available in the AP Expenses subject area. These metrics are designed to work with Prepayment attributes such as Prepayment Number and Prepayment Line Number.

Prepayment Number and Prepayment Line Number attributes are populated for the Prepayment Invoice type as well as for the Applied Prepayment lines in the Standard Invoice.

Prepayment Amount is calculated using the Prepayment Invoice type. Applied Prepayment amount is calculated using the Applied prepayment lines in the Standard Invoice, and the net amount shows the Available Prepayment Amount for a Prepayment Number and Prepayment Line Number.

When does Invoice not show in AP subject areas?

If there are invoices dated prior to the Initial Extract Date (IED), ACCTS_PAY_CODE_COMBINATION_ID is found to be null in AP_Invoices_all, and the Invoiced_on_date is a future period, then the invoice isn't available at the Payment schedules grain.

Why do I not see Ledger Currency and Project currency metrics for Project Invoices?

Ledger Currency and Project Currency metrics are only populated in for Project Invoices that are transferred and Accepted in Receivables. Any invoice that isn't in Accepted in Receivables status won't have these metrics populated.

Why do I not see the Project attributes or the Associated Task attributes for the Project Contract invoices in AR Revenue subject area?

The Fusion Accounts Receivables module stores the Project and Associated Task attributes at the Receivables line level for Project Invoices only if the Invoice Grouping rule on the Contract is set up to group the lines by these attributes. If Project and Associated Task attributes aren't used in the Invoice grouping, these attributes won't be passed to Receivables and won't be available the in AR Revenue subject area either.

Why is the Credit Memo Applications Amount not populated for certain ledgers?

The Credit Memo Applications Amount in the Facts-Ledger Currency folder of the AR Credit Memo Applications subject area is populated only for Primary Ledgers. It's not supported for non-primary ledgers. Application distribution Amount is populated for Primary and non-primary ledgers.

How can I assign data security in Fusion Data Intelligence?

You can assign data security using these methods:

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.

Why am I missing transactions and receipts related to Multifund Accounting in Receivables subject areas?

In the Fusion Data Intelligence Accounts Receivables subject areas, Multifund Accounting, Detailed Reeivables Distributions, and MFAR aren't currently supported.

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.

Why is the Accounting Date in AP Invoices subject area not matching with the actual accounting date?

In the AP Invoices subject area, the Accounting date is from the AP_Invoices_All table, where the Accounting Date is an estimated date and is pre-subledger accounting (SLA). To find the actual Accounting date, refer to the distribution accounting date in the AP Expenses and AP Liabilities subject areas since they are captured only for accounted data.

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 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 do I see duplicate records for an item number when creating an analysis based on prebuilt Subject Area Inventory Balances / Inventory Item / Item column?

This is expected behavior if data is deleted from Fusion Applications. This shouldn't create any issues on your report if you report on the data based on the correct keys. When analyzing on the dimension only, remove or clean stale data, then perform a hard reset and reload the data.

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.

Since Receipt Accounting Date doesn't support Receipt Amount, which measure should I use to get receipt amount by accounting period? Also which measures are recommended for balancing segment?

For Receipt Accounting Date and Balancing Segment Code, all metrics are supported except Receipts Amount and Average Receipts Amount. While Receipts Amount by Accounting Period isn'te supported, you can query receipts amount by the following two period columns:

Financials - AR Receipts and Applications.Time.Fiscal Period"
Financials - AR Receipts and Applications.Receipt Details.Receipt Date.Receipt Fiscal Period

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).

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.

While validating the Fusion Data Intelligence Payroll Costing subject area, when there are table value sets based on SQL query, not all costing information displays. What could be the reason for this difference?

Only Dependent/Independent Values based Segments are supported. If the corresponding value sets are table value sets, such as ones based on a SQL query used in value set definition, unmap these segments from labels.

Why are Consumed Amount, Remaining Amount, Burn Rate, Elapsed Days, and remaining Days not displayed for all periods?

The Consumed Amount, Remaining Amount, Burn Rate, Elapsed Days and Remaining Days metrics in the PPM- Grants Award Funding subject area are displayed only for the current budget period. There is no historical computation or there's no possibility of seeing the burn rate for a specific date. These measures are generally analyzed with current budget period point of view, and the calculation changes based on whether it's an expanded authority or restricted authority award.

Why aren't Contract Details displayed for certain awards in the PPM - Grans Award Funding subject area?

Only contracts that are approved are displayed in the PPM- Grants Award Funding subject area if version is enabled. If Version isn't enabled, under amendment contracts are displayed.

Why am I seeing different values for Distribution Line Number in Labor Distribution Cost Details and Distribution Rule Line in the presentation folder Labor Schedules Details?

In the Labor Distribution Costs subject area, Distribution Rule Line in the Labor Schedules Details presentation folder shows a different value compared to the Distribution Line Number in the Labor Distribution Cost Details presentation folder for differentials.

This happens when a differential line is processed in labor distribution costs, and then displayed and stored as -1 for the Distribution Line Number. The Labor schedule doesn't have a differential line, therefore the Distribution Rule Line in Labor Schedule displays as 0.

Why are certain labor schedule versions not showing in the PPM - Project Labor Schedules subject area even though they're in Fusion Applications?

The Labor schedule versions which are in New status in the PPM - Project Labor Schedules subject area aren't displayed if there are no distribution lines defined for the schedule version.

Why aren't all labor schedules fetched for the PPM - Project Labor Distributions subject area?

The PPM - Project Labor Distributions subject area only displays schedules and versions which are used to distribute the labor cost. To query all labor schedules with no labor cost associated, include the Labor Schedule attributes and measure from the PPM Labor Schedule subject area along with Labor Cost Distribution measures.

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.

While using the Procurement - Receipt Accounting subject area, why isn't there a receipt number for invoice price adjustment transactions?

This is expected behavior There isn't a receipt number for invoice price adjustment transactions.

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.