Subject Areas
This section provides information about Oracle Fusion SCM Analytics subject areas and how to use them
Overview
This section details subject area information for Supply Chain Management data using Oracle Fusion SCM Analytics.
Download this ZIP file that contains available subject areas that apply to the current version of Oracle Fusion SCM Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 25R4_Fusion_SCM_Analytics_SubjectAreas.html.
These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:
- Description of the subject area.
- Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.
- Job-specific groups and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.
- Primary navigation to the work area that is represented by the subject area.
- Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.
- The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.
- Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.
Note:
Job roles are the same as job-specific groups.Offerings and Functional Areas
This table shows the offerings in Fusion SCM Analytics.
To learn more about subject areas, see Subject Areas.
| Offering | Functional Area Name | Dependency | Associated Subject Areas |
|---|---|---|---|
| Procurement Analytics | Procurement Spend | NA | Procurement - Spend |
| Procurement Analytics | Purchasing | NA | Procurement - Agreements, Procurement - Purchase Orders, Procurement - Receipts, Procurement - Requisitions |
| Procurement Analytics | SCM Procurement Contracts (Preview) | NA | Enterprise Contracts - Contracts (Preview) |
| Procurement Analytics | Procurement (SCM) Receipt Accounting (Preview) | NA | Procurement - Receipt Accounting (Preview), Procurement - Accrual Balances at Period End (Preview), Procurement - Accrual Balances at Receipt (Preview) |
| Procurement Analytics | Spend Classification (Preview) | Purchasing + Procurement Spend | Procurement - Purchase Orders, Procurement - Requisitions, Procurement - Spend |
| Procurement Analytics | Purchasing History (Preview) | Purchasing | Procurement - Agreement Change Orders (Preview), Procurement - Purchase Order Change Orders (Preview) |
| Product Management Analytics | Item Management (Preview) | NA | Product Management - Item Revisions (Preview) |
| Supply Chain Management Analytics | Cost Accounting | NA | SCM - Cost Accounting |
| Supply Chain Management Analytics | Cost Management | NA | SCM - Inventory Valuations, SCM - Item Cost, SCM - COGS and Gross Margin |
| Supply Chain Management Analytics | Current Inventory Balances (Opt-in Generally Available) | NA | SCM - Inventory Balances (Opt-in Generally Available) |
| Supply Chain Management Analytics | Draft Sales Order Management (Preview) | Order Management | SCM - Draft Sales Orders (Preview), SCM - Draft Sales Orders Holds (Preview) |
| Supply Chain Management Analytics | Inventory Aging (Preview) | Current Inventory Balances + Inventory Organisation Item Costs | SCM - Inventory Aging (Preview) |
| Supply Chain Management Analytics | Inventory Balances | NA | SCM - Inventory Balances |
| Supply Chain Management Analytics | Inventory FSN Analysis (Preview) | Inventory Turns | SCM - Inventory Turns (Preview) |
| Supply Chain Management Analytics | Inventory Management | NA | SCM - Inventory Receipts (Planned Deprecation), SCM - Inventory Transactions, SCM - Picking and Shipping, SCM - Transfer Orders |
| Supply Chain Management Analytics | Inventory Organisation Item Costs (Preview) | Cost Management | NA |
| Supply Chain Management Analytics | Inventory Receipts | Purchasing + Inventory Management | SCM - Inventory Receipts |
| Supply Chain Management Analytics | Inventory Turns (Preview) | Inventory Balances + Inventory Organisation Item Costs | SCM - Inventory Turns (Preview) |
| Supply Chain Management Analytics | Manufacturing (Opt-in Generally Available) | NA | Below are Opt-in Generally Available Subject Areas: SCM - Manufacturing Work Orders, SCM - Manufacturing Operation Transactions, SCM - Manufacturing Resources, SCM - Manufacturing Materials, SCM - Maintenance Work Orders, SCM - Maintenance Operation Transactions, SCM - Maintenance Resources, SCM - Maintenance Materials |
| Supply Chain Management Analytics | Order Management | NA | SCM - Sales Orders, SCM - Sales Orders Holds |
| Supply Chain Management Analytics | Projected COGS and Gross Margin (Preview) | Inventory Organisation Item Costs | SCM - Sales Orders |
| Supply Chain Management Analytics | Shipping Costs (Preview) | Inventory Management | SCM - Picking and Shipping |
| Supply Chain Management Analytics | Work Order Cost (Preview) | NA | SCM - Work Order Costing (Preview) |
| Supply Chain Management Analytics | Planning Analytics (Preview) | Purchasing + Manufacturing + Order Management | Planning Analytics Dynamic Subject Areas (Preview) |
| Sustainability Analytics | Sustainability (Preview) | NA | Sustainability - Activities (Preview) |
Data Validation
Description
As a functional administrator, you can validate a library of metrics between your instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of . You can validate the data after loading the source data in to your data warehouse. You can schedule the validation of your data using the prebuilt validation sets or custom validation sets that you create. You can create a validation set and define the subject area, metrics, and columns that you want to validate and schedule the validation frequency and date. You see the validation sets that you create under Custom Validation Sets in the Scheduled Validation tab. Based on the schedule and the validation set, validates the data and stores the details in the Data Validation workbook available in the Common folder in Oracle Analytics Cloud. Use the report tabs such as Validate data for ERP Analytics and Validate data for HCM Analytics available in this workbook to view the data validation details.
Business Questions
This subject area can answer the following business questions:
- Did my data get loaded into Oracle Autonomous Data Warehouse accurately?
- Can I schedule a regular data validation on a periodic basis?
- If there is a variance between my Oracle Transactional Business Intelligence source and destination data, then how can I pinpoint which data is different?
- Are there built-in metrics for this data validation?
- Can I create my own (custom) metrics for specific data to validate?
Duty Roles
The System Administration duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Data Validation tile under Application Administration on the Console
Folder: /Shared Folders/Common/Data Validation
Special Considerations
None.
Security Assignment
Description
Using the Security Assignment subject area, you can create reports about the current security assignments. These reports enable you to track the security contexts and the users who have access to the security contexts.
Business Questions
This subject area can answer the following business questions:
- What is the total number of security contexts?
- What is the number of users by security context?
- Which user is assigned to which security context and when was the assignment done?
Duty Roles
The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Security Assignment
Workbook: Security Audit
Special Considerations
None.
Security Audit History
This section is applicable for CX Subscription Management Analytics only.
Description
Using the data in the Security Audit History subject area, you can create reports to track assignment of users to groups, groups to roles, and security context members to users.
Business Questions
This subject area can answer the following business questions:
- When was a group created?
- When was a role created?
- When was a user assigned to or removed from a group?
- When was a user assigned to or removed from a role?
- When was a user assigned to or removed from a security context?
Duty Roles
The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Security Audit History
Workbook: Security Audit
Special Considerations
None.
Usage Tracking
Description
Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In you can track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that you can use in a variety of ways such as reports optimization, user session strategies, or plan usage by users, and departments based on the resources that they consume. When reviewing the business metrics, it is important to keep the usability considerations in mind including trends, slice-and-dice, and drilldowns. Where applicable, benchmark information showcasing performance with the peer group is available. Companies typically set strategic quarterly goals in terms of key metrics; where applicable, the business metrics show progress towards such goals.
- While creating new custom content adhering to the recommended practices.
- When you want to provide additional data points for the prebuilt reports while reporting performance problems and want to add metrics such as row counts, compilation time, and response times.
Business Questions
This subject area can answer the following business questions:
- What are the average queries ran by the user by month?
- How many number of user sessions were created per month?
- How many distinct queries were run per month?
- How many distinct users used the system?
- How many distinct users used the system in a week?
- What are the average queries ran by the user in a week?
- How many logical queries ran by the top users?
- What are the top 10 logical and physical queries by execution time?
- Which dashboards and visualizations are the slowest performing?
Duty Roles
The Usage Tracking Analysis Duty role secures access to this subject area. See .
Primary Navigation
Folder: /Shared Folders/Common/Usage Tracking
Workbook: Usage Tracking
Special Considerations
None.
Warehouse Refresh Statistics
Description
The Warehouse Refresh Statistics subject area provides valuable information on pipeline activity and performance. You can use this subject area to create analytics on data refreshes, pipeline jobs, job failures, and details on rejected records. Together with data validation, this subject area helps reconcile data between the Oracle Fusion Cloud Applications source module and , and improve data quality over time.
Business Questions
This subject area can answer the following business questions:
- When was the warehouse last refreshed, by each module?
- Which modules have high percentage of rejected records?
- What are the specific records that have been rejected for a certain module?
- What errors did the pipeline encounter, by specific jobs?
- Which jobs fail most frequently?
- What are the cascading effects, for example what other related records also fail due to a certain failure of a job?
Duty Roles
The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See .
Primary Navigation
Folder: /Shared Folders/Common/Warehouse Refresh Statistics
Workbook: Warehouse Refresh Statistics
Special Considerations
None.