What’s New for Oracle Fusion Analytics Warehouse

Here’s an overview of the features and enhancements added recently to improve your Oracle Fusion Analytics Warehouse experience.

Topics

Release 21.R3.P4 - December 2021

Your environment was updated to this release on Saturday, December 11, 2021. This update includes no changes to the application data or content but does include the features outlined in the following table.

General

Feature Description
Upload and download your data Upload and download data such as data security assignments, financial categories, financial category assignments, and user to group associations to your data warehouse using the Upload tile on the Console. See Manage Uploads and Downloads.
Track usage Usage tracking has been turned on in the Oracle Analytics Cloud instance associated with your Oracle Fusion Analytics Warehouse instance. Usage tracking enables administrators to track user-level queries on the content. Service administrators and functional administrators can track user queries and generate reports and visualizations to analyze the usage data.
Update your application As a service administrator, you can decide when to uptake the application updates except the emergency patches that are deployed automatically. See Manage Application Updates.
Authenticate your Oracle Applications Cloud source using the JSON web token

JSON web token-based (JWT) authentication avoids the issue of expiring or overwriting the Oracle Applications Cloud user passwords. This authentication eliminates latency in data refresh. See Create an Oracle Fusion Analytics Warehouse Subscription Instance and Update the Data Source Connection Details.

Define inline augmentations Inline augmentation enables you to define internal data sets, and set filter and joins to perform custom transformations. See Augment Your Data.
Update your source credentials prior to validating data Prior to validating the data after loading the source data in to your data warehouse, if your source password has expired, then set the new password using the Source Credentials tab. See Prerequisites for Data Validation.
Examine the status of security-related activities The History tab on the Security page displays a status icon next to each action that shows the status such as "in progress" or "completed successfully". See View Activity History.
Use the enhanced New Security Assignment functionality While creating a security assignment, use the enhanced New Security Assignment functionality. See Create a Security Assignment.
Copy data security assignments in bulk Use the enhanced Copy Assignment functionality to copy data assignments in bulk. See Copy Data Security Assignments.
Use period for calendars You can use period in the same way as month in application data. See Create a KPI.

Earlier Releases

Release 21.R3.P2 - November 2021

This major release update includes new or changed application data or content. You can apply this update yourself by accessing the Console and clicking Release Updates under Service Administration and locating the 21.R3 update. See Manage Application Updates.

Oracle Fusion ERP Analytics

Feature Description
Additional subject areas These subject areas have been added:
  • Assets Analysis subject area provides the ability to analyze fixed asset details, asset health, and life cycle tracking over a period of time at the asset book level with associated attribute details and key metrics.
  • Assets Transactions subject area provides the ability to analyze key metrics around assets adjustment transactions and associated accounting details.
  • Project Costs subject area provides the ability to report on actual Cost (Burdened Cost), Raw Cost, and Burden Cost charged to a project along with the GL account for all accounted cost distributions.
  • Requisitions subject area provides the ability to analyze requisitions to detect purchase inefficiencies and improve procurement performance.
Updated subject areas These subject areas have been updated as follows:
  • Tax Rate Name and Withholding Tax Calculation Point attributes in AP Expense subject area display the name instead of the ID or code.
  • In GL Budgets subject area, Budget Scenario and Budget Description attributes are hidden with the introduction of Scenario dimension.
  • In Purchase Orders subject area, fiscal calendar attributes are based on the ledger associated with the requisition business unit.
  • In Receipt subject area, fiscal calendar attributes are based on the ledger associated with the requisition business unit.
  • In Agreements subject area, the fiscal calendar attributes are no longer available.
Enhanced subject areas These subject areas have been enhanced as follows:
  • AP Liabilities subject area uses aggregate fact table to improve performance when querying summary data.
  • AR Aging subject area includes Unapplied Receipts.
  • GL Profitability and GL Balance Sheet subject areas include scenario dimension and ability to perform Budget versus Actuals variance analysis.
  • GL Account Analysis subject area supports Supplier site dimension.
  • AP Expense and Employee Expense subject areas have project attributes.
  • AP Expense subject area has asset attributes
  • AR Revenue subject area has Tax Line Number attribute.
Attributes added to existing subject areas The following subject areas have these additional attributes:
  • GL Account Analysis subject area: Supplier Site Name, Supplier Site Number, Supplier Site Account Group, Supplier Site Payment Terms Name, Supplier Site Payment Group Name, Supplier Site City, Supplier Site State, Supplier Site Country, and Supplier Site Postal Code
  • GL Balance Sheet, GL Profitability, GL Budgets subject areas: Scenario and Scenario description
  • AR Aging subject area: AR Receipt Business Unit, Receipt Details folder with Receipt Number, Receipt Date, and Risk Indicator.
  • AR Revenue subject area: Tax Line Number
  • EXM Employee Expenses subject area: Project Number, Task Number, and Expenditure Item Date
  • AP Expenses subject area: Project Number, Project Name, Project Description, Task Number, Task Name, Task Description, Expenditure Type, Expenditure Type Description, Expenditure Organization, Expenditure Item Date, Track as Asset Indicator, Asset Addition Indicator, Asset Book, and Asset Category
  • Spend subject area: Supplier Category Hierarchy, Master Organization Name, and Item Description
  • Purchase Order subject area: Ledger, Procurement Business Unit, Requisition Business Unit, Agreement Procurement Business Unit, Item Description, Negotiated Indicator, Discount, Discount Type, and Discount Reason
  • Agreement subject area: Business Unit, Shipping Method, and Item Description
  • Receipts subject area: Ledger, Business Unit, Procurement Business Unit, Requisition Business Unit, and Item Description
Metrics added to existing subject areas These subject areas have additional metrics:
  • AR Aging subject area: Risk Amount
  • Spend subject area: Invoice Price Variance
  • Purchase Order subject area: Supplier Count, Rejected Quantity %, Over Receipt Quantity %, Canceled Quantity %, Negotiated Amount, Over Receipt Amount, Open PO Amount, Open PO Count, Closed PO Amount, and Closed PO Count
Upload and maintain mapping of Natural Account segment values You can upload and maintain the mapping of Natural Account segment values to Financial Category in Oracle Fusion Analytics Warehouse instead of Oracle ERP Cloud.
Enhanced set of KPIs The set of KPIs includes 5 more Assets Analysis KPIs, 7 more Assets Transactions KPIs, 9 more Requisitions KPIs, and 22 more Projects Costs KPIs.
Additional visualizations These visualizations have been added:
  • AP Liabilities Analysis
  • AP Aging Analysis
  • Assets Activity Analysis
Updated visualization projects The visualization projects based on Agreements subject area refer to the Gregorian calendar attributes instead of the fiscal calendar attributes.
Updated KPIs These KPIs have been updated as follows:
  • KPIs based on Agreements subject area refer to the Gregorian calendar attributes instead of the fiscal calendar attributes.
  • KPIs based on Purchase Orders and Receipt subject area use requisition business unit to get fiscal calendar attributes.
Updated decks and cards Decks and cards based on Purchase Orders subject area use requisition business unit to get fiscal calendar attributes.
Certain view objects are no longer supported as data enrichment source The FscmTopModelAM.FinLeLegalEntitiesAM.LegalEntityPVO view object is no longer supported as a source for data enrichment.
Deprecated warehouse tables The DW_GL_VARIANCE_CF table has been deprecated.

See Implementing Oracle Fusion ERP Analytics.

Oracle Fusion HCM Analytics

Feature Description
Additional subject areas These subject areas have been added:
  • HCM - Succession Management subject area provides insight into an organization’s planning and preparation on the workers succession management. A comprehensive view of the plans, incumbents, and candidates with relevant metrics to analyze are available.
  • HCM - Talent Review Meetings subject area provides the details of the meetings including the calibrated ratings as an outcome of the talent review meeting. The initial ratings prior to the meetings are also available for comparison. Use the Time dimension to report on the history data related to workers talent review, the assessment, and ratings.
Enhanced subject areas
  • HCM - Talent Acquisition subject area: Enhanced to include the phase sequence and state sequence numbers in the requisition and application folders. These enhancements allow you to report on the count of requisitions and applications that flow across each phase and states, and also the duration between each.
  • HCM - Workforce Core subject area:
    • Enhanced with two new fact folders that has the metrics based on person counts rather than the headcount. The folders include the Workforce Person Count and Person Attrition Counts facts.
    • The Ethnicity folder in this subject area is enhanced to add the Ethnicity - All and Ethnicity Code - All attributes. These attributes enable you to report on all the ethnicities of the worker in addition to the primary ethnicity attribute that is currently available.
    • A new metric that takes into account all the worker ethnicities is added in Facts - Workforce Diversity > Distinct Worker Ethnicities - All.
    • Supports Person Legislative descriptive flexfield.
  • HCM - Workforce Absence Management: Enhanced with the following metrics in Fact - Absence Calendar > In-Progress Absence Fact - Absence Entry > No. Of Absences
  • HCM - Workforce Rewards - Workforce Compensation: Enhanced with the following metrics:
    • Facts- Compensation plan > Plan - Amount in Transaction Currency > Base Salary Change Value.
    • Facts- Compensation plan > Plan - Amount in Warehouse Currency > Base Salary Change Value.
    • Plan - Amount In Warehouse Currency Component - Amount in warehouse currency Budgets- Amount in Warehouse Currency > Exchange Rate Date.
Additional deck The Talent Acquisition deck is added.
Additional visualization project The Talent Acquisition Dashboard based on the Talent Acquisition module is available.

See Implementing Oracle Fusion HCM Analytics.

Release 21.R2.P7 - September 2021

General

Feature Description
Enhance session variable steps You can configure cache settings using row-wise initialization on customization steps. See Add Session Variables.
Join a fact to multiple dimensions You can join a single fact column to multiple dimensions. See Add a Dimension.
Specify where a fact is aggregated You can specify the level of the dimension hierarchy where a fact is aggregated. See Add a Dimension.

Release 21.R2.P5 - August 2021

Oracle Fusion ERP Analytics

Feature Description
Deprecated warehouse tables These tables are deprecated and replaced by the tables in the next list:
  • DW_GL_SLA_RECONCILIATION_CF
  • DW_AR_SLA_APPLICATIONS_F
  • DW_AR_SLA_SCHEDULES_F
  • DW_AR_SLA_ADJUSTMENTS_F
  • DW_AR_SLA_CREDITMEMO_F
  • DW_AR_SLA_REVENUE_F
  • DW_AR_SLA_AGING_INVOICE_A
  • DW_AP_SLA_INVOICE_SCHEDULE_F
  • DW_AP_SLA_EXPENSE_DIST_F
  • DW_AP_SLA_LIABILITY_DIST_F
  • DW_AP_SLA_PAYMENTS_F
  • DW_AP_HOLDS_F
  • DW_AP_SLA_AGING_INVOICE_A
Data for the deprecated tables above is available in these tables:
  • DW_GL_SLA_RECON_CF
  • DW_AR_SLA_APPLICATIONS_CF
  • DW_AR_SLA_SCHEDULES_CF
  • DW_AR_SLA_ADJUSTMENTS_CF
  • DW_AR_SLA_CREDITMEMO_CF
  • DW_AR_SLA_REVENUE_CF
  • DW_AR_SLA_AGING_INVOICE_CA
  • DW_AP_SLA_INVOICE_SCHEDULE_CF
  • DW_AP_SLA_EXPENSE_DIST_CF
  • DW_AP_SLA_LIABILITY_DIST_CF
  • DW_AP_SLA_PAYMENTS_CF
  • DW_AP_HOLDS_CF
  • DW_AP_SLA_AGING_INVOICE_CA
These tables are fully deprecated and don't have replacements:
  • DW_GL_SUBLEDGER_LINKAGE_G
  • DW_AR_APPLICATIONS_CF
  • DW_AR_APPLICATIONS_F
  • DW_AR_SCHEDULES_CF
  • DW_AR_SCHEDULES_F
  • DW_AR_ADJUSTMENTS_CF
  • DW_AR_ADJUSTMENTS_F
  • DW_AR_CREDITMEMO_CF
  • DW_AR_CREDITMEMO_F
  • DW_AR_REVENUE_CF
  • DW_AR_REVENUE_F
  • DW_AR_AGING_CUSTOMER_CA
  • DW_AR_AGING_INVOICE_CA
  • DW_AR_AGING_INVOICE_A
  • DW_AR_BALANCE_CF
  • DW_AR_BALANCE_F
  • DW_AP_INVOICE_SCHEDULES_CF
  • DW_AP_INVOICE_SCHEDULES_F
  • DW_AP_EXPENSE_DISTRIBUTION_CF
  • DW_AP_EXPENSE_DISTRIBUTION_F
  • DW_AP_LIABILITY_DISTRIBUTION_CF
  • DW_AP_LIABILITY_DISTRIBUTION_F
  • DW_AP_PAYMENTS_CF
  • DW_AP_PAYMENTS_F
  • DW_AP_AGING_SUPPLIER_CA
  • DW_AP_AGING_INVOICE_CA
  • DW_AP_AGING_INVOICE_A
  • DW_AP_BALANCE_CF
  • DW_AP_BALANCE_F

See Implementing Oracle Fusion ERP Analytics.

Release 21.R2.P4 - August 2021

Oracle Fusion HCM Analytics

Feature Description
Enhanced subject areas HCM-Workforce Core subject area is enhanced to allow the line managers to report on terminated workers within their managerial hierarchy.

See Implementing Oracle Fusion HCM Analytics.

General

Feature Description
Associate time-based KPIs with specific calendars Associate time-based KPIs with a specific calendar: Column-driven, Gregorian, or Enterprise for the Calendar Type. See Create a KPI.
Automatically update your instance with the latest Oracle Fusion Analytics Warehouse release You can schedule all content patches to install automatically. See Schedule the Content Patch Upgrade.
Apply complex joins to tables using an expression You can include complex joins in a custom dimension table using the Expression Editor. See Add a Dimension.
Copy application roles to groups You can copy the application roles from an existing group to another or new group. See Copy Application Roles to a Group.

Release 21.R2.P2 - June 2021

Oracle Fusion ERP Analytics

Feature Description
Additional subject areas These subject areas have been added:
  • EXM Employee Expenses subject area provides the ability to analyze employee spend of an organization across company, cost center, expense types, expense categories, and associated dimensions.
  • Purchase Orders subject area combines the information from the purchase orders, purchase order costs, and purchase schedules. This subject area has the ability to report on committed amounts, contract spend, and purchase orders of the suppliers of an organization across suppliers, company, products, item categories, and associated hierarchies at purchase order line level.
  • Purchase Receipts subject area provides the ability to report purchase receipts of an organization across suppliers, company, location, products, item categories, and associated hierarchies at purchase receipt line level.
  • Purchase Agreements subject area provides the ability to report on purchasing agreement measures like consumed amount, count of agreements, day to expire analyzed by supplier, procurement item, and business units. It also provides the ability to analyze the purchasing blanket agreements and contract agreements details.
Enhanced subject areas These subject areas have been enhanced:
  • GL Account Analysis: Includes all accounting distributions from AR and AP subledgers.
  • AP Liabilities: Includes Payment liability distributions in addition to invoice liability. This provides the ability to analyze Liability balance amount as of a specific accounting date.
  • AR Receipts and Applications: Supports Miscellaneous receipts.
  • AR Credit Memo Application: Ability to perform analysis across subject areas with the AR Transaction subject area that fetches the applied and on-account credit memos.
Updated subject areas As part of multi-language support, the following attributes are hidden:
  • Day Code attribute from all date dimensions.
  • Ledger Type Code, Sub Ledger Accounting Method Code, and Account Type Code attributes from all subject areas.
  • Supplier Site Payment Group Code, Approval Status Code, Validation Status Code, Invoice Payment Method Code, Payables Source Code, Transaction Type Code, Installment Payment Status Code, Invoice Accounting Status Code, and Account Class Code from all relevant AP Subject areas.
  • Organization Type Code, Customer Category Code, Customer Account Type Code, Customer Account Class Code, Transaction Class Code, Transaction Source Code, and Schedule Status Code from all relevant AR subject areas.
Additionally, the following attributes are hidden from these subject areas:
  • GL Detail Transactions subject area: Posted Status Code, Journal Header Id
  • GL Account Analysis subject area: Event Class Code, Event Type Code, Transfer to GL Status Code, Journal Header Id
  • AP Invoices subject area: Journal Header ID
  • AP Payments subject area: Payment Status Code, Payment Distribution Type Code, Payment Method Code
  • AP Expenses subject area: Distribution Validation Status Code
  • AP Holds subject area: Hold Reason Code, Hold Type Code, Release Reason Code, Release Type Code
  • AR Receipts and Applications subject area: Receipt Status Code, Receipt Type Code, Receipt Application Status Code
  • AR CM Applications subject area: Credit Memo Application Status Code
  • AR Adjustments subject area: Adjustment Status Code
Additional visualization projects and KPIs These visualization projects and KPIs have been added:
  • 3 visualization projects and 6 KPIs for the EXM Employee Expenses subject area.
  • 1 deck, 1 visualization project and 39 KPIs for the Purchase Orders subject area.
  • 1 visualization project and 28 KPIs for the Purchase Agreements subject area.
  • 1 visualization project and 25 KPIs for the Purchase Receipts subject area.
Attributes added to existing subject areas The following subject areas have these additional attributes and dimensions:
  • GL Detail Transactions subject area: Journal Header Identifier, Reconciliation Reference
  • GL Account Analysis subject area: Business Unit, Journal Header Identifier, Reconciliation Reference
  • AP Liabilities subject area : Payment Document Number, Payment Date, Source Distribution Type
  • AP Payments subject area : Payment Void Date, Third Party Remit-to Supplier
  • AP Expenses subject area: Tax Details folder with Tax Classification, Tax Rate Name, Tax Rate, Tax Regime, Tax Name, Tax Jurisdiction, Self Assessed Tax Indicator, Withholding Tax Calculation Point
  • AR Receipts and Applications subject area: Added Bill-to Customer, Sold-to Customer, Paying Customer, Bill-to Customer Account, Paying Customer Account folders with respective Name and Number attributes, Paying Customer Site folder with Name, City, County, State, Country attributes, Reference Site Name, Receipt Currency, Receivables Activity, Tax Rate Code, Tax Rate, Reference Type, Reference Number, Transaction Type, Transaction Source
  • AR Transactions subject area: Added Bill-to Customer, Sold-to Customer, Bill-to Customer Account folders with respective Name and Number attributes
  • AR CM Applications subject area: Added Bill-to Customer, Sold-to Customer, Bill-to Customer Account folders with respective Name and Number attributes, Transaction Type, Applied Transaction type, Transaction Source and Applied Transaction Source name and descriptions
  • AR Adjustments subject area: Added Bill-to Customer, Sold-to Customer, Bill-to Customer Account folders with respective Name and Number attributes, Transaction Type and Transaction Source dimensions
  • AR Aging subject area: Added Bill-to Customer, Sold-to Customer, Bill-to Customer Account folders with respective Name and Number attributes
  • AR Revenue subject area : Added Bill-to Customer, Sold-to Customer, Bill-to Customer Account folders with respective Name and Number attributes, Tax Classification to Tax Line Details folder and Tax Details folder with Tax Rate Name, Tax Rate, Tax Regime, Tax Name, Tax Point Basis, Tax point Date and Place of Supply attributes
  • All subject areas: Added Trailing Period Number, Trailing Quarter Number, and Trailing Year number to date dimensions
Metrics added to existing subject areas The following subject areas have these additional metrics:
  • AP Liabilities subject area: Liability Balance Amount
  • AR Receipts and Applications subject area: Credit Card Refund Amount, Credit Card Chargeback Amount
Data Validation enhancements The following enhancements are available:
  • Added Invoice Date pivot attribute to Total Outstanding Amount metric validation of AP Aging.
  • Added Account Class filter attribute to Payment Distribution Amount metric validation of AP Payments.
  • Added Receipt Type Name filter attribute and pivot attribute to Receipts Amount metric validation of AR Receipts and Applications.
  • Changed the filter attribute and pivot attribute Customer Name to Paying Customer Name in Receipts Amount and Receipts Application Amount metrics validation.
  • Removed Invoice Amount metrics validation of AP Invoices and AR Transactions.
Additional job-specific group The Expense Manager job-specific group is available.
Updated job-specific groups These job-specific groups have additional data and duty roles:
  • Accounts Payable Manager
  • Accounts Payable Specialist
  • Accounts Payable Supervisor
  • Buyer
  • Procurement Manager
  • Category Manager
  • Procurement Contract Administrator
  • Purchase Analysis
Additional application roles These additional data and duty roles are available:
  • Procurement Inventory Organization Data Security
  • Procurement Requisition Business Unit Data Security
  • Employee Expense Analysis Duty
  • Procurement Purchase Order Analysis Duty
  • Procurement Purchase Agreement Analysis Duty
  • Procurement Purchase Receipts Analysis Duty
Updated application role The Accounts Payable Business Unit Data Security role supports the EXM functional area.
Deprecated fact tables These fact tables won't be populated and will be deprecated in future release:
  • DW_GL_BALANCE_F
  • DW_GL_JOURNAL_F
Data for the soon-to-be deprecated tables is available in these fact tables:
  • DW_GL_BALANCE_CF
  • DW_GL_JOURNAL_CF

See Implementing Oracle Fusion ERP Analytics.

Oracle Fusion HCM Analytics

Feature Description
Additional subject areas These subject areas have been added:
  • HCM - Talent Profile subject area provides insight into the number of seeded talent profile content types (competencies, work requirements, degrees, licenses and certifications, memberships and awards, and so on) of the workers. Additional counts about workers’ achievements, experiences, and background can be found in this folder. Job and position data can be extracted from this subject area to assess the workers’ performance to specific jobs or positions and whether they are a good skill set match. Key worker information found in the Talent Profile Subject Area helps line managers and HR business partners have insight into organizational skill strength and weakness, analyze skill gaps, and identify potential risk to the business. They can use the skill gap to drive employee development, succession planning, and recruiting needs.
  • HCM - Workforce Absence Management provides information on worker absences aggregate view & by calendar day wise. It also has information on worker absence balances , various balance transactions and ability to plot historical absence balance of a worker. Along with absences , it also provides view point of performance & absence approval/rejection rates of a worker.
  • HCM- Workforce Rewards- Workforce Compensation Provides information on workforce compensation plan , plan components & associated budgets.
Enhanced subject areas HCM-Workforce Core subject area is enhanced to allow the line managers to report on terminated workers within their managerial hierarchy.
Updated subject areas All subject areas have been updated as follows:
  • Enterprise calendar-related columns are added under Time Dimension.
  • Fiscal calendar columns are hidden.
Additional dimension Bargaining Unit dimension added to Common Dimension folder in all subject areas of HCM.
Updated Self Record context View Self Record context to show only “No” option in the list of values. The Self Record access is “Yes” by default for all the predefined job roles.
Additional job-specific group Compensation Manager job-specific group is available.
Additional application roles These additional data and duty roles are available:

Duty roles

  • Absence Management Analysis Duty
  • Absence Management Diversity Analysis Duty
  • Workforce Compensation Analysis Duty
  • Workforce Compensation Diversity Analysis Duty
  • Profile Management Analysis Duty
  • Profile Management Diversity Analysis Duty

Data roles

  • Compensation Worksheet Manager Data Security

See Implementing Oracle Fusion HCM Analytics.

Release 21.R2.P1 - May 2021

General

Feature Description
Republish your customizations Republish the user extensions, security configurations, and tagged steps of the Main branch if you’ve modified them after publishing them initially. See Republish Your Customizations.
Tag the Main branch's steps Tag the “Applied” steps in the Main branch as a snapshot at a given point in time. See Tag the Main Branch's Steps.
Use the enhanced functionality to promote your customizations You can:
  • Promote your customizations from a development to a production instance, from a production to a development instance, and from one production to another production instance.
  • Promote all customized KPIs or selected customized KPIs.
  • Promote all or selected roles and mappings in your customized security configurations.

See Promote Your Customizations to the Production Environment.

View options in the Console based on your permissions The tiles in the Console are based on the permissions associated with the system groups assigned to the users. See System Groups and System Roles.
Move your users to the author and consumer-related licensed groups You must move the required users to the author and consumer-related licensed groups by the next release. You can perform this action using the Add User button in the User tab, or Assign Users button in the Groups tab, or through the Mass Upload option in Oracle Identity Cloud Service. For the Mass Upload option, users must have the IDCS_Administrator group assigned to them. Currently, the Users tab on the Security page displays all the users in Oracle Identity Cloud Service which will be discontinued after the next release. After which, from the Users tab, you can access only the users assigned to any of the licensed groups. Decoupling of the Author and Consumer groups, and obsolete system roles from the predefined and custom groups will happen in the upcoming releases after the next release. See System Groups.

Release 21.R1.P5 - May 2021

General

Feature Description
View customizations in read-only mode in the production instance You can view the Semantic Model Extensions pages in the read-only mode in your production instance. This enables you to view the composition of customizations, audit history, and security configurations that you had made in your development instance.
Renaming support You can rename the following without impacting subsequent steps:
Terminate failed instances You can terminate instances that are in active or failed state. See Terminate Failed Instances.
Update notification email You can view and update the notification email address set for an instance on the instance details page. See Update the Notification Email.

Release 21.R1.P4 - March 2021

General

Feature Description
Disable and enable the disabled steps while extending the semantic model You can disable and enable the disabled steps in the main and customization branches in the development and production environments to troubleshoot issues in the branches. See Disable and Enable the Disabled Steps.
Use functional groups to combine data filters While configuring data security, Oracle Fusion Analytics Warehouse combines the data filters in the same functional group using the OR operator and combines the sets of data filters in different functional groups using the AND operator. See Configure Data Security.
Use the predefined object security step to configure object permissions Edit the predefined "Duty Security Step" to secure the objects such as subject areas and their elements with the predefined or custom-created duty roles. See Configure Object Permissions.

Release 21.R1.P3 - March 2021

What's New

General

Feature Description
Service administrators can view all data By default, service administrators have access to all data.
Use the author and consumer-related licensed system groups You can assign the following additional system groups to users and make use of the privileges of the associated system roles:
  • FAW Licensed ERP Authors
  • FAW Licensed ERP Consumers
  • FAW Licensed HCM Authors
  • FAW Licensed HCM Consumers
The author-related licensed system groups are mapped to the Author system role and the consumer-related licensed system groups are mapped to the Consumer system role. See System Groups and System Roles.

Note:

Currently, new licensed users with predefined job-specific groups get the Author role by default. You must add these users to the licensed system groups as the assignment of the Author role by default will no longer be available for the predefined job-specific groups from the next release of Oracle Fusion Analytics Warehouse. You can no longer map the system roles to custom groups as the system roles are no longer available in the user interface. The system roles are only available in the predefined mappings to the system groups. If you have a custom group mapped to those system roles, then the privileges associated with the system roles are still available. In a future release, the privileges associated with the system roles will be available only with the system groups and the system roles will be decoupled from the custom groups.
View Oracle Fusion Analytics Warehouse in 11 non-English languages Oracle Fusion Analytics Warehouse supports the following non-English languages:
  • Arabic
  • Chinese Simplified
  • Chinese Traditional
  • Dutch
  • French Canadian
  • French European
  • German
  • Italian
  • Japanese
  • Portuguese Brazilian
  • Spanish

When you set one of these languages in your browser settings, elements of Oracle Fusion Analytics Warehouse such as the user interface and auto-generated text are displayed in the selected language. Data visualization multi-language support will only be available in a future release.

You can specify the language in which you want the data to be extracted using the Analytics Language pipeline parameter. The languages that you can select in the Analytics Language parameter are based on the initialized Oracle Applications Cloud languages. Changes to this global parameter don't take effect immediately even after next refresh and may cause inconsistent results because the refresh brings in only the incremental data in the selected language. You must reset the warehouse for the language changes to be effective. See Set Up the Pipeline Parameters

Oracle Fusion ERP Analytics

Feature Description
Procurement Spend subject area Provides the ability to analyze total spending of an organization based on entities such as suppliers and items. It helps to identify potential cost savings and to assess compliance in the procurement operations.

You can use three packaged reports and one dashboard with the Procurement Spend subject area.
Attributes added to existing subject areas The following subject areas have these additional attributes:
  • GL Detail Transactions subject area: Journal Batch Identifier
  • AP Invoices subject area: Default Account Combination, Post SLA Indicator, Invoice Identifier, Installment Payment Status
  • AP Aging subject area: Default Account Combination, Post SLA Indicator, Invoice Identifier
  • AP Liabilities subject area: Default Account Combination, Invoice Identifier, Distribution Accounting Date
  • AP Payments subject area : Default Account Combination, Payment Document Identifier, Payment Distribution Type, Account Class, Payment Accounting Date, Payment Distribution Amount
  • AP Expenses subject area: Default Account Combination, Invoice Identifier, Account Class, Distribution Accounting Date
  • AP Holds subject area: Invoice Identifier
  • AR Receipts and Applications subject area: Account Override Indicator, Receipt Distribution Accounting Date
  • AR CM Applications subject area: Account Override Indicator, Credit Memo Application Accounting Date
  • AR Adjustments subject area: Account Override Indicator, Adjustment Date, Adjustment Accounting Date
  • AR Revenue subject area :UOM, Account Override Indicator, Transaction Accounting Date
Metrics added to existing subject areas The AP Payment subject area has these additional metrics:
  • Payment Distribution Amount
  • Discount Taken Exchange Loss(Gain) Amount
,
Updated subject areas These subject areas have been updated as follows:
  • Hide "Chart Of Account Name" attribute in the "GL Account" dimension folder in all the existing subject areas.
  • Renamed "Default Account Type Code" to "Post SLA Indicator" in the AP subject areas.
  • Hide "Adjustment Date" attribute in the AR Adjustments subject area.
  • Hide "UOM" attribute in the AR Revenue subject area.
  • Time anchor changed to Distribution Accounting Date in AP Liabilities subject area.
  • Account Payables Payment subject area displays all accounting distributions.
  • Account Payables and Account Receivable subject areas supports Business Unit as a common dimension.
Metrics added for data validation Five base metrics were added to the automated validations for base metrics between the Oracle Applications Cloud source and Fusion Analytics Warehouse. Additional attributes were added to the existing base metrics.
Enhanced set of KPIs The set of KPIs include 20 more Spend-related KPIs, 10 more Account Payables KPIs, and 28 more Account Receivable KPIs.

See Implementing Oracle Fusion ERP Analytics.

Oracle Fusion HCM Analytics

Feature Description
Additional subject areas These subject areas have been added:
  • HCM - Performance Management provides insight into the employee work performance assessed through performance appraisal.
  • HCM - Check-Ins provides the details of the key metrics related to employee engagement with their managers through check-ins.
  • HCM - Goals and Career Development provides insight into performance and development goals that employees create.
Enhanced subject areas These subject areas have been enhanced:
  • Added the "Country", "Ethnicity", and "Disability" dimensions in the HCM - Workforce Core subject area.
  • Added the "Implicit Headcount Gain and Loss" metrics in the HCM - Workforce Gains and Losses subject area.
  • Added the "Country" dimension and additional source-related and job application progression-related metrics in the HCM - Talent Acquisition subject area.

See Implementing Oracle Fusion HCM Analytics.

What's Fixed

For a list of defects fixed in Oracle Fusion ERP Analytics, see Doc ID 2760973.1

For a list of defects fixed in Oracle Fusion HCM Analytics, see Doc ID 2761020.1

Release 21.R1.P2 - March 2021

General

Feature Description
Use the enhanced Security functionality and the Security Extensibility feature You can:
  • Use the enhanced Security functionality to manage users, groups, application roles and data access. Additionally, you can view the security-related activities for audit purposes.
  • License the users to access Oracle Fusion Analytics Warehouse.
  • Use the Security Extensibility feature to secure access to objects and data with custom duty and data roles.
See Manage Users, Groups, Application Roles, and Data Access and Add Security Configurations.

Note:

You must authenticate the existing users of Oracle Fusion Analytics Warehouse by assigning system groups to them. You must complete this task by one release after the next release of Oracle Fusion Analytics Warehouse. If you've users who were authenticated by assigning them the Job role in Oracle Applications Cloud, then you must add such users to the system groups as soon as possible, otherwise users will lose their access to specific data in a future release.
Additional system groups - reserved for future functionality The following additional system groups are available:
  • FAW Licensed ERP Authors
  • FAW Licensed ERP Consumers
  • FAW Licensed HCM Authors
  • FAW Licensed HCM Consumers
However, these system groups are applicable for a future functionality. Even though you can assign them to the users currently, you can't make use of the associated privileges as these system groups aren't mapped to the Author and Consumer system roles respectively in this release. See System Groups and System Roles.
View Oracle Fusion Analytics Warehouse in the language that you set in your browser Oracle Fusion Analytics Warehouse supports several non-English languages, and certain elements such as the user interface and auto-generated text are displayed in those languages.
Change the columns you would like to pivot the detail data on and download the data validation details While validating the data that you loaded into your data warehouse, you can change the columns that you would like to pivot the detail data on. After validating the data, you can download the detail data showing the differences between the Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance to a CSV file. See Validate Your Data.
Secure objects and data with custom data and duty roles Add security configurations to secure the subject areas and data with custom application roles. See Add Security Configurations.
Add multiple canvases to a card You can link to a project or dashboard with multiple canvases so that they're all available in a KPI card. See Add Multiple Canvases to a Card.

Release 21.R1.P1 - February 2021

General

Feature Description
Use the system groups mapped to the system roles System groups are associated with system roles that provide a set of privileges to users. You must add the users to the corresponding system groups based on the tasks users perform in Oracle Fusion Analytics Warehouse.
If you had earlier assigned the "OAX Service Administrator", "OAX Functional Administrator", and "OAX Security Administrator" groups to your users, then perform the following steps:
  • Get a list of all the user members of the "OAX Service Administrator" group and add them to the "FAW Service Administrator" group. Remove the users from the "OAX Service Administrator" group and delete the "OAX Service Administrator" group that was manually created previously.
  • Get a list of all the user members of the "OAX Functional Administrator" group and add them to the "FAW Functional Administrator" group. Remove the users from the "OAX Functional Administrator" group and delete the "OAX Functional Administrator" group that was manually created previously.
  • Get a list of all the user members of the "OAX Security Administrator" group and add them to the "FAW Security Administrator" group. Remove the users from the "OAX Security Administrator" group and delete the "OAX Security Administrator" group that was manually created previously.
You must reassign the users to the applicable system groups including the "FAW Modeler" and "FAW Modeler Administrator" as soon as possible otherwise users will lose their access to Oracle Fusion Analytics Warehouse in a future release. See System Groups and System Roles.

Release 20.R3.P1 - January 2021

General

Feature Description
Diagrammatically create joins while adding a fact table Use the Diagram tab to specify the joins to link the fact table to the dimensions in the selected subject area. See Add a Fact Table.
Reload the source table columns while adding fact tables and dimensions, and while extending dimensions If any of the selected attributes have been removed or modified in the source table since the last refresh, then you can reload the source columns to view and used the latest. See Add a Fact Table, Add a Dimension, and Extend a Dimension.
Reapply a branch step Reapply the steps from the Branch details page without opening the steps. See Reapply a Branch Step.
System Groups - reserved for future functionality The following system groups specific to Oracle Fusion Analytics Warehouse are predefined in Oracle Identity Cloud Service while provisioning your Oracle Fusion Analytics Warehouse instance:
  • FAW Functional Administrator
  • FAW Security Administrator
  • FAW Modeler
  • FAW Modeler Administrator
  • FAW Service Administrator

These system groups provide users with a set of administration privileges. However, these system groups are applicable for future functionality and you don't need to take any action regarding them currently.

Release 20.R2.P2 - October 2020

Oracle Fusion ERP Analytics

Feature Description
Additional roles Support for the Account Payable Invoice Supervisor and Account Payable Payment Supervisor job roles that were recently added in Oracle Applications Cloud.
Updated roles The AP and AR job roles support the GL Account Analysis subject area.

See Implementing Oracle Fusion ERP Analytics.

Oracle Fusion HCM Analytics

Feature Description
Enhanced Talent Acquisition subject area Includes the metrics, dimensions, and KPIs related to job applications and offers.

See Implementing Oracle Fusion HCM Analytics.

Release 20.R2.P1 - September 2020

General

Feature Description
Provision with single sign-on Provisioning Oracle Fusion Analytics Warehouse with single sign-on enables you to synchronize users and roles in Oracle Applications Cloud with Oracle Identity Cloud Service and then enable these users to access Oracle Fusion Analytics Warehouse. See Set Up Provisioning with Single Sign-On.
Enable the service administrator to view data By default, the service administrator doesn't have access to data. To enable the service administrator to view data, you must assign functional roles to the service administrator and add security assignments to the user assigned the service administrator role. For example, to enable a user who's part of the service administrator group to view Accounts Payables (AP) data, assign the Accounts Payable Manager group (or another AP group) to the user. Additionally, assign security assignments in the AP security context of interest. See Create and Associate Users and Job Roles and Add Security Assignments to a User.
Use the additional roles to access the additional subject areas and data You can use the additional roles to access the additional subject areas and data in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics. See "New role" in Oracle Fusion ERP Analytics and "New roles" in Oracle Fusion HCM Analytics.
Use the updated roles to access the subject areas and data You can use the updated roles to access the subject areas and data in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics. See "Updated roles" in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics.
Chained upgrades from data model to content After you upgrade the data model, Oracle automatically applies the instance patch to upgrade the content. See Upgrade the Target Model.
The Data Enrichment process has been renamed as "Data Augmentation" and is available with enhanced functionality You can augment your reports with datasets created by extending an existing entity or group of facts, by adding an additional dimension in the source table, and by adding an additional fact in the source table. See Augment Your Data.
Use the enhanced Data Validation functionality You can view the metric values for the Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance in the Summary and Details tables. See Validate Your Data.
Add a column You can add derived columns to an existing subject area. See Add a Column.
Create a subject area You can create a subject area as a container and later add dimensions and facts to the subject area that you created area or create a subject area based on an existing one. See Create a Subject Area.
Modify a subject area You can modify a custom subject area. See Modify a Subject Area.
View changes in the customized KPIs For the KPI's that you customized, you can view the changes. See Edit a KPI.

Oracle Fusion ERP Analytics

Feature Description
Support STAT currency The GL Balances, GL Detailed Transactions, and GL Budgets subject areas support STAT currency.
Additional subject area The GL Account Analysis subject area provides a composite view of the GL account activity and the corresponding subledger transaction details across sources supported in Fusion ERP Analytics. It also helps to reconcile and drill down the GL balances to journals and the contributing subledger transactions.
Select multiple chart of accounts You can analyze balances, journals for ledgers, and subledger transactions for business units that are tagged to different chart of accounts on consolidated as well as standalone basis. You must select at least one chart of account while setting up the reporting parameters for the data pipeline process.
Attributes added to existing subject areas The following subject areas have these additional attributes:
  • GL Detail Transactions subject area: GL Accounting Date, Posted Date, Journal Creation Date, Journal Batch Description, Approval Status, Approved By, Posted Status, Created By – Header, and Created By – Line
  • AP subject areas: D-U-N-S Number
  • AP Invoices subject area: Liability Account Combination, Voucher Number, Routing Attribute, Invoice Accounting Status, Invoice Created By, Invoice Updated By, and Installment Hold Indicator
  • AP Aging subject area: Aging Date and Invoice Accounting Status
  • AP Liabilities subject area: Liability Account Combination, Account Override Indicator, Distribution Accounting Date, Invoice Created By, and Invoice Updated By
  • AP Payments subject area : Payment Created By and Account Override Indicator
  • AP Expenses subject area: Account Override Indicator, Distribution Validation Status, Distribution Reversal Indicator, Purchase Order Schedule Number, and Purchase Order Distribution Number
  • AP Holds subject area: Approval Status Name, Validation Status Name, Payables Source Name, Transaction Type Name, Accounting Allowed Indicator, and Manual Release Allowed Indicator
  • AR Transactions subject area: Receivables Account Combination, Transaction Document Number, Salesperson, Schedule Status, Transaction Creation Date, Transaction Update Date, and Transaction Created By
  • AR Receipts and Applications subject area: Receipt Document Number, Receipt Date, Customer Bank Name, Customer Bank Branch, Customer Bank Account Number, Receipt Distribution Account Combination, Account Class Code, Receipt History Status Code, Receipt Created By, Receipt Application Created By, and Application Type
  • AR CM Applications subject area: Credit Memo Application Account Combination, and Credit Memo Application Created By
  • AR Adjustments subject area: Adjustment Account Combination, Account Class Code, and Adjustment Created By Login Name
  • AR Aging subject area: Aging Date
  • AR Revenue subject area : Distributions Account Combination, Sold-to Customer, Sold To Customer Number, Salesperson, Sales Order Number (at line level), and Distribution Created By
Metrics added to existing subject areas The following subject areas have these additional metrics:
  • AP Invoices subject area: Total Transaction Amount and Total Transaction Count
  • AP Holds subject area: Invoice Lines on Hold Amount and Invoice Lines on Hold Release Amount
  • AR Receipts and Applications subject area: Receipt Distribution Amount, Receipt Refund Amount, Receipt Write-Off Amount, and Receipt to Receipt Application Amount
  • AR Adjustments subject area: Adjustments Distribution Amount
  • AR Revenue subject area: Quantity Billed and Unbilled Receivable Amount
Updated subject areas These subject areas have been updated as follows:
  • GL, AP and AR subject areas: Grouped individual GL Segments dimension into "GL Segments" dimension folder
  • GL Detail Transactions subject area:
    • Hide "GL Journal Date" attribute and add the additional date "GL Accounting Date" dimension
    • Hide "GL Posting Date" attribute and add the additional date "Posted Date" dimension
    • Rename existing attribute "Posted Status" to "Posted Status Code"
    • Rename existing attribute "Posted Status Name" to "Posted Status"
    • Rename existing metric "Transaction Amount" to "Net Amount"
  • AP Payments subject area:
    • Rename existing metric "Payments Count" to "Payments Document Count"
    • Rename existing metric "Total Payment Count" to "Total Paid Installments Count"
  • AR Transaction subject area:
    • Hide "Sales Order Number" attribute
    • Hide "Posted Date" attribute
  • AR Receipts and Applications subject area:
    • Change the time anchoring from existing "Receipt Application Date" to "Receipt Date"
    • Hide "Receipt Date" attribute and add the date "Receipt Date" dimension
  • AR Revenue subject area: Hide "Customer Sold To Name" attribute, add the "Sold-to Customer" dimension, hide "Sales Order Number" attribute, hide "Posted Date" attribute, rename existing attribute "Customer Sold To Name" to "Sold To Customer" attribute
  • Rename existing KPIs: Rename existing KPI "Days Payables Outstanding" to "Days Payables Outstanding (GL)", rename existing KPI "AP Turnover Rate" to "AP Turnover (GL)"
  • AR Receipts and Applications subject area: Enhanced to support all accounting distributions for Standard Receipts including Receipt to Receipt applications and activities such as Write Offs, Refunds, and Chargebacks
View tool tip for metrics Tool tips are available for all metrics with user-friendly descriptions for all the subject areas.
Additional role The General Ledger Account Analysis Duty role controls presentation catalog access to GL Account Analysis subject area. See Duty Roles.
Updated roles These job roles have additional data and duty roles:
  • Financial Analyst
  • General Accountant
  • General Accounting Manager

See Job Roles

See Implementing Oracle Fusion ERP Analytics.

Oracle Fusion HCM Analytics

Feature Description
Descriptive Flex Field as dimension or attributes in the existing subject areas The descriptive flex fields related to various dimensions like person names, assignments, job, department, position, work relationship, hr actions and reasons are enabled in the global hcm subject areas.
Additional subject areas HCM - Workforce Gains & Losses subject area - analyzes the headcount movement, hires, reorganizations, and terminations.

HCM - Talent Acquisition subject area - provides a 360-degree view of the hiring process and recruiting insights.
Enhanced Workforce Core subject area Additional metrics and dimensions in the existing Workforce Core subject area.
Set up custom data security Support for custom data security using the ready-to-use security contexts.
Compute the headcount gain or losses based on the reorganization factor Specify reasons for reorganization to compute the headcount gain or losses based on the reorganization factor.
Additional roles These additional roles are available:
  • Duty roles:
    • Workforce Gains and Losses Transaction Analysis Duty
    • Workforce Core Diversity Analysis Duty
    • Workforce Gains and Losses Diversity Transaction Analysis Duty
    • Recruitment Analysis Duty Role

    See Duty Roles

  • Data roles:
    • FAW View All Data Role
    • FAW HCM Legal Employer Data Role
    • FAW HCM Department Data Role
    • FAW HCM Business Unit Data Role
    • Recruitment Job Requisition Data Security
    • Recruitment Job Requisition View All Data Security

    Data Roles

  • Job roles:
    • Human Resource Specialist
    • Human Resource Manager
    • Recruiter
    • Recruiting Manager
    • Hiring Manager

    See Job Roles
Updated roles These job roles have an additional duty role:
  • Human Resource Analyst
  • Line Manager

See Job Roles

See Implementing Oracle Fusion HCM Analytics.

Release 4.0 - July 2020

General

Feature Description
Experience Oracle Fusion Analytics Warehouse using the product trials Request for an Oracle Fusion Analytics Warehouse trial and use it to analyze your Oracle Applications Cloud data. See Place and Activate the Order for Oracle Analytics for Applications and Create an Oracle Analytics for Applications Trial Instance.
Enable Oracle to manage your resources without your active intervention Add an Oracle Cloud Infrastructure Identity and Access Management policy to enable Oracle to manage your resources without your active intervention. See Add an Oracle Cloud Infrastructure Identity and Access Management Policy.
Add a dimension Add a custom dimension table to an existing subject area and joins to a fact table. See Add a Dimension.
Add a hierarchy Add a hierarchy to a dimension table in an existing subject area. See Add a Hierarchy.
Add session variables Add a custom session variable that you can include in an analysis. See Add Session Variables.

Release 3.1 - May 2020

General

Feature Description
Validate your data Validate the data after loading the source data in to your data warehouse. See Validate Your Data.
Enrich your data You can supplement your reports by using datasets that you create with specific columns from various view objects (VOs) from the Oracle Applications Cloud data sources. See Enrich Your Data.
Add a fact table Add a fact table to an existing subject area. See Add a Fact Table.
Reorganize subject areas Reorganize the ready-to-use subject areas to create a subject area. See Reorganize Subject Areas.
Create email notifications for KPIs Enable email notifications for KPIs so that you know when the status changes. See Orientation Configure and Use Notifcations.
Customize KPIs Customize Oracle-provided KPIs or create a copy of a KPI to customize. See Customize a KPI.

Oracle Analytics for Enterprise Resource Planning

Feature Description
Reporting Currency Ledgers Oracle Analytics for Enterprise Resource Planning supports Reporting Currency with Balance type in GL Balance Sheet and GL Profitability subject areas.
Document Currency Oracle Analytics for Enterprise Resource Planning supports all metrics in document currency in the General Ledger, Accounts Payables, and Accounts Receivables subject areas.
Additional subject area The AR Revenue subject area enables you to analyze revenue. This subject area provides details for the key metrics related to revenue sourced from AR transaction distribution and revenue recognition. You can analyze these metrics by Transaction Details, Business Units, Customer Accounts, and CoA Segments.
Enhanced subject areas These subject areas have been enhanced:
  • AP Balances subject area is merged with AP Aging subject area to work based on Invoice Remaining Amount logic in AP Installments. This subject area supports historical reporting of payables invoice aging. Historic aging snapshots for 24 months prior to the current date are available.
  • AR Balances subject area is merged with AR Aging subject area to work based on Invoice Remaining Amount logic in AR Schedules. This subject area supports historical reporting of receivables invoice aging. Historic aging snapshots for 24 months prior to the current date are available.
  • The Accounts Payables and Accounts Receivables subject areas show accounts of post subledger accounting generated based on the subledger accounting rules instead of the default accounts generated in the respective subledgers, including support for manual account override.
Attributes added to existing subject areas These subject areas have additional attributes:
  • Attributes added to the General Ledger subject area are Journal Reversal Status and Journal Created By for Headers and Lines.
  • Attributes added to the Accounts Payables subject areas are Invoice Group, Discount Due Date, Supplier Type, Installment Number, Invoice Updated By, Invoice Creation Date, Invoice Accounting Date, Expense Distribution Accounting Date, Payment Accounting Date, and Hold Indicator.
  • Attributes added to the Accounts Receivables subject areas are AR Transaction Accounting Date, Receipt Accounting Date, Receipt Application Accounting Date, Credit Memo Application Accounting Date, and Adjustment Accounting Date.
Metrics added to the Accounts Payables subject areas These metrics have been added to the Accounts Payables subject areas:
  • AP Payments Exchange Loss (Gain) Amount
  • Header Holds count
  • Line Holds count
Descriptive Flex Field as Dimension/Attributes in existing subject areas You can enable the Descriptive Flex Field (DFF) in the General Ledger, Accounts Payables, and Accounts Receivables subject areas such as Journal Batch, AP Invoice Headers and Lines, AR Transactions and Lines, AR Receipts, Supplier, and Customer.

See Implementing Oracle Analytics for Enterprise Resource Planning.

Oracle Analytics for Human Capital Management

Feature Description
Potential Band dimension The Potential Band dimension provides a grouping of potential ratings under various headers. For example, High, Medium, and Low. You can configure the rating ranges under these bands.
KPIs added for Human Capital Management These KPIs have been added for Human Capital Management:
  • Top Talent Ratio KPI provides the ratio of workers with high performance and potential values against the total workforce.
  • Low Talent Ratio KPI provides the ratio of workers with low performance and potential values against the total workforce.
  • Termination by High Performer KPI provides the count of terminations that are rated high in performance.
  • Terminations by Top Talent KPI provides the count of terminations that are rated high in performance and potential.
  • Retention by Talent KPI provides the retention percentage by each talent 9-box based on performance and potential.
  • Turnover by High Performer KPI provides the ratio of high performer terminations against the total headcount.
  • Turnover by Top Talent KPI provides the ratio of high performer and potential terminations against the total headcount.
Talent Retention % card in the Workforce Management deck This card provides the percentage of talent retained by each of the boxes in the performance versus the potential 9-box.
Top Talent Retention detailed page The detailed page provides an analysis of the performance and potential ratings of the workers. It provides the details of the workers that have been identified as top talent in the organization and are retained. A 9-box analysis of the employee retention by their talent ratings is available through this page.

See Implementing Oracle Analytics for Human Capital Management.

Release 3.0 - March 2020

Feature Description
Support for Oracle Analytics Cloud available on Oracle Cloud Infrastructure Gen 2. When you subscribe to Oracle Fusion Analytics Warehouse, you get Oracle Analytics Cloud on Oracle Cloud Infrastructure Gen 2 in North America (Ashburn) and EMEA (London) along with it. The Oracle Analytics Cloud instance created inline is based on an included capacity model similar to Oracle Autonomous Data Warehouse. In this model, you won't be billed for the included capacity. If you choose to scale your Oracle Analytics Cloud instance, then you would be charged the difference between the scaled value and the included capacity. See About Oracle Analytics for Applications.
Oracle Analytics for Human Capital Management Oracle Analytics for Human Capital Management allows you to make data-driven decisions and to test the effectiveness of Human Resources policies. You can analyze data to gain insights that you can act on and to gather information to meet specific requirements. For example, you can answer questions such as "What is the voluntary turnover rate" and "What is the expected turnover rate for this quarter based on previous quarters?". See About Reporting Configuration for Human Capital Management.

Recent Product Updates

Here’s an overview of the regions where Oracle Fusion Analytics Warehouse is available.

October 2021

Update Description
Available in Phoenix

Oracle Fusion Analytics Warehouse rolls out to the Phoenix region.

See Region Availability.

July 2021

Update Description
Available in Jeddah

Oracle Fusion Analytics Warehouse rolls out to the Jeddah region.

See Region Availability.

June 2021

Update Description
Available in Toronto

Oracle Fusion Analytics Warehouse rolls out to the Toronto region.

See Region Availability.

May 2021

Update Description
Available in Sao Paulo

Oracle Fusion Analytics Warehouse rolls out to the Sao Paulo region.

See Region Availability.

April 2021

Update Description
Available in Dubai

Oracle Fusion Analytics Warehouse rolls out to the Dubai region.

See Region Availability.

February 2021

Update Description
Available in Sydney

Oracle Fusion Analytics Warehouse rolls out to the Sydney region.

See Region Availability.

November 2020

Update Description
Available in Frankfurt

Oracle Fusion Analytics Warehouse rolls out to the Frankfurt region.

See Region Availability.

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 customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.