Known Issues for Oracle Fusion Data Intelligence
Learn about the issues you may encounter when using Oracle Fusion Data Intelligence and how to work around them.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customer access to and use of Oracle support services will be pursuant to the terms and conditions specified in their Oracle order for the applicable services.
Oracle Fusion Data Intelligence General Issues and Workarounds
Learn about the general issues you may encounter when using Oracle Fusion Data Intelligence and how to work around them.
Topics:
- Prebuilt Reports Fail When Using an External Semantic Model of an External Application
- Verify Legacy Workbooks After Migration
- Issue with Failed Status for Renamed Custom Dimensions
- Key Metrics can't be Translated
- Missing Deck-style Filters in Migrated Content
- Unexpected Filter Context for Data Action Links in Migrated Content
- Error When Custom Path Included in Migrate Custom Content Utility Folder Name
- Error Occurs When Promoting the Semantic Model to Production
- Issues with Content Explorer - Fusion Data Intelligence Dashboard
Prebuilt Reports Fail When Using an External Semantic Model of an External Application
If the 24.R1.P1 patch has been applied to your instance and you use a semantic model of an external application (.rpd) file, then you must re-upload the semantic model of the external application after the upgrade has completed.
If you don't re-upload the semantic model of the external application, then you might find that some prebuilt reports don't function properly. See About Merging External Applications.
Verify Legacy Workbooks After Migration
For each pillar folder in the Oracle
Analytics Cloud catalog (Shared Folders/Oracle/PillarName
), only the /Detail
Dashboards
and /Overview Dashboards
folders and their contents
will remain after release 24.R1. These directories contain the latest application
content.
The numerous other folders directly under the pillarname folder contain legacy prebuilt drill-down workbooks from decks. These will no longer be useful and will be removed in release 24.R2. If you're using those legacy, read-only workbooks in your production application, Oracle recommends duplicating and moving them into your custom content. Then you can reestablish the drill-down navigation from your migrated content to these new versions.
Issue with Failed Status for Renamed Custom Dimensions
When you edit an Add Dimension step, the current and subsequent steps enter into a failed status.
To work around this issue, delete the step and create it again.
Key Metrics can't be Translated
In this release, text added as metadata to the key metrics feature can't be exported, translated, and brought back into the application as translated content.
Where shown (for example as a key metric description), that key metric metadata will be seen in the original language in which it was entered.
Missing Deck-style Filters in Migrated Content
In this release, a copy of decks has been migrated to core Oracle Analytics Cloud workbooks.
The deck-style filters for time and calendars can't be directly replicated in the workbooks. Migrated workbooks, rather than swapping between business time intervals (such as Current, Previous, or Last-N), use standard Oracle Analytics Cloud time filters. These time filters present multiple distinct periods based on columns in the subject area (such as Fiscal Year, Fiscal Quarter, and Fiscal Period). The migrated content, found in the Overview Dashboards folder, has been updated to use standard Oracle Analytics Cloud filters for time.
Unexpected Filter Context for Data Action Links in Migrated Content
For this release, in the migrated content, the navigation from converted decks (now called overview dashboards) has issues passing the filter context from the overview dashboards down to the detail workbooks.
The shared detail workbooks are optimized for navigation from decks to the drill-down content. Decks are the primary organization method, while overview dashboards supplement the decks only. There are fewer issues when no or limited context is passed from the filters on the overview dashboard to the detail workbooks.
To work around this issue, update the converted decks in the overview dashboards folder with your desired optimized navigation.
Error When Custom Path Included in Migrate Custom Content Utility Folder Name
In the Migrate Custom Content utility, if you include anything other than the name of the folder you want to create under Run Migration, an error occurs.
The migration process appends the folder you create to the
/Shared Folders/custom
content path. You don't need to include
any text in the field other than the name of the folder. To avoid an error, include
only the name of the folder in the field.
To work around the error, re-run the utility to clear the error. Then re-run the utility one more time using only the name of the folder in the field to populate your output in the specified folder.
Error Occurs When Promoting the Semantic Model to Production
As you promote the semantic model from a test to a production environment, you might encounter an unexpected I/O error.
To work around this error until a fix is available, use bundles to migrate your changes to the semantic model to the production environment.
Issues with Content Explorer - Fusion Data Intelligence Dashboard
You may encounter these issues with the Content Explorer - Fusion Data Intelligence Dashboard workbook.
- Custom subject areas and metrics created through Data Augmentation, Fusion Accounting Hub Analytics, and Configurable Account Analysis use system-generated names.
- There is no historical custom content present prior to the Platform 24.R4 release.
- Content Explorer - Fusion Data Intelligence is supported for US English only.
Known Issues for Oracle Fusion ERP Analytics
Oracle Fusion ERP Analytics has a number of known issues.
Topics:
- Known Issues for Oracle Fusion ERP Analytics Common
- Known Issues for Oracle Fusion ERP Analytics General Ledger
- Known Issues for Oracle Fusion ERP Analytics Payables
- Known Issues for Oracle Fusion ERP Analytics Project Billing
- Known Issues for Oracle Fusion ERP Analytics Project Control
- Known Issues for Oracle Fusion ERP Analytics Project Costing
- Known Issues for Oracle Fusion ERP Analytics Receivables
Known Issues for Oracle Fusion ERP Analytics Common
These Known Issues address the Common functions.
Topics:
- Aggregation of YTD Metrics Is Incorrect in Certain Scenarios
- Old Records Created after IED with Time-Based Dimensions Missing from ERP Subject Areas
- Updated Name for DW_ORG_HIREARCHY_DENORM_DH Table
- Warehouse Full Reload Schedule Tab Timezone Not Showing Same as Incremental Refresh Schedule
- AR and AP Aging Don't Maintain History of GL Accounts
Aggregation of YTD Metrics Is Incorrect in Certain Scenarios
If you're aggregating YTD metrics across ledgers for a quarter and in one ledger, the last period of the quarter isn't open, then the aggregation won't include the metrics from that ledger.
In this example, Period 1, Period 2, and Period 3 exist in Quarter 1. Ledger A and Ledger B have balances for all three periods. Period 3 in Ledger C isn't open and shows no balance.
In this example, YTD Revenue for Quarter 1 across three ledgers shows as 16500 instead of 22500. If you aggregate by Ledger or Period, you obtain the correct balance.
Quarter | Period | Revenue YTD | Ledger Name |
---|---|---|---|
Quarter1 | Period1 | 3000 | Ledger A |
Quarter1 | Period2 | 7000 | Ledger A |
Quarter1 | Period3 | 10000 | Ledger A |
Quarter1 | Period1 | 2500 | Ledger B |
Quarter1 | Period2 | 5000 | Ledger B |
Quarter1 | Period3 | 6500 | Ledger B |
Quarter1 | Period1 | 4000 | Ledger C |
Quarter1 | Period2 | 6000 | Ledger C |
Old Records Created after IED with Time-Based Dimensions Missing from ERP Subject Areas
The Oracle Fusion ERP Analytics subject areas use Accounting calendar in the Time dimension.
If there are records that use dates that aren't part of the accounting calendar, these records will be dropped when you use the Time dimension. For example, if you defined your accounting calendar starting 2020 but have old transactions before that year (records with dates in 2019 and before) that were entered in Fusion Applications Suite as part of data conversion, these records will be dropped when you use the time-based dimensions. There is no work around for this issue.
Updated Name for DW_ORG_HIREARCHY_DENORM_DH Table
The DW_ORG_HIREARCHY_DENORM_DH Table in Oracle Fusion ERP Analytics is now named DW_ORG_HIERARCHY_DENORM_DH.
Warehouse Full Reload Schedule Tab Timezone Not Showing Same as Incremental Refresh Schedule
The Warehouse Full Reload Schedule tab timezone doesn't show the same timezone as the incremental refresh schedule.
The scheduled full reload works as expected when the incremental load for the day is triggered. There is no workaround for this issue.
AR and AP Aging Don't Maintain History of GL Accounts
AP and AR Aging don't support historical GL Accounts used in Transactions.
If GL Accounts are overridden after being accounted, when you perform a full load of AP and AR Aging facts, the latest GL Account of the transaction is used for all snapshots.
There is no workaround for this issue.
Known Issues for Oracle Fusion ERP Analytics General Ledger
These Known Issues address the General Ledger functions.
Topics:
- Aggregation of YTD Metrics Is Incorrect in Certain Scenarios
- Data Validation of GL Balance Sheet Metrics May Show a Difference In Amounts More Than 15 Digits
- GL Segment Value of GL Account Shows ~No Value~ If That Segment Value Is Based on a Table-Validated Value Set
- Custom Security Defined at the GL Segment Hierarchy Levels Shows Incorrect Data
Aggregation of Certain YTD Metrics Is Incorrect in the GL Profitability Subject Area When the Adjustment Period Flag Is Included in the Analysis
If you're analyzing YTD metrics at a quarter or year level, and if you include the adjustment period flag as a filter or attribute, the YTD amounts gets aggregated incorrectly for the Depreciation Expenses YTD, Income Tax Expense YTD, Interest Expense YTD, Other Income YTD, Other Operating Expense YTD, R&D Expense YTD, Sales & Marketing Expense YTD, and Total Operating Expenses YTD metrics in the GL Profitability subject area.
For example, Period 1, Period 2, Period 3, and Adj Period exist in Quarter 1, and the amounts for R&D Expense YTD are as shown below. When you remove the Period attribute and view the Quarter level balance for Quarter 1, you expect to see 10,000. However, it will aggregate the amounts and show 20,000 for Quarter 1 with the Adjustment Period flag set to N, and 10,000 for Quarter 1 with the Adjustment Period flag set to Y.
Quarter | Period | R&D Expense YTD | Adjustment Period Flag |
---|---|---|---|
Quarter1 | Period1 | 3000 | N |
Quarter1 | Period2 | 7000 | N |
Quarter1 | Period3 | 10000 | N |
Quarter1 | Adj Period | 10000 | Y |
To work around this issue, don't use the Adjustment Filter flag when you're analyzing Quarter- or Year-level balances for YTD metrics.
Data Validation of GL Balance Sheet Metrics May Show a Difference In Amounts More Than 15 Digits
Data Validation of GL Balance Sheet metrics may show a difference if the amounts are more than 15 digits long.
Oracle Transactional Business Intelligence rounds amounts that are more than 15 digits long, whereas Fusion Data Intelligence supports amounts more than 15 digits long. Therefore, if the GL Balance Sheet amounts are more than 15 digits long, you may see a difference when performing data validation on these metrics:
- Financials GL Balance Sheet Debit Activity Amount in Ledger Currency by Ledger and Fiscal Period
- Financials GL Balance Sheet Credit Activity Amount in Ledger Currency by Ledger and Fiscal Period
- Financials GL Balance Sheet Debit Activity Amount in Ledger Currency by Ledger and Fiscal Period
GL Segment Value of GL Account Shows ~No Value~ If That Segment Value Is Based on a Table-Validated Value Set
If the segment value of Chart of Account is based on a table validated value set, then the Value, Name, and description attributes of that GL Segment show ~No Value~ instead of the actual values.
To work around this issue, examine the segment value using the GL Account Combination attribute.
Custom Security Defined at the GL Segment Hierarchy Levels Shows Incorrect Data
Custom security defined at the GL Segment hierarchy levels does not show expected results across all subject areas where GL Segment hierarchy is used.
For example, in the cost center hierarchy, if a custom context is set for level 29 to a specific value, all values for level 29 are fetched in the report instead of fetching only the secured value.
There is no workaround for this issue.
Known Issues for Oracle Fusion ERP Analytics Payables
These Known Issues address the Payables functions.
Topics:
- Data Validation of Total Outstanding Amount Metric Causes SOAP SERVER ERROR with the Invoice Accounting Status Filter Attribute
- Data Validation of Total Transaction Amount in AP Invoices Doesn't Match OTBI with Retainage
- Intracompany Records Generated for AP Invoice Payments Has Invoice-Related Attributes Populated Randomly
- Missing Payables Source Names
- Remaining Balance Calculation in AP Aging Subject are with Withholding Tax Incorrect
- Witholding Tax Calculation is Missing when Calculation Point is Payment
- Transaction Amount and Activity Amount is Incorrect in AP Aging for Cancelled Invoices
- Transaction Amount and Activity Amount is Incorrect in Backdated Invoices Created in Payables
- Invoice Holds Deleted for Tax Lines in Payables
- Future Activity Amount in AP Aging Shows Incorrect Balances
- Incremental Changes in Payables Due to Accounting Status Changes Not Updated
Data Validation of Total Outstanding Amount Metric Causes SOAP SERVER ERROR with the Invoice Accounting Status Filter Attribute
This issue is due to an OTBI bug.
To work around this issue, don't select the Invoice Accounting Status filter in the Data Validation of Total Outstanding Amount metric of the AP Aging Subject area. You can use filter as a pivot attribute.
Data Validation of Total Transaction Amount in AP Invoices Doesn't Match OTBI with Retainage
If AP invoices have Retainage, the installment amount won't include the retainage amount although the Invoice amount will include Retainage.
The AP Invoices subject area in Fusion Data Intelligence is at the Installment level and the Total Transaction Amount metric is derived from the Installment amount. Data Validation of Total Transaction Amount in the Ledger Currency compares the Transaction amount calculated from the Installments which doesn't include Retainage. The subject area instead compares with the Invoice Amount in Oracle Transactional Business Intelligence which includes retainage, therefore the amounts don't match.
If you have a Retainage process, you need to use the data validation metric Total Transaction Amount in Document currency. This compares with the Gross amount metric in the Oracle Transactional Business Intelligence Payables Invoices - Installments Real Time subject area and both metrics are at the Installment level.
Intracompany Records Generated for AP Invoice Payments Has Invoice-Related Attributes Populated Randomly
When an AP payment is made against multiple invoices for which SLA generates the Intracompany or Balance records to balance the accounting entries, Fusion Data Intelligence associates these accounting entries with attributes related to invoice numbers randomly.
In these cases, Intracompany and Balance records aren't generated specific to the invoice in Fusion Applications. Fusion Data Intelligence populates these entries with invoice-related attributes which is incorrect. This issue exists in the GL Account Analysis subject area, and doesn't have a workaround.
Missing Payables Source Names
Oracle Fusion Data Intelligence currently doesn't display the payables source name, but instead displays the translated lookup meaning
For some of the payables source codes, Fusion Data Intelligence isn't storing the lookup in the translation table, and because of this Oracle Fusion Data Intelligence can't support showing these values. There is no workaround at this time.
Remaining Balance Calculation in AP Aging Subject are with Withholding Tax Incorrect
In the AP Aging subject area, the Remaining balance calculation is incorrect when there's a Withholding tax applied at the Invoice Distribution level.
Witholding Tax Calculation is Missing when Calculation Point is Payment
The Expense fact shows all of the invoice lines except where the Invoice includes a Withholding tax line.
Transaction Amount and Activity Amount is Incorrect in AP Aging for Cancelled Invoices
In AP Aging, once the invoice is cancelled, the transaction_amount and remaining_amount are updated to 0 for a invoice schedule.
There is no workaround to reverse the record for an invoice schedule cancellation. Once the invoice is cancelled, there's no method to determine the schedule level transaction amount.
Transaction Amount and Activity Amount is Incorrect in Backdated Invoices Created in Payables
Backdated invoices created in Oracle Payables don't show the correct transaction amount and activity amounts.
In the AP Aging (Preview) feature, when backdated transactions are created or updated and the transaction schedule status is closed, the remaining amount and schedule status aren't updated correctly in the incremental run. As a workaround, to see the backdated transactions correctly, reset the AP Aging functional area manually, or schedule a full load of this functional area daily, weekly, or monthly depending on your reporting needs.
Invoice Holds Deleted for Tax Lines in Payables
You can delete holds for tax lines if the tax determinant is removed from the invoice or there's a setup change for the tax determinant.
If tax determinants are added back, then the tax line gets re-calculated.
If the tax determinants are added back, the new invoice line creation date would is after the deleted hold date.
Future Activity Amount in AP Aging Shows Incorrect Balances
The Future Activity Amount in AP Aging sometimes shows an incorrect balance due to the impact of Withholding tax calculations.
The Witholding tax calculation is excluded from the Invoice Schedule Amount, but the impact doesn't reflect the same in Fusion Data Intelligence payables.
There is no workaround for this issue.
Incremental Changes in Payables Due to Accounting Status Changes Not Updated
Any change in Fusion Applications due to a change in the Payables document Accounting Statusisn't reflected in in Fusion Data Intelligence.
In Fusion Applications, the Last Update Date (LUD) remains unchanged even after the Accounting status is changed. This happens because Accounting Status is a derived field in Fusion Applications and by design, the derived fields do not update the LUD. Fusion Data Intelligence relies on LUD for any incremental change which is why stale data remains in Fusion Data Intelligence.
Known Issues for Oracle Fusion ERP Analytics Project Billing
These Known Issues address the Project Billing functions.
Error Message with Cross-Subject Area Analyses Between Receivables Subject Area and PPM-Project Invoices Subject Area
You may encounter a table not found error message if only one of these functional areas – AR Unaccounted Transactions or Project Invoices Prior to Acceptance - is activated and you perform cross-subject area analysis between Accounts Receivables subject areas and the PPM- Project Invoices subject area.
Activate the Project Invoices Prior to Acceptance functional area to bring in invoices with statuses that are before the Accepted status as well in the PPM-Project Invoices subject area. Activating the AR Unaccounted Transactions functional area brings in Complete invoices that aren't yet accounted for in the AR Transactions and AR Revenue subject areas. When only one of these functional areas is activated, the query uses incorrect LTS which results in the table not found error.
To avoid this error activate both of these functional areas.
Cancelled Flag Isn't Correctly Populated for Project Invoices
When a Project Invoice is canceled in Fusion Applications, the Last_Update_Date of the table PJB_INVOICE_HEADERS isn't populated when the canceled flag column is updated.
Therefore, the Invoice canceled flag isn't reflected correctly in the PPM Project Invoice subject area during incremental updates. The column Cancelled_Flag is impacted in the below warehouse tables.
Impacted tables with the CANCELLED_FLAG column:
- DW_PROJECT_INVOICE_ALL_CF
- DW_PROJECT_INVOICE_CF
- DW_PROJECT_INVOICE_PRE_ACCPTD_CF
There is no workaround for this issue.
Known Issues for Oracle Fusion ERP Analytics Project Control
These Known Issues address the Project Control functions.
Records Not Deleted From the Plan Version Fact Tables
When a Plan Version is deleted in Fusion Applications, the data isn't deleted from the fact table DW_PROJECT_PLAN_LINE_DETAIL_CF; it's only deleted from DW_PROJECT_PLAN_VERSION_D.
To remove the deleted records from the fact table, perform a full load of Project Control functional area.
Known Issues for Oracle Fusion ERP Analytics Project Costing
These Known Issues address the Project Costing functions.
Records Dropped in Project Assets Subject Area When Adding Certain Metrics
Records are dropped in the Project Assets subject are when you add certain metrics.
Records are dropped in the Project Assets subject area when metrics such as Rejected CIP Cost, Capitalized Cost, Grouped CIP Cost, Unassigned CIP Cost, and Assigned CIP Cost are added, but there is no data for these metrics. If you need the Project Asset related attributes show, add the Grouped Cost metric along with the other metric. The Grouped Cost metric has a value for all Asset Lines, which resolves the error.
Labor Cost Amount Displays Incorrect Reprocessed Records in PPM Project Labor Distribution Costs
When labor cost is distributed based on multiple labor schedule versions and it's reprocessed, the metric Labor cost amount is incorrect in the PPM Project Labor Distribution Costs subject area.
The Distribution Amount metric shows the correct data. There is no workaround for this issue.
PPM Project Labor Distribution Costs Subject Area Doesn't Reflect Latest Status Code for Reprocessed Records
When you reprocess the labor cost, the status code in the PPM Project Labor Distribution Costs subject area folder Labor Distribution Cost Details isn't updated correctly.
To get the correct status codes, reset the Project Labor Distribution subject area.
Known Issues for Oracle Fusion ERP Analytics Receivables
These Known Issues address the Receivables functions.
Topics for Accounts Recievable:
- Backdated Invoices and Receipts Created in Fusion Receipts Don't Show Correct Amounts
- Data Validated Amount of Tax Distribution in AR Subject Areas Doesn't Match Fusion Applications
- Detail Line Number in the AR Revenue Subject Area is Incorrect
- Receivables Invoice with In Arrears Invoicing Rule and Receivables Accounting in a Future Period Displays the Incorrect Transaction and Line Amount
- Opening Amount Doesn't Match the Closing Amount of the Prior Period in AR Aging and AP Aging Subject Areas
Backdated Invoices and Receipts Created in Fusion Receipts Don't Show Correct Amounts
Backdated Invoices and Receipts created in Fusion Applications Receivables do not show the correct remaining balance, schedule, or snapshot in the AR Aging subject area.
In AR Aging, if backdated transactions are created or updated and the transaction schedule status is Closed, the remaining amount and schedule status aren't updated correctly in the daily incremental run. As a workaround, to see the backdated transactions correctly, reset the Receivable Aging functional area manually or schedule to run a full load of this functional area daily, weekly, or monthly depending on your reporting needs.
Data Validated Amount of Tax Distribution in AR Subject Areas Doesn't Match Fusion Applications
When there's a deferred tax transaction while performing Data Validation, even if the totals match, the Account Class code doesn't match due to the Oracle Transactional Business Intelligence Deferred Tax classification. While Oracle Fusion ERP Analytics considers it a Tax instead of Tax Distribution Amount, Oracle Fusion ERP Analytics doesn't classify Deferred Tax at the Account Class level, but instead as a Tax line.
There isn't a workaround.
Detail Line Number in the AR Revenue Subject Area is Incorrect
The detail line number in the AR Revenue subject area shows the same value as the parent line number.
This issue doesn't have a workaround.
Receivables Invoice with In Arrears Invoicing Rule and Receivables Accounting in a Future Period Displays the Incorrect Transaction and Line Amount
Until Release 22.R3, the AR Revenue subject area had distribution accounting entries for Receivables transactions that are accounted.
For transactions with the In Arrears invoicing rule, receivables accounting is generated at the end of the revenue recognition schedule. Transaction Amount and Line Amount for such transactions display the amounts based on the revenue that's recognized and the unrecognized revenue isn't included.
The AR Unaccounted Transactions functional area has been introduced in Release 22.R4. When this is activated, the AR Revenue subject areas show both accounted and unaccounted transactions as long as the transactions are Complete and the Revenue schedules are generated. Transaction Amount and Line Amount may still show incorrectly for partially accounted transactions in some scenarios when attributes such as Fiscal Period, Transaction Accounting Fiscal period (both anchored to Distribution Accounting Date), Accounted Indicator, Account Override Indicator, are used in the analysis. Partially accounted transactions are transactions having both accounted and unaccounted distributions in different periods.
This issue doesn't currently have a workaround.
Opening Amount Doesn't Match the Closing Amount of the Prior Period in AR Aging and AP Aging Subject Areas
In the AR Aging and AP Aging subject areas, the Opening Amount doesn't match the prior period Closing amount due to unaccounted applied transactions.
This issue happens because the Closing amount is derived from the Remaining balance of the transaction in Oracle Fusion Cloud Enterprise Resource Planning, which is the amount remaining after considering all application activities. However the Activity amount is calculated in the warehouse using only the accounted transactions. Therefore, if there are application transactions that aren't accounted, these aren't included when calculating the activity amount, which impacts the Opening Amount since Opening Amount is calculated as Closing Amount - Activity Amount. To work around this issue, account all the transactions in Fusion Applications Suite and check the amounts after an incremental run.
Updates or Changes in Cost Accounting Distribution Details Aren't Seen in Cost Accounting Subject Area
Updates or changes in the cost accounting distribution details aren't seen in the Oracle Fusion SCM AnalyticsCost Accounting subject area.
The last update date in the Cost Accounting Distribution Lines table isn't getting updated in Oracle Fusion Cloud Supply Chain Planning. Because of this, Oracle Fusion SCM Analytics and Oracle Fusion Cloud Supply Chain Planning aren't synchronized.
To work around this issue, reset the Cost Accounting functional area manually or schedule a full load run of this functional area daily, weekly, or monthly depending on your reporting needs.
Incorrect Costing Status Shown in Cost Accounting Subject Area
For the cost transaction, when the costing status changes from Error to Excluded for Accounting, the data will continue to load to Oracle Fusion Data Intelligence with status Error even if the status changed on Fusion Applications to Excluded for Accounting.
To work around this issue, reset the data pipeline for the Cost Accounting functional area on a weekly basis. See Refresh a Data Pipeline for a Functional Area.
This issue will be fixed in a future release.
Inventory Balance Analysis Shows On-Hand Data on Previous Day
The Inventory Balance Analysis data visualization shows on-hand data as being on the previous day.
There is currently no workaround for this issue.
Inventory Receipts Features Aren't Visible After Enabling Inventory Receipts Functional Area
After enabling the Inventory Receipts Functional Area, features for the Functional Area aren't available.
To work around this issue, in the Preview Features panel of the Console, disable and enable (toggle) the Inventory Receipts functional area once to see all the Inventory Receiptsfeatures.
Known Issues for Fusion SCM Analytics Manufacturing
These Known Issues address the Manufacturing functions.
Reports for Manufacturing Operation Transactions Show Duplicate Results
The grain for the Manufacturing Operation Transactions subject area is at the Work Order Operation Transactions level and Work Order Outputs level.
You may see duplicate results if a report is built from both Work Order Operation Transactions level and Work Order Output level.
There is no workaround for this issue.
Serial and Lot Number Not Supported for Material Items and Product Items in Manufacturing Materials Subject Area
In the Manufacturing Materials subject area, the Serial and Lot Number attributes aren't supported at both the Material Items and Product Items levels.
To work around this issue, built reports using either the Material Item level or the Product Item level.
Known Issues for Fusion SCM Analytics Purchasing
These Known Issues address the Purchasing functions.
In Purchase Orders Subject Area Closed PO Count Metric and Open PO Count Metric is Incorrect
In the Purchase Orders subject area, the purchase orders line status doesn't get updated in Fusion Data Intelligence as it does in Oracle Fusion Cloud Applications.
This issue causes the Closed PO Count metric and Open PO Count metric to be incorrect in Fusion Data Intelligence due to the last update date not being updated in the source, so the incremental load isn't updated in Fusion Data Intelligence.
To work around this issue, reset the data pipeline for the Purchasing functional area on a weekly baseis. See Reset a Data Pipeline for a Functional Area. This issue will be fixed in a future release.
Incorrect Values for Header Released Amount and Line Released Amount Metrics in the Agreement Subject Area
The Header Released Amount and Line Released Amount metrics in the Agreement Subject Area shows incorrect values due to an error in identifying when the agreement was last updated.
To work around this issue, reset the data pipeline for the Purchase Agreement functional area every weekend. See Reset a Data Pipeline for a Functional Area.
Known Issues for Fusion SCM Analytics Sales Orders
These Known Issues address the Sales Orders functions.
Project Attribute Columns are Deprecated in Sales Order Fulfillment Lines
Project attribute columns are deprecated from the Sales Order subject area.
Supplier and Supplier Site Columns Show Null Value in Back-to-back Sales Order Fulfillment Lines
Supplier and Supplier site columns show null value in the Back-to-back Sales Order fulfillment and Supply lines.
Duplicate records were being created in the Back-to-back Sales Order scenarios that have multiple POs with multiple Supplier and Supplier Sites for the same Supply Tracking Line. To avoid incorrect data, the Supplier and Supplier Sites columns are being populated with null values.
There is no work around for this.
Sales Credits Data Deleted in Fusion Applications Continues to Show in Fusion Data Intelligence
Sales Order Sales Credits records deleted from the Fusion Applications source continue to appear in Fusion Data Intelligence.
This scenario shows data mismatch between the Fusion Applications and Fusion Data Intelligence. This would be reintroduced once the issue is fixed in the Fusion source application.
To work around the issue, reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Known Issues for Oracle Fusion CX Analytics
Learn about the issues you may encounter when using Oracle Fusion CX Analytics and how to work around them.
Oracle Fusion CX Analytics Common Issues
Learn about the issues you may encounter when using Oracle Fusion CX Analytics and how to work around them.
Topics:
- Data Deleted in Fusion Application Shows in Fusion Data Intelligence
- Corporate/CRM Currency May Show Old Corporate Currency Code
- Reset the Warehouse and Reload the Data if Existing Security Conditions in an Access Group are Modified
- Issue with lastModifiedDate for Deleted Contacts in Eloqua
- Disabled Features in Salesforce Show as Enabled in Oracle Fusion Data Intelligence
Data Deleted in Fusion Application Shows in Fusion Data Intelligence
When records such as Opportunity, Revenue Line. etc., are deleted in the source Fusion Applications. the deleted objects aren't deleted from Fusion Data Intelligence.
This scenario shows a data mismatch between Fusion Applications and Fusion Data Intelligence.
To work around the issue, the reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Corporate/CRM Currency May Show Old Corporate Currency Code
If the corporate or CRM currency is changed in Fusion Applications, then the data created with the older corporate currency continues to show values with the original corporate currency code in Oracle Fusion CX Analytics.
For example, you create opportunities in Oracle Fusion Cloud Sales Automation with the corporate currency of US dollars. If the corporate currency changes to euros, and the Oracle Fusion CX Analytics report uses facts from the CX Currency folder, then Oracle Fusion CX Analytics shows older opportunities in US dollars and newer opportunities in euros.
To work around this issue, set the analytics currency in Fusion Data Intelligence to the same currency as the corporate currency in Fusion Applications, and you can use the facts from the analytics currency folder. This ensures the currency is consistent between applications. See Set Up the Pipleine Parameters.
Reset the Warehouse and Reload the Data if Existing Security Conditions in an Access Group are Modified
Whenever any new security condition is setup, Oracle Fusion Data Intelligence reads the data from Oracle Fusion Cloud Applications and applies the same security condition to the data.
If the existing security conditions are modified, the previous security conditions data may persist and provide an incorrect outcome. For example, if there is a security condition to grant a user access to all the Opportunities in EU region, then Oracle Fusion Data Intelligence copies over all the Opportunity Ids for EU region against that security condition. If the same condition is updated in Fusion CX Sales, to restrict the data to Opportunities only in Germany, then the new Opportunity IDs belonging to Germany (for this security condition) gets copied over. But the previous Opportunity IDs also exist in the system thereby giving an incorrect data security result.
To work around this issue, reset the data warehouse (see Reset the Data Warehouse) and refresh the data pipeline (see Refresh a Data Pipeline for a Functional Area.
Issue with lastModifiedDate for Deleted Contacts in Eloqua
When contacts are deleted in Eloqua, the contacts aren't updated in Oracle Fusion Data Intelligence since the lastModifiedDate for deleted contacts isn't updated.
You'll see deleted contacts and related activities in Oracle Fusion Data Intelligence even though they've been deleted in Eloqua.
Disabled Features in Salesforce Show as Enabled in Oracle Fusion Data Intelligence
Salesforce features show enabled in Oracle Fusion Data Intelligence, therefore the subject areas show dimensions and facts, but these featues are actually disabled in Salesforce.
The following list shows some features that are optional in Salesforce and supported in Oracle Fusion Data Intelligence, which are set conditionally (Y/N) in Oracle Fusion Data Intelligence.
- Opportunity Split
- Product Split
- Product Schedule
- Fiscal Calendar
- Campaign Influence
- Territory Management
- Multiple Currency
- Advanced Currency Management
If you initially enable this feature and then disable it in Salesforce, you need to reset the data warehouse and refresh the data pipeline. See Reset the Data Warehouse and Refresh a Data Pipeline for a Functional Area.
However, the feature is enabled and then enabled, you don't need to take any action.
Oracle Fusion CX Analytics Sales Issues
Learn about the issues you may encounter when using Oracle Fusion CX Analytics Sales and how to work around them.
Topics:
- INDUSTRY_CLASS_CATEGORY Field Shows Old Value
- Issue with Custom Fixed Choice List, Custom Dynamic Choice List, and CLOB Extension Attributes
- Opportunity Quotes Subject Area Shows Quote for a Deleted Opportunity
- Activity Count Shows an Incorrect Value When Any Recurring Appointment Changes
- Revenue Line Amount Shows an Incorrect Value When Quantity, UnitPrice, and Revenue Amount Updates with the Addition of a Split Line
INDUSTRY_CLASS_CATEGORY Field Shows Old Value
The INDUSTRY_CLASS_CATEGORY field populates when a new Lead is created and the value is set in the profile option: MOT_INDUSTRY_CLASS_CATEGORY.
When this profile option changes, and an existing Lead with an old Industry Classification value updates, the database still saves an incorrect older code against the INDUSTRY_CLASS_CATEGORY.
This issue doesn't currently have a workaround..
Issue with Custom Fixed Choice List, Custom Dynamic Choice List, and CLOB Extension Attributes
The custom attributes created for an object are added to the warehouse using the Data Augmentation feature.
For the custom fields of type Fixed Choice List (FCL), Dynamic Choice List (DCL), CLOB, the field labels don't show up.
- Add the column to the dimension using data augmentation.
- Create a new logical column based on step 1 using a semantic model extension.
- Hide the column created in step 1 using the semantic model extension security framework.
Note:
Use the Oracle Fusion Cloud Sales Automation Application Composer Confiuration Report for information about customer fields, their physcial column names, and their labels. See How to View Application Composer Changes in Cloud Customizing Sales.Opportunity Quotes Subject Area Shows Quote for a Deleted Opportunity
When an Opportunity is deleted, the Quotes table still has a reference to the deleted Opportunity, therefore it's still considered a valid Opportunity Quote.
To work around this issue, for reports built using the CX-Opportunity Quotes subject area, include a fact or any attribute from an Opportunity or other dimension.
Activity Count Shows an Incorrect Value When Any Recurring Appointment Changes
When a recurring meeting is updated, for example increasing or decreasing the number of recurrences or other changes, then the Last Update Date column isn't updated in the Activity and the Activity Resource tables.
The Incremental run in Fusion Data Intelligence depends on Last Update Date. Because the date isn't changed, the incremental run doesn't fetch those changes and transfer them to the warehouse tables.
To work around the issue, the reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Revenue Line Amount Shows an Incorrect Value When Quantity, UnitPrice, and Revenue Amount Updates with the Addition of a Split Line
When a Revenue Line is Split, and Quantity, Unit Price, and Revenue Amount are also updated at the same time and saved, the Last Updated Date doesn't update, so the updated Revenue Line related details aren't read by the warehouse.
The Incremental run in Fusion Data Intelligence depends on Last Update Date. Because the date isn't changed, the incremental run doesn't fetch those changes and transfer them to the warehouse tables.
To work around the issue, the reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Oracle Fusion CX Analytics Subscription Issues
Learn about the issues you may encounter when using Oracle Fusion CX Analytics Subscriptions and how to work around them.
Topics:
- Incorrect Subscription MRR When the Field is Manually Edited in Fusion Applications
- Subscription Invoice Amount Shows Incorrect Value After Changes
- Renewed Subscriptions Many Not Show Renewed Date
- Subscription Historical Trend Subject Area Inaccurately Shows Subscriptions as Active
- Subscription Historical Trend Subject Area Aggregate Date May Show Incorrect Values
- Customers with Existing Subscriptions Show as New Customers in Subscription Reports
- Global Security Granted in Subscription Doesn't Work in Access Groups or Other Security Models
Incorrect Subscription MRR When the Field is Manually Edited in Fusion Applications
Subscription Product line details page may have the MRR field exposed from the Fusion Applications Composer.
The MRR field should be a read-only field, however it's editable, which is the issue. If the values of these fields change, then the CX - Subscription Historical Trend subject area shows an incorrect value.
||Period||MRR||
|Jan-2022|$600|
|Feb-2022|$600|
|Mar-2022|$600|
||Period||MRR (Expected to see)||MRR (would show up)||
|Jan-2022|$600|$700|
|Feb-2022|$600|$700|
|Mar-2022|$700|$700|
There isn't currently a workaround.
Subscription Invoice Amount Shows Incorrect Value After Changes
A subscription invoice amount may show an incorrect value when changes are made to the invoice after it's first generated.
When the billing lines are updated in existing subscriptions invoices, however the last updated date doesn't change in the system. Therefore, the changes aren't updated in the warehouse.
To work around the issue, the reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Renewed Subscriptions Many Not Show Renewed Date
When a subscription is renewed, thereby creating a new subscription, the last updated date for the subscription doesn't change.
Because the updated date isn't captured, the warehouse doesn't show the Renewed Date accurately even though the subscription was created by the renewal process.
To work around the issue, the reset the warehouse (see Reset the Data Warehouse) and reload the data pipeline (see Reload a Data Pipeline for a Functional Area).
Subscription Historical Trend Subject Area Inaccurately Shows Subscriptions as Active
If the ESS job to update the subscription status is run after the Oracle Fusion Data Intelligence incremental job, an expired subscription may show as Active in the Subscription Historical Trend subject area.
To avoid this issue, schedule the ESS job prior to the Oracle Fusion Data Intelligence incremental run.
If the data shows incorrectly, reset the warehouse (see Reset the Data Warehouse) and reset the data pipeline (see Reset a Data Pipeline for a Functional Area).
Subscription Historical Trend Subject Area Aggregate Date May Show Incorrect Values
In the Subscription Historical Trend subject area, the Aggregate Date dimension may show incorrect month-week-date column values when pulled in to the same report.
The Aggregate Date dimension specifies the date/week/month/year time interval over which the Subscription data has been aggregated. You can see the Active MRR (as an example) over the past 30 days or 52 weeks or 12 months etc.
When the month and date are added in the same report (not an intended use case), the date values may show incorrect data.
For example, the Subscription Aggregate Date has a value of 31/01/2021 12:00:00 AM, but the Subscription Aggregate Month has a value of 2021/02.
This is caused by the week rolling over to the month based on the join criteria: Week_End_Date = Month_Start_date.
Week_code = '2021 Week14'
period_start_date = 28-MAR-21
period_end_date = 03-APR-21
month_code = '2021 / 04'
quarter_code = '2021 Q 2'
This issue occurs when the week spans two months and the week isn't a starting or end week of the corresponding year.
To work around this, don't use multiple time levels in the same report for the Aggregate Date dimension, because this date dimension analyzes the aggregated Subscription trends data for a specific time level, and isn't recommended for other time dimensions when aggregating data at multiple time levels.
Customers with Existing Subscriptions Show as New Customers in Subscription Reports
The initial extract date (IED) defined in Oracle Fusion Data Intelligence determines the data extract date from the Oracle Fusion Cloud Applications Suite. If transactions occurred before the initial extract date and are still active, they might not be captured.
For example, if a customer ordered a 3 year subscription for 1 Jan 2020 to 31 Dec 2022, and the initial extract date is set as 1st Jan 2021, then the subscription won't be captured in Oracle Fusion Data Intelligence unless you update the data. If the same customer orders another subscription on 1 Aug 2021, it becomes the first subscription in Oracle Fusion Data Intelligence for this customer and the application erroneously marks the transaction as a new Customer. You need to be sure to select the correct initial extract date before extracting data into the warehouse.
To work around this issue, run an ESS job before initiating the Oracle Fusion Data Intelligence incremental run. If the data still shows up incorrectly, reset the data warehouse (see Reset the Data Warehouse) and refresh the data pipeline (see Refresh a Data Pipeline for a Functional Areawould need to be [reloaded|https://docs.oracle.com/en/cloud/saas/analytics/fawag/reload-data-pipeline-functional-area.html]).
Global Security Granted in Subscription Doesn't Work in Access Groups or Other Security Models
Granting global security in a subscription, such as providing access to all subscriptions for a given user, doesn't work if the security is set up using access groups or other security models.
You can grant security access using one of these methods.
Option 1: Disable access group based security
- Copy the Subscription Specialist role.
- Remove these two duty roles from the user in Oracle Fusion Data Intelligence:
- Subscription Business Unit Data Security (OA4F_CX_SUBSCRIPTION_BUSINESS_UNIT_DATA)
- Subscription Custom and System Access Group Data Security (OA4F_CX_SUBSCRIPTION_CUSTOM_DATA)
- Assign the user to the Subscription Specialist role.
Option 2: Use FND Grants (BU-based security)
Prerequisite: User must be assigned the OA4F_CX_SUBSCRIPTION_BUSINESS_UNIT_DATA role.
Create a new Security Console security assignment for the user.
- Sign in to Oracle Fusion Data Intelligence.
- On the Home page, open the Navigator menu, click Console, and then click Security under Service Administration.
- On the Security page, click the Security Assignments tab.
- Click New Assignment
- Select the Subscription Business Units security context.
- In Security Values, select the appropriate business unit, and under Users select the appropriate user name.
- Click Add to Cart and then click View Cart.
- In Security Assignments, click Apply Assignments.
Option 3: Use Custom Security
Prerequisite: User must be assigned the OA4F_CX_SUBSCRIPTION_CUSTOM_DATA role.
You can grant custom global security using the Business Unit as an Object Attribute.
- Sign in to Oracle Fusion Data Intelligence as a Global Security Manager.
- Navigate to Tools and then to Sales and Service Access Management .
- Under Configure Groups, create a new access group with a rule set to the list of business units.
- Publish the rules.
Oracle Cloud Known Issues for Oracle Fusion Data Intelligence
G27917-03