Subject Areas

8 Subject Areas

Subject Areas

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

Functional Area Name	Dependency	Associated Subject Areas	Initial Release
Cost Accounting	NA	SCM - Cost Accounting (Preview)	22R1
Cost Management	NA	SCM - Inventory Valuations, SCM - Item Cost, SCM - COGS and Gross Margin	21R2
Current Inventory Balances	NA	SCM - Inventory Balances	22R4
Draft Sales Order Management (Preview)	Order Management	SCM - Draft Sales Orders (Preview), SCM - Draft Sales Orders Holds (Preview)	24R2
Inventory Aging (Preview)	Current Inventory Balances + Inventory Organisation Item Costs	SCM - Inventory Aging (Preview)	23R4
Inventory Balances	NA	SCM - Inventory Balances	20R2
Inventory FSN Analysis (Preview)	Inventory Turns	SCM - Inventory Turns (Preview)	23R4
Inventory Management	NA	SCM - Inventory Receipts, SCM - Inventory Transactions, SCM - Picking and Shipping, SCM - Transfer Orders	20R2
Inventory Organisation Item Costs (Preview)	Cost Management		23R2
Inventory Turns (Preview)	Inventory Balances + Inventory Organisation Item Costs	SCM - Inventory Turns (Preview)	23R4
Manufacturing (Preview)	NA	SCM - Manufacturing Work Orders (Preview), SCM - Manufacturing Operation Transactions (Preview), SCM - Manufacturing Resources (Preview), SCM - Manufacturing Materials (Preview)	23R3
Order Management	NA	SCM - Sales Orders, SCM - Sales Orders Holds	20R2
Procurement Spend	NA	Procurement - Spend	20R4
Projected COGS and Gross Margin (Preview)	Inventory Organisation Item Costs	SCM - Sales Orders	23R2
Purchasing	NA	Procurement - Agreements, Procurement - Purchase Orders, Procurement - Receipts, Procurement - Requisitions	21R4
Receiving (Preview)	Purchasing + Inventory Management	SCM - Inventory Receipts	23R1
Sales Order Fulfillment Prediction	Order Management	SCM - Sales Orders	20R1
SCM Primary UOM Conversion	NA	All Relevant SCM Subject Areas	21R3
SCM Procurement Contracts	NA	Enterprise Contracts - Contracts (Preview)	23R4
SCM Receipt Accounting (Preview)	NA	Procurement - Receipt Accounting (Preview), Procurement - Accrual Balances at Period End (Preview), Procurement - Accrual Balances at Receipt (Preview)	23R4, 24R2
Spend Classification (Preview)	Purchasing + Procurement Spend	Procurement - Purchase Orders, Procurement - Requisitions, Procurement - Spend	23R2

Data Validation

Description

As a functional administrator, you can validate a library of metrics between your Oracle Fusion Data Intelligence instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Data Intelligence. 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, Oracle Fusion Data Intelligence 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 Oracle Fusion Data Intelligence 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 Oracle Fusion Data Intelligence 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.

This subject area includes details of logical queries that provide insights on the types of queries generated and their performance. Along with it, the Common - Usage Tracking - Physical Query subject area provides details of physical queries sent to the database. These details can help you understand query execution plans in Autonomous Data Warehouse to identify areas of improvement in report creation. Both subject areas have the Logical query folder with a common set of attributes, that you can use to join a logical or semantic query to its physical database queries. Together, they provide valuable insights to track performance of the Oracle Analytics platform and help you design reports and visualizations that can perform optimally.

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 Common Duty Roles.

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 Oracle Fusion Data Intelligence, 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 Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Warehouse Refresh Statistics

Workbook: Warehouse Refresh Statistics

Special Considerations

None.

Business Questions

Overview

For each business question in this section, click the links for more detailed information about the subject areas, job-specific groups, and duty roles associated with the business question.

Download this ZIP file that contains available business questions 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 24R2_Fusion_SCM_Analytics_BusinessQuestions.html.

Note:

Job roles are the same as job-specific groups.

Job-Specific Groups

Overview

This section provides job-specific groups that can be used to secure access to the subject area and analyses.

Note:

Job roles are the same as job-specific groups.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Functional Area
ORA_AP_ACCOUNTS_PAYABLE_MANAGER_JOB	Accounts Payable Manager	Accounts Payable Manager Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement
ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB	Accounts Payable Specialist	Accounts Payable Specialist Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement
ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB	Accounts Payable Supervisor	Accounts Payable Supervisor Job Group	OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement
ORA_CMR_RECEIPT_ACCOUNTING_DISCRETIONARY	Receipt Accounting	Receipt Accounting Job Group	OA4F_SCM_CMR_BUSINESS_UNIT_DATA OA4F_CMR_RECEIPT_ACCOUNTING_DUTY	SCM Receipt Accounting
ORA_CST_COST_ACCOUNTANT_JOB	Cost Accountant	Cost Accountant Job Group	OA4F_SCM_CST_COSTING_ORG_DATA OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY OA4F_SCM_CST_ITEM_COST_ANALYSIS_DUTY OA4F_SCM_CST_COGS_AND_GROSSMARGIN_ANALYSIS_DUTY OA4F_SCM_CST_COST_ACCOUNTING_ANALYSIS_DUTY OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_CONTENT_DUTY OA4F_SCM_CST_ITEM_COST_ANALYSIS_CONTENT_DUTY OA4F_SCM_CST_COGS_AND_GROSSMARGIN_ANALYSIS_CONTENT_DUTY	Cost Management
ORA_DOO_ORDER_ADMINISTRATOR_JOB	Order Administrator	Order Administrator Job Group	OA4F_SCM_OM_BUSINESS_UNIT_DATA OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY OA4F_SCM_OM_SALES_ORDER_ANALYSIS_CONTENT_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_CONTENT_DUTY	Order Management
ORA_DOO_ORDER_ADMINISTRATOR_JOB	Order Administrator	Order Administrator Job Group	OA4F_SCM_OM_BUSINESS_UNIT_DATA OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY	Draft Sales Order Management
ORA_DOO_ORDER_MANAGER_JOB	Order Manager	Order Manager Job Group	OA4F_SCM_OM_BUSINESS_UNIT_DATA OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY OA4F_SCM_OM_SALES_ORDER_ANALYSIS_CONTENT_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_CONTENT_DUTY	Order Management
ORA_DOO_ORDER_MANAGER_JOB	Order Manager	Order Manager Job Group	OA4F_SCM_OM_BUSINESS_UNIT_DATA OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY	Draft Sales Order Management
ORA_INV_INVENTORY_MANAGER_JOB	Inventory Manager	Inventory Manager Job Group	OA4F_SCM_INV_BUSINESS_UNIT_DATA OA4F_SCM_INV_INVENTORY_ORG_DATA OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY OA4F_SCM_INV_PICKING_AND_SHIPPING_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TRANSFER_ORDER_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY OA4F_INV_OF_PICKING_SHIPPING_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_AGING_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TURNS_ANALYSIS_DUTY OA4F_SCM_INV_CURRENT_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY	Inventory
ORA_INV_WAREHOUSE_MANAGER_JOB	Warehouse Manager	Warehouse Manager Job Group	OA4F_SCM_INV_BUSINESS_UNIT_DATA OA4F_SCM_INV_INVENTORY_ORG_DATA OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY OA4F_SCM_INV_PICKING_AND_SHIPPING_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TRANSFER_ORDER_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_INV_OF_PICKING_SHIPPING_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_SCM_INV_INVENTORY_AGING_ANALYSIS_DUTY OA4F_SCM_INV_INVENTORY_TURNS_ANALYSIS_DUTY OA4F_SCM_INV_CURRENT_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY	Inventory, Procurement
ORA_OKC_ENTERPRISE_CONTRACT_ADMINISTRATOR_JOB	Enterprise Contract Administrator	Enterprise Contract Administrator Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_ENTERPRISE_CONTRACT_MANAGER_JOB	Enterprise Contract Manager	Enterprise Contract Manager Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_ENTERPRISE_CONTRACT_TEAM_MEMBER_ABSTRACT	Enterprise Contract Team Member (Abstract Role)	Enterprise Contract Team Member (Abstract Role) Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_ADMINISTRATOR_JOB	Supplier Contract Administrator	Supplier Contract Administrator Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_MANAGER_JOB	Supplier Contract Manager	Supplier Contract Manager Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_OKC_SUPPLIER_CONTRACT_TEAM_MEMBER_ABSTRACT	Supplier Contract Team Member (Abstract Role)	Supplier Contract Team Member (Abstract Role) Job Group	OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts
ORA_PO_BUYER_JOB	Buyer	Buyer Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB	Procurement Contract Administrator	Procurement Contract Administrator Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PROCUREMENT_MANAGER_JOB	Procurement Manager	Procurement Manager Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement
ORA_PO_PURCHASE_ANALYSIS_ABSTRACT	Purchase Analysis	Purchase Analysis Job Group	OA4F_PROC_REQ_BUSINESS_UNIT_DATA OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Inventory
ORA_PON_CATEGORY_MANAGER_JOB	Category Manager	Category Manager Job Group	OA4F_PROC_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY NEXUS_BASE_OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement
ORA_WIE_PRODUCTION_OPERATOR_JOB	Production Operator	Has Author privileges	OA4F_SCM_MFG_MANUFACTURING_ORG_DATA OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_DUTY OA4F_SCM_MFG_WO_OPERATION_TRANSACTION_ANALYSIS_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_DUTY OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_CONTENT_DUTY FAW_SCM_Author	Manufacturing
ORA_WIE_PRODUCTION_SUPERVISOR_JOB	Production Supervisor	Has Author privileges	OA4F_SCM_MFG_MANUFACTURING_ORG_DATA OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_DUTY OA4F_SCM_MFG_WO_OPERATION_TRANSACTION_ANALYSIS_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_DUTY OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_CONTENT_DUTYFAW_SCM_Author	Manufacturing
ORA_WIS_MANUFACTURING_ENGINEER_JOB	Manufacturing Engineer	Has Author privileges	OA4F_SCM_MFG_MANUFACTURING_ORG_DATA OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_DUTY OA4F_SCM_MFG_WO_OPERATION_TRANSACTION_ANALYSIS_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_DUTY OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_CONTENT_DUTY OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_CONTENT_DUTY FAW_SCM_Author	Manufacturing

Common Job-Specific Groups

The common job-specific groups are applicable across the analytics applications that are part of Oracle Fusion Data Intelligence such as Oracle Fusion HCM Analytics and Oracle Fusion ERP Analytics.

Job-Specific Group Code	Job-Specific Group Name	Description	Associated Application Roles	Associated Application Role Names	Functional Area
ORA_FND_INTEGRATION_SPECIALIST_JOB	Integration Specialist	Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.	Author OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Not applicable	Common

Job-Specific Group Code

Job-Specific Group Name

Description

Associated Application Roles

Associated Application Role Names

Functional Area

ORA_FND_INTEGRATION_SPECIALIST_JOB

Integration Specialist

Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.

Author

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Not applicable

Common

Data Roles

Overview

This section provides data roles that can be used to secure access to the subject area.

Data Role Code	Data Role Name	Description	Functional Area
OA4F_FIN_AP_BUSINESS_UNIT_DATA	Accounts Payable Business Unit Data Security	Data security role to access accounts payable business unit-based data.	Procurement
OA4F_OKC_CONTRACT_BUSINESS_UNIT_DATA	Contract Business Unit Data Security	Data security role to access contracts business unit-based data.	Enterprise Contracts
OA4F_PROC_BUSINESS_UNIT_DATA	Procurement Business Unit Data Security	Data security role to access procurement business unit-based data.	Procurement
OA4F_PROC_INV_ORG_DATA	Procurement Inventory Organization Data Security	Data security role to access Receipts subject area basis the receiving organization.	Procurement
OA4F_PROC_REQ_BUSINESS_UNIT_DATA	Procurement Requisition Business Unit Data Security	Data security role to access procurement Requisition business unit-based data.	Inventory, Procurement
OA4F_SCM_CMR_BUSINESS_UNIT_DATA	Profit Center Business Unit Data Security for Receipt Accounting Business Function	Data security role to access Receipt Accounting business unit-based data.	SCM Receipt Accounting
OA4F_SCM_CST_COSTING_ORG_DATA	Supply Chain Costing Organization Data Security	Data security role to access supply chain costing organization-based data.	Cost Management
OA4F_SCM_INV_BUSINESS_UNIT_DATA	Supply Chain Business Unit Data Security for Materials Management Business Function	Data security role to access supply chain inventory business unit-based data.	Inventory
OA4F_SCM_INV_INVENTORY_ORG_DATA	Supply Chain Inventory Organization Data Security	Data security role to access supply chain inventory organization-based data.	Inventory
OA4F_SCM_MFG_MANUFACTURING_ORG_DATA	Supply Chain Manufacturing Organization Data Security	Data security role to access supply chain manufacturing organization based data.	Manufacturing
OA4F_SCM_OM_BUSINESS_UNIT_DATA	Supply Chain Business Unit Data Security for Sales Business function	Data security role to access supply chain order management business unit-based data.	Order Management
OA4F_SCM_OM_BUSINESS_UNIT_DATA	Supply Chain Business Unit Data Security for Sales Business function	Data security role to access supply chain order management business unit-based data.	Draft Sales Order Management

Duty Roles

Overview

This section provides subject area and content-related duty roles that you can use to secure access to the subject areas and specific content. For each duty role in this section, links are provided for detailed information about the job-specific groups, subject areas, and business questions associated with the duty role.

Duty Role Code	Duty Role Name	Duty Role Description	Functional Area	Gets access to Subject Area Display Name OR Associated Role
NEXUS_BASE_OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Nexus Base Procurement Spend Analysis Content Duty	Nexus Base Controls presentation catalog access to DV projects built against the Procurement - Spend subject area.	Procurement	Procurement - Spend
OA4F_CMR_RECEIPT_ACCOUNTING_DUTY	Receipt Accounting Duty	Controls presentation catalog access to Receipt Accounting subject area.	Receipt Accounting	Procurement - Receipt Accounting(Preview), Procurement - Accrual Balances at Period End (Preview), Procurement - Accrual Balances at Period End (Preview)
OA4F_INV_OF_PICKING_SHIPPING_ANALYSIS_CONTENT_DUTY	Picking and Shipping Analysis Content Duty	Controls presentation catalog access to WorkBooks projects for the SCM - Picking and Shipping subject area.	Inventory	SCM - Picking and Shipping
OA4F_OKC_ENTERPRISE_CONTRACTS_ANALYSIS_DUTY	Enterprise Contracts Analysis Duty	Controls presentation catalog access to Enterprise Contracts subject area.	Enterprise Contracts	Enterprise Contracts - Contracts (Preview)
OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY	Procurement Purchase Agreement Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Agreements subject area.	Procurement	Procurement - Agreements
OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY	Procurement Purchase Agreement Analysis Duty	Controls presentation catalog access to Procurement Purchase Agreement subject area.	Procurement	Procurement - Agreements
OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY	Procurement Purchase Order Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Purchase Orders subject area.	Procurement	Procurement - Purchase Orders
OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY	Procurement Purchase Order Analysis Duty	Controls presentation catalog access to Procurement Purchase Order subject area.	Procurement	Procurement - Purchase Orders
OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY	Procurement Purchase Receipts Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Receipts subject area.	Procurement	Procurement - Receipts
OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY	Procurement Purchase Receipts Analysis Duty	Controls presentation catalog access to Procurement Purchase Receipts subject area.	Procurement	Procurement - Receipts
OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY	Procurement Requisitions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Requisitions subject area.	Procurement	Procurement - Requisitions
OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY	Procurement Requisitions Analysis Duty	Controls presentation catalog access to Procurement Requisitions subject area.	Procurement	Procurement - Requisitions
OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY	Procurement Spend Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the Procurement - Spend subject area.	Procurement	Procurement - Spend
OA4F_PROC_SPEND_ANALYSIS_DUTY	Procurement Spend Analysis Duty	Controls presentation catalog access to Procurement Spend subject area.	Procurement	Procurement - Spend
OA4F_SCM_CST_COGS_AND_GROSSMARGIN_ANALYSIS_CONTENT_DUTY	COGS and Gross Margin Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - COGS and Gross Margin subject area.	Cost Management	SCM - COGS and Gross Margin
OA4F_SCM_CST_COGS_AND_GROSSMARGIN_ANALYSIS_DUTY	COGS and Gross Margin Analysis Duty	Controls presentation catalog access to COGS and Gross Margin subject area.	Cost Management	SCM - COGS and Gross Margin
OA4F_SCM_CST_COST_ACCOUNTING_ANALYSIS_DUTY	Cost Accounting Analysis Duty	Controls presentation catalog access to Cost Accounting subject area.	Cost Management	SCM - Cost Accounting
OA4F_SCM_CST_COST_ACCOUNTING_ANALYSIS_DUTY	Cost Accounting Analysis Duty	Controls presentation catalog access to Cost Accounting subject area.	Cost Management	SCM - Cost Accounting (Preview)
OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_CONTENT_DUTY	Inventory Valuations Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Inventory Valuations subject area.	Cost Management	SCM - Inventory Valuations
OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY	Inventory Valuations Analysis Duty	Controls presentation catalog access to Inventory Valuations subject area.	Cost Management	SCM - Inventory Valuations
OA4F_SCM_CST_ITEM_COST_ANALYSIS_CONTENT_DUTY	Item Cost Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Item Cost subject area.	Cost Management	SCM - Item Cost
OA4F_SCM_INV_CURRENT_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY	Inventory Current Onhand Balances Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Current Inventory Balances functional area.	Inventory	SCM - Inventory Balances
OA4F_SCM_CST_ITEM_COST_ANALYSIS_DUTY	Item Cost Analysis Duty	Controls presentation catalog access to Item Cost subject area.	Cost Management	SCM - Item Cost
OA4F_SCM_INV_INVENTORY_AGING_ANALYSIS_DUTY	Inventory Aging Analysis Duty	Object security role to control presentation catalog access to SCM - Inventory Aging subject area.	Inventory Aging	SCM - Inventory Aging
OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY	Inventory Balances Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Inventory Balances subject area.	Inventory	SCM - Inventory Balances
OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY	Inventory Balances Analysis Duty	Controls presentation catalog access to Inventory Balances subject area.	Inventory	SCM - Inventory Balances
OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_CONTENT_DUTY	Inventory Receipts Analysis Content Duty	Object security role to control presentation catalog access to DV projects and Business Metrics built against the SCM - Inventory Receipts subject area.	Inventory	SCM - Inventory Receipts
OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_DUTY	Inventory Receipts Analysis Duty	Controls presentation catalog access to Inventory Receipts subject area.	Inventory	SCM - Inventory Receipts
OA4F_SCM_INV_INVENTORY_RECEIPTS_ANALYSIS_DUTY	Inventory Receipts Analysis Duty	Object security role to control presentation catalog access to Inventory Receipts subject area.	Inventory	SCM - Inventory Receipts (Preview)
OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_CONTENT_DUTY	Inventory Transactions Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Inventory Transactions subject area.	Inventory	SCM - Inventory Transactions
OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY	Inventory Transactions Analysis Duty	Controls presentation catalog access to Inventory Transactions subject area.	Inventory	SCM - Inventory Transactions
OA4F_SCM_INV_INVENTORY_TRANSFER_ORDER_ANALYSIS_DUTY	Transfer Order Analysis Duty	Controls presentation catalog access to Transfer Order subject area.	Inventory	SCM - Transfer Orders
OA4F_SCM_INV_INVENTORY_TURNS_ANALYSIS_DUTY	Inventory Turns Analysis Duty	Object security role to control presentation catalog access to SCM - Inventory Turns subject area.	Inventory Turns	SCM - Inventory Turns
OA4F_SCM_INV_PICKING_AND_SHIPPING_ANALYSIS_DUTY	Picking and Shipping Analysis Duty	Controls presentation catalog access to Picking and Shipping subject area.	Inventory	SCM - Picking and Shipping
OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_CONTENT_DUTY	Manufacturing Work Order Materials Analysis Content Duty	Object security role to control presentation catalog access to DV projects built against the SCM - Manufacturing Materials (Preview) subject area.	Manufacturing	SCM - Manufacturing Materials (Preview)
OA4F_SCM_MFG_WO_MATERIALS_ANALYSIS_DUTY	Manufacturing Work Order Materials Analysis Duty	Object security role to control presentation catalog access to Manufacturing Work Order Materials subject area.	Manufacturing	SCM - Manufacturing Materials (Preview)
OA4F_SCM_MFG_WO_OPERATION_TRANSACTION_ANALYSIS_DUTY	Manufacturing Work Order Operation Transactions Analysis Duty	Object security role to control presentation catalog access to Manufacturing Work Order Operation Transactions subject area.	Manufacturing	SCM - Manufacturing Operation Transactions (Preview)
OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_CONTENT_DUTY	Manufacturing Work Order Resources Analysis Content Duty	Object security role to control presentation catalog access to DV projects built against the SCM - Manufacturing Resources (Preview) subject area.	Manufacturing	SCM - Manufacturing Resources (Preview)
OA4F_SCM_MFG_WO_RESOURCES_ANALYSIS_DUTY	Manufacturing Work Order Resources Analysis Duty	Object security role to control presentation catalog access to Manufacturing Work Order Resources subject area.	Manufacturing	SCM - Manufacturing Resources (Preview)
OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_CONTENT_DUTY	Manufacturing Work Orders Analysis Content Duty	Object security role to control presentation catalog access to DV projects built against the SCM - Manufacturing Work Orders (Preview) subject area.	Manufacturing	SCM - Manufacturing Work Orders (Preview)
OA4F_SCM_MFG_WORK_ORDERS_ANALYSIS_DUTY	Manufacturing Work Orders Analysis Duty	Object security role to control presentation catalog access to Manufacturing Work Orders subject area.	Manufacturing	SCM - Manufacturing Work Orders (Preview)
OA4F_SCM_OM_HOLDS_ANALYSIS_CONTENT_DUTY	Order Management Holds Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Sales Holds subject area.	Order Management	SCM - Sales Orders Holds
OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY	Order Management Holds Analysis Duty	Controls presentation catalog access to Sales Holds subject area.	Order Management	SCM - Sales Orders Holds
OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY	Order Management Holds Analysis Duty	Controls presentation catalog access to Sales Holds subject area.	Draft Sales Order Management	SCM - Draft Sales Orders Holds (Preview)
OA4F_SCM_OM_SALES_ORDER_ANALYSIS_CONTENT_DUTY	Order Management Analysis Content Duty	Controls presentation catalog access to DV projects and business metrics built against the SCM - Sales Orders subject area.	Order Management	SCM - Sales Orders
OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY	Order Management Analysis Duty	Controls presentation catalog access to Sales Orders subject area.	Order Management	SCM - Sales Orders
OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY	Order Management Analysis Duty	Controls presentation catalog access to Sales Orders subject area.	Draft Sales Order Management	SCM - Draft Sales Orders (Preview)

Common Duty Roles

The common duty roles are applicable across the analytics applications that are part of the application such as Oracle Fusion CX Analytics, Oracle Fusion HCM Analytics, and Oracle Fusion ERP Analytics.

Duty Role Code	Duty Role Name	Details	Functional Area	Gets access to Subject Area Display Name OR Associated Role
OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY	Data Warehouse Refresh Analysis Duty	Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.	Common	Common - Warehouse Refresh Statistics
OA4F_COMMON_USAGE_TRACKING_DUTY	Usage Tracking Analysis Duty	Object security role to control presentation catalog access to Common - Usage Tracking subject area.	Common	Common - Usage Tracking
OA4F_SECURITY_REPORTING_DUTY	Security Reporting Duty	Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.	Common	Common - Security Assignment Common - Security Audit History

Duty Role Code

Duty Role Name

Details

Functional Area

Gets access to Subject Area Display Name OR Associated Role

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

Data Warehouse Refresh Analysis Duty

Object security role to control presentation catalog access to Common - Warehouse Refresh Statistics subject area.

Common

Common - Warehouse Refresh Statistics

OA4F_COMMON_USAGE_TRACKING_DUTY

Usage Tracking Analysis Duty

Object security role to control presentation catalog access to Common - Usage Tracking subject area.

Common

Common - Usage Tracking

OA4F_SECURITY_REPORTING_DUTY

Security Reporting Duty

Object security role to control presentation catalog access to Security Assignment and Security Audit History subject areas.

Common

Common - Security Assignment

Common - Security Audit History

Subject Area Metric Details

Cost Management

Cost Management - COGS and Gross Margin

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder for the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Cost Distribution Accounting Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Recognized Cost of Good Sold	This metric is calculated as the sum of recognized cost of good sold.
Recognized Revenue	This metric is calculated as the sum of recognized revenue.
Recognized Gross Margin	This metric is calculated as the sum of recognized gross margin.
Recognized Gross Margin Percentage	This metric is calculated as the recognized gross margin divided by total gross margin.
Unrecognized Cost of Good Sold	This metric is calculated as the sum of unrecognized cost of goods sold.
Unrecognized Revenue	This metric is calculated as the sum of unrecognized revenue.
Unrecognized Gross Margin	This metric is calculated as the sum of unrecognized gross margin.
Unrecognized Gross Margin Percentage	This metric is calculated as the unrecognized gross margin divided by total gross margin.

Cost Management - Cost Accounting

These metrics will be used in the Ledger Currency and Cost Currency fact folder for the Subject Area. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Transaction Quantity	This metric is calculated as sum of quantity in primary unit of measure.
Costed Quantity	This metric is calculated as sum of quantity in costing unit of measure.
Transaction Debit Amount	This metric shows the debit amount for the transactions.
Transaction Credit Amount	This metric shows the credit amount for the transactions.
Transaction Net Amount	This metric shows the activity amount of the transactions. Where activity amount = Sum of debit amount - Sum of credit amount.
Accounted Debit Amount	This metric shows the accounted debit amount for the transactions.
Accounted Credit Amount	This metric shows the accounted credit amount for the transactions.
Accounted Net Amount	This metric shows the activity amount of the transactions. Where activity amount = Sum of accounted debit amount - Sum of accounted credit amount.

Cost Management - Inventory Valuations

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Costed OnHand Quantity	This metric shows onhand balance for a given period.
Unit Cost	This metric shows unit cost for a given period.
Costed OnHand Amount	This metric shows costed onhand balance for a given period.
Accounted OnHand Amount	This metric shows accounted onhand balance for a given period.
Unaccounted OnHand Amount	This metric shows unaccounted onhand balance for a given period.

Cost Management - Item Cost

These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Cost Effective Start Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Unit Cost	This metric shows average unit cost by distinct item and distinct valuation unit for a given period.
Material Cost	This metric shows average material cost by distinct item and distinct valuation unit for a given period.
Material Overhead Cost	This metric shows average material overhead cost by distinct item and distinct valuation unit for a given period.
Resource Cost	This metric shows average resource cost by distinct item and distinct valuation unit for a given period.
Overhead Cost	This metric shows average overhead cost by distinct item and distinct valuation unit for a given period.
Profit in Inventory	This metric shows average profit in inventory cost by distinct item and distinct valuation unit for a given period.
Material Cost %	This metric shows average material cost percentage of the average unit cost for a given period.
Material Overhead Cost %	This metric shows average material overhead cost percentage of the average unit cost for a given period.
Resource Cost %	This metric shows average resource cost percentage of the average unit cost for a given period.
Overhead Cost %	This metric shows average overhead cost percentage of the average unit cost for a given period.
Profit in Inventory %	This metric shows average profit in inventory cost percentage of the average unit cost for a given period.

Inventory

Inventory - Inventory Aging (Preview)

The fact folder in this subject area shows the metrics details below.

Metric	Metric Definition
Inventory Age	This metric shows Inventory Age at Item-Org level is the weighted average. This metric is calculated as below sum(age_as_per_date_received multiplied by primary_onhand_quantity) divided by inventory onhand quantity
Days left for Lot Expiry	This metric is calculated as difference of Lot Expiration Date and Current Date measured in Days
Expired Lot Age	This metric is calculated as difference of Current Date and Lot Expiration Date measured in Days
Expired Lot Quantity	This metric is calculated as below; Expired Lot Quantity is equal to Sum of Current Onhand Quantity for Lot Item where Lot expiration date is less than current date
Inventory Age Quantity	Inventory Age Quantity is the Inventory Onhand Quantity grouped in Age buckets
Inventory Age - Under 30 Days	Inventory Onhand Quantity less than 30 Days of Inventory Age
Inventory Age - 31-60 Days	Inventory Onhand Quantity between 31 to 60 Days of Inventory Age
Inventory Age - 61-90 Days	Inventory Onhand Quantity between 61 to 90 Days of Inventory Age
Inventory Age - 91-180 Days	Inventory Onhand Quantity between 91 to 180 Days of Inventory Age
Inventory Age - 181-365 Days	Inventory Onhand Quantity between 181 to 365 Days of Inventory Age
Inventory Age - Under 7 Days	Inventory Onhand Quantity less than 7 Days of Inventory Age
Inventory Age - 8-14 Days	Inventory Onhand Quantity between 8 to 14 Days of Inventory Age
Inventory Age - 15-21 Days	Inventory Onhand Quantity between 15 to 21 Days of Inventory Age
Inventory Age - 22-28 Days	Inventory Onhand Quantity between 22 to 28 Days of Inventory Age
Inventory Age - 29-91 Days	Inventory Onhand Quantity between 29 to 91 Days of Inventory Age
Inventory Age - 92-365 Days	Inventory Onhand Quantity between 92 to 365 Days of Inventory Age
Unit Cost	Unit cost in primary UOM
Inventory Age Value	Inventory Age Value is the Inventory Onhand Value grouped in different Inventory Age Buckets. This metric is calculated as below; Inventory Age Value is equal to Current Onhand Quantity multiplied by Unit Cost
Expired Lot Value	Expired Value is equal to Expired Quantity multiplied by Unit Cost
Inventory Age Value - Under 30 Days	Inventory Age Value less than 30 Days of Inventory Age
Inventory Age Value - 31-60 Days	Inventory Age Value between 31 to 60 Days of Inventory Age
Inventory Age Value - 61-90 Days	Inventory Age Value between 61 to 90 Days of Inventory Age
Inventory Age Value - 91-180 Days	Inventory Age Value between 91 to 180 Days of Inventory Age
Inventory Age Value - 181-365 Days	Inventory Age Value between 181 to 365 Days of Inventory Age
Inventory Age Value - Under 7 Days	Inventory Age Value less than 7 Days of Inventory Age
Inventory Age Value - 8-14 Days	Inventory Age Value between 8 to 14 Days of Inventory Age
Inventory Age Value - 15-21 Days	Inventory Age Value between 15 to 21 Days of Inventory Age
Inventory Age Value - 22-28 Days	Inventory Age Value between 22 to 28 Days of Inventory Age
Inventory Age Value - 29-91 Days	Inventory Age Value between 29 to 91 Days of Inventory Age
Inventory Age Value - 92-365 Days	Inventory Age Value between 92 to 365 Days of Inventory Age

Inventory - Inventory Balances

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Onhand Quantity	This metric shows inventory quantity for a given period in primary unit of measure.
Secondary Onhand Quantity	This metric shows inventory quantity for a given period in secondary unit of measure.
Reservable Onhand Quantity	This metric shows reservable Onhand inventory quantity calculated as difference between total reservable Onhand Quantity from all reservable subinventories and Reserved Quantity in primary unit of measure.
Current Onhand Quantity	This metric shows current inventory quantity in primary unit of measure.
Receiving Quantity	This metric shows the quantity received in the receiving Inventory organization but not putaway to the storage location.
Inbound Quantity	This metric shows Inbound quantities which includes Approved Purchase Orders, Advance Shipment Notice, Intransit shipment via Transfer Order, Intransit shipment via Interorganization Transfers, and Internal Requisitions.
In-Transit Quantity	This metric shows In-transit quantities which includes In-transit shipment via Transfer Orders and In-transit shipment via Inter-organization Transfers.
Consigned Quantity	This metric shows Consigned Inventory quantity which are received against consigned purchase orders or transfered to consigned explicitly.
Current Secondary Onhand Quantity	This metric shows current inventory quantity in secondary unit of measure.
Secondary Receiving Quantity	This metric shows the quantity received in secondary unit of measure in the receiving Inventory organization but not putaway to the storage location.
Secondary Consigned Quantity	This metric shows Consigned Inventory quantity in secondary unit of measure which are received against consigned purchase orders or transfered to consigned explicitly.
Historic Onhand Quantity	This metric shows Historic Inventory Balances for a given period in Primary Unit of Measure.
Historic Secondary Onhand Quantity	This metric shows Historic Inventory Balances for a given period in Secondary Unit of Measure.

Inventory - Inventory Receipts

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Receipt Headers Count	This metric is calculated as the count of distinct receipt headers.
Receipt Lines Count	This metric is calculated as the count of distinct receipt lines.
Order Count	This metric is calculated as the count of distinct orders.
Order Line Count	This metric is calculated as the count of distinct order lines.
Received Lines On Time %	This metric is calculated as the count of lines received on time divided by the count of receipt lines.
Received Lines Late %	This metric is calculated as the count of lines received late divided by the count of receipt lines.
Received Lines Early %	This metric is calculated as the count of lines received early divided by the count of receipt lines.
Receipt Lines with Correction Count	This metric is calculated as the count of receipt lines with at least one correction transaction.
Receipt Lines with Correction %	This metric is calculated as the corrected receipt count divided by the receipt line count.
Receipt Lines Rejected Count	This metric is calculated as the count of receipt lines with the rejected quantity greater than zero.
Receipt Lines Rejected %	This metric is calculated as the rejected receipt count divided by the receipt lines count.
Receipt Lines Accepted Count	This metric is calculated as the count of receipt lines with the accepted quantity greater than zero.
Receipt Lines Accepted %	This metric is calculated as the accepted receipt count divided by the receipt lines count.
Receipt Lines Returned Count	This metric is calculated as the count of receipt lines with the returned quantity greater than zero.
Receipt Lines Returned %	This metric is calculated as the receipt returned count divided by the receipt lines count.
Received Quantity	This metric is calculated as the sum of received quantity in primary, secondary, and transaction UOM.
Accepted Quantity	This metric is calculated as the sum of accepted quantity in primary, secondary, and transaction UOM.
Delivered Quantity	This metric is calculated as the sum of delivered quantity in primary, secondary, and transaction UOM.
Rejected Quantity	This metric is calculated as the sum of rejected quantity in primary, secondary, and transaction UOM.
Returned Quantity	This metric is calculated as the sum of retuned quantity in primary, secondary, and transaction UOM.
Shipped Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.

Inventory - Inventory Receipts (Preview)

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Received Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Accepted Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Delivered Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Rejected Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Returned Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Shipped Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Receipt Headers Count	This metric is calculated as the count of distinct receipt headers.
Receipt Lines Count	This metric is calculated as the count of distinct receipt lines.
Order Count	This metric is calculated as the count of distinct orders.
Order Line Count	This metric is calculated as the count of distinct order lines.
Received Lines On Time %	This metric is calculated as the count of lines received on time divided by the count of receipt lines.
Received Lines Late %	This metric is calculated as the count of lines received late divided by the count of receipt lines.
Received Lines Early %	This metric is calculated as the count of lines received early divided by the count of receipt lines.
Receipt Lines with Correction %	This metric is calculated as corrected receipt count divided by receipt line count.
Receipt Lines Rejected %	This metric is calculated as rejected receipt count divided by receipt lines count.
Receipt Lines Accepted %	This metric is calculated as accepted receipt count divided by receipt lines count.
Receipt Lines Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with at least one correction transaction.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Accepted Count	This metric is calculated as count of receipt lines with accepted quantity greater than zero.
Receipt Lines Returned Count	This metric is calculated as count of receipt lines with returned quantity greater than zero.
Post Processing Time	This metric is calculated as average difference between deliver date and receipt date.
Processing Time	This metric is calculated as average difference between receipt date and Transfer Order creation date or PO approval date
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice based receipts Applicable for ASN based shipment only.
ASN Receipts %	This metric is calculated as count of advanced shipment notice based receipts divided by count of receipt headers.
Receivng Efficiency	This metric helps to measure the receiving warehouse operator productivity.
Receiving Cycle Time	This metric is calculated as average difference between deliver date and receipt date
Consumed Quantity	This metric is calculated as sum of consumed quantity.
Purchase Order Schedule Count	Count of distinct purchase order schedule.
Received Amount for Fixed Services	This metric is the received amount for fixed services in analytics and document currency.
Received Amount for Fixed Services	This metric is the received amount for fixed services in document currency.
Returned Quantity Percentage	This metric is computed as Returned Quantity by Received Quantity in percentage.

Inventory - Inventory Transactions

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Issue Quantity	This metric is calculated as sum of issue quantity based on primary unit of measure.
Receipt Quantity	This metric is calculated as sum of receipt quantity based on primary unit of measure.
Primary Quantity	This metric is calculated as sum of primary quantity.
Secondary Quantity	This metric is calculated as sum of secondary quantity.
Transaction Quantity	This metric is calculated as sum of transaction quantity.
Consignment Received Quantity	This metric is calculated as sum of consignment received quantity.
Consignment Transferred Quantity	This metric is calculated as sum of consignment transferred quantity.

Inventory - Inventory Turns (Preview)

The fact folder in this subject area shows the metrics details below.

Metric	Metric Definition
Inventory Onhand Quantity	This metric shows current inventory quantity in primary unit of measure.
Inventory Turns	This metric is calculated as below Inventory Turns is equal to Total COGS for the year or Time Period divided by ((Cumulative Average Cost i.e Sum Onhand Value for the Time Period divided by Sum Onhand Quantities for the Time Period) multiplied by Onhand Quantity At the End of Time Period)
Inventory Turns - Period End Cost	This metric is calculated as below Inventory Turns - Period End Cost is equal to Total COGS for the Time Period divided by Inventory Value at the end of Time Period
Inventory Turns - Average Cost	This metric is calculated as below Inventory Turns - Average Cost is equal to Total COGS for the Time Period divided by(Average Cost of Beginning and End Of Time Period multiplied by Onhand Quantity At the End of Time Period)
Days in Inventory	This metric is calculated as below Days in Inventory is equal to [(Average Cost of Beginning and End Of Time Period multiplied by Onhand Quantity At the End of Time Period) divided by Total Cost of Goods Sold] multiplied by Number of Days for the selected time period
Sales Quantity	This metric is Sales Quantity in primary UOM.
Fast Moving Quantity	Items are classified as 'Fast Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 0 to 90% , classify the item as Fast (F).
Slow Moving Quantity	Items are classified as 'Slow Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 90 to 97% , classify the item as Slow (S)
Non Moving Quantity	Items are classified as 'Non Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 97 to 100% , classify the item as Non-moving (N).
Excess Quantity	Excess Quantity is the difference between Current Onhand Quantity and Sales Quantity for an year (or given period)
Obsolete Quantity	Obsolete inventory is the excess/dead inventory which could have reached the end of its life cycle. Obsolete Quantity shows the Current Onhand Quantity for items where the Sales Quantity for an year (or given period) is equal to 0
Unit Cost	Unit cost in primary UOM.
Inventory Onhand Value	This metric is calculated as below Inventory Onhand Value is equal to Current Onhand Quantity multiplied by Unit Cost
Fast Moving Value	This metric is calculated as below Fast Moving Value is equal to Fast Moving Quantity multiplied by Unit Cost
Slow Moving Value	This metric is calculated as below Slow Moving Value is equal to Slow Moving Quantity multiplied by Unit Cost
Non Moving Value	This metric is calculated as below Non Moving Value is equal to Non Moving Quantity multiplied by Unit Cost
Excess Value	This metric is calculated as below Excess Value is equal to Excess Quantity multiplied by Unit Cost
Obsolete Value	This metric is calculated as below Obsolete Value is equal to Obsolete Quantity multiplied by Unit Cost
Cost of Goods Sold	Aggregated value of Cost of Goods Sold.
Sales Value	Sales value in global currency and primary UOM.
Annual Usage %	This metric is calculated as below Annual Usage % is equal to Sales value of the Item divided by Total Sales Value multiplied by 100
Cumulative Annual Usage %	Cumulative Annual Usage Percentage.

Inventory - Picking and Shipping

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Requested Quantity	This metric is calculated as the sum of Requested Quantity for picking in transaction, primary and secondary UOM.
Picked Quantity	This metric is calculated as the sum of Picked Quantity in transaction, primary and secondary UOM.
On Time Picked Lines	This metric is the count of Shipment Lines which are Picked on time and is calculated with below logic: 1. If Scheduled Ship Date is lesser than Movement Request Creation Date, then Picked Date minus Movement Request Creation Date should be less than one day. 2. If Scheduled Ship Date is greater than or equal to Movement Request Creation Date, then Picked Date minus Scheduled Ship Date should be less than one day.
Late Picked Lines	This metric is the count of Shipment Lines which are Picked Late and is calculated with below logic: 1. If Scheduled Ship Date is lesser than Movement Request Creation Date, then Picked Date minus Movement Request Creation Date should be greater than or equal to one day. 2. If Scheduled Ship Date is greater than or equal to Movement Request Creation Date, then Picked Date minus Scheduled Ship Date should be greater than or equal to one day.
Staged Quantity	This metric is calculated as the sum of Staged Quantity for all the Shipment Lines where Line Status is equal to Staged in transaction, primary, and secondary UOM.
Shipped Quantity	This metric is calculated as the sum of Shipped quantity for all the Shipment Lines where Line Status is equal to Interfaced and Shipped in transaction, primary, and secondary UOM.
Shipped Early Quantity	This metric is calculated as the sum of Shipped Quantity for all the Shipment Lines where Actual Ship Date is less than Scheduled Ship Date in transaction, primary, and secondary UOM.
Shipped Late Quantity	This metric is calculated as the sum of Shipped Quantity for all the Shipment Lines where Actual Ship Date is greater than Scheduled Ship Date in transaction, primary, and secondary UOM.
Back Ordered Quantity	This metric is calculated as the sum of Requested Quantity for all the Shipment Lines where Line Status is equal to Backordered in transaction, primary, and secondary UOM.
Canceled Quantity	This metric is calculated as the sum of Canceled Quantity in transaction, primary, and secondary UOM.
Release to Ship Cycle Days	This metric is calculated as Actual Ship Date minus Movement Request Creation Date.
Orders Picked Not Shipped	This metric is calculated as the count of all the Orders where the Shipment Line status is equal to Staged (even if one Shipment Line in an Order is in Staged status).
Shipment Lines Picked Not Shipped	This metric is calculated as the count of Shipment Lines where the Shipment Line status is equal to Staged.
Volume	This metric shows Volume of the Shipment.
Gross Weight	This metric shows Gross Weight of the Shipment.
Net Weight	This metric shows Net Weight of the Shipment.
Closed Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced and Shipped.
Open Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Not Shipped.
Number of Shipments Ready-to-Ship	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Shipment Number is not NULL.
On Time Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced, Shipped and Actual Ship Date is less than or equal to Schedule Ship Date.
Late Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced, Shipped and Actual Ship Date is greater than Schedule Ship Date.
Shipments Past Due	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Schedule Ship Date is less than Current Date.
Shipment Due Today and Next Day	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Schedule Ship Date is equal to Current Date OR (Current Date + 1).
Lines Assigned to Shipment	This metric is calculated as the count of Shipment lines associated with a Shipment.
Total Shipments	This metric is computed as sum of Open Shipments and Closed Shipments.
Closed Shipments Percentage	This metric is computed as Closed Shipments by Total shipments expressed in percentage.
Open Shipments Percentage	This metric is computed as Open Shipments by Total shipments expressed in percentage.
On Time Shipments Percentage	This metric is computed as On Time Shipments by Closed Shipments expressed in percentage.
Late Shipments Percentage	This metric is computed as Late Shipments by Closed shipments expressed in percentage.
Shipments Past Due Percentage	This metric is computed as Shipments past due by Open Shipments expressed in percentage.
Picking Cycle Time	This metric is computed as average of Picked Date minus Pick Wave creation date.
Ship Cycle Time	This metric is computed as average of Actual Ship Date minus Picked date.
Total Picked Lines	This metric is computed as sum of On Time Picked Lines and Late Picked Lines.
On Time Picking Percentage	This metric is computed as On Time Picked Lines by Total Picked Lines expressed in percentage.
Shipping Cost	This metric shows Global shipping cost for each shipping cost type.
Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories.
Shipment Level Shipping Cost	This metric shows Global shipping cost for each shipping cost type at shipment level.
Shipment Level Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories at shipment level.
Packing Unit Level Shipping Cost	This metric shows Global shipping cost for each shipping cost type at Packing Unit level.
Packing Unit Level Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories at Packing Unit level.

Inventory - Transfer Orders

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder for the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transfer Order Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Transfer Order Amount	This metric is the calculated value of Transfer Order amount.
Total Tax	This metric is the calculated value of Total Tax on Transfer Orders.
Total Transfer Order Amount	This metric is the calculated value of Transfer Order amount inclusive of total tax.
Unit Price	This is the unit price on Transfer Order Lines.
Lines Amount	This metric is the calculated value of Transfer Order Lines amount.
Lines Tax	This metric is the calculated value of Transfer Orders Lines tax.
Total Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Requested Quantity.
Shipped Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Shipped Quantity.
Received Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Received Quantity.
Delivered Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Delivered Quantity.
Transfer Orders Count	This metric is calculated as the count of distinct Transfer Order Headers.
Transfer Order Lines Count	This metric is calculated as the count of distinct Transfer Order Lines.
Open Transfer Orders Count	This metric is calculated as the count of distinct Transfer Orders where the Transfer Order Status is Open.
Open Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Open.
Return Transfer Order Lines Count	This metric is calculated as the count of Return Transfer Order Lines where the Transfer Order Line Status is Open and the Transaction Origin type is Return.
Closed Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Closed.
Cancelled Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Cancelled.
Ordered Quantity	This metric is calculated as the sum of Requested Quantity in primary and secondary UOM.
Return Transfer Order Delivered Quantity	This metric is calculated as the sum of Delivered Quantity where Transaction Origin type is Return in primary and secondary UOM.
Cancelled Quantity	This metric is calculated as the sum of Cancelled Quantity in primary and secondary UOM.
Shipped Quantity	This metric is calculated as the sum of Shipped Quantity in primary and secondary UOM.
Received Quantity	This metric is calculated as the sum of Received Quantity in primary and secondary UOM.
Delivered Quantity	This metric is calculated as the sum of Delivered Quantity in primary and secondary UOM.

Manufacturing

Manufacturing - Manufacturing Materials (Preview)

The fact folders in this subject area shows the metrics details below.

Metric	Metric Definition
Required Quantity	This metric represents the quantity of material item that is required to perform the operation in the work order.
Actual Usage Quantity	This metric represents the actual usage of the materials consumed in a work order operation. It represents the difference between issued and returned quantities.
Open Quantity	This metric represents the open quantity that is yet to be issued to the work order operation, which is the difference between required and actual quantities.
Work orders with Unplanned materials Count	This metric represents the number of work orders with unplanned materials in work order or during work execution.
Operation Material Substitutes Count	This metric represents the number of substitute items for the work order operations.
Material Issued Quantity	This metric represents the issued quantity in transaction UOM or Primary UOM for material item.
Material Returned Quantity	This metric represents the returned quantity in transaction UOM or Primary UOM for material item.
Material Negative Issued Quantity	This metric represents the negative issued quantity in transaction UOM or Primary UOM for material item.
Material Negative Returned Quantity	This metric represents the negative returned quantity in transaction UOM or Primary UOM for material item.

Manufacturing - Manufacturing Operation Transactions (Preview)

The fact folders in this subject area shows the metrics details below.

Metric	Metric Definition
Primary Output Quantity	This metric represents the primary output quantity expected to be completed in a process manufacturing work order.
Expected Output Quantity	This metric represents the expected output quantity of the primary output item, co-product item or by-product item in a process manufacturing work order, or the expected product quantity in a discrete manufacturing work order.
Actual Output Quantity	This metric represents the actual quantities of output items yielded in a process manufacturing work order, or the actual production yielded in a discrete manufacturing work order.
Open Quantity	This metric represents the difference between expected output quantity and the actual output quantity.
Transaction Quantity in Transaction UOM	This metric represents the completed quantity in transaction UOM for output items yielded in a process manufacturing work order or the completed quantity in transaction UOM for the product item of a discrete manufacturing work order.
Transaction Quantity in Primary UOM	This metric represents the completed quantity in primary UOM for output items yielded in a process manufacturing work order or the completed quantity in primary UOM for the product item of a discrete manufacturing work order.

Manufacturing - Manufacturing Resources (Preview)

The fact folders in this subject area shows the metrics details below.

Metric	Metric Definition
Resources Count	This metric represents the distinct count of Equipment resources from the Work Order Resources Fact.
Labor Count	This metric represents the distinct count of Labor resources from the Work Order Resources Fact.
Planned Quantity Usage	This metric represents the planned usage of the resource that is required to perform the operation in the work order.
Actual Quantity Usage	This metric represents the actual usage of the resource or resource instance that was transacted to perform the operation in the work order.
Usage Quantity Variance	This metric represents the difference between the planned usage and actual usage of a resource.
Usage Quantity Variance %	This metric represents the usage quantity variance over the planned usage as a percentage value.
Resource Time Planned in Hours	This metric represents the planned usage of the resource that is required to perform the operation in the work order in Hours.
Resource Time Charged in Hours	This metric represents the actual usage of the resource or resource instance that was transacted to perform the operation in the work order in Hours.

Manufacturing - Manufacturing Work Orders (Preview)

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
On Hold Work Orders Count	This metric represents the count of work orders that are in On Hold status.
Unreleased Work Orders Count	This metric represents the count of work orders that are in Unreleased status.
Released Work Orders Count	This metric represents the count of work orders that are in Released status.
Completed Work Orders Count	This metric represents the count of work orders that are in Completed status.
Closed Work Orders Count	This metric represents the count of work orders that are in Closed status.
Rework Orders Count	This metric represents the count of work orders whose type is Rework.
Transform Work Orders Count	This metric represents the count of work orders whose type is Transform.
On-time Work Orders Count	This metric represents the count of work orders completed on-time in a given time period.
Average Work Order Delay	This metric represents the number of days where the work orders are delayed upon completion of the Work order.The delay is computed only for Closed and Completed work orders.
WO Start Quantity	This metric represents the work order quantity of a discrete manufacturing work order.
WO Completed Quantity	This metric represents the quantity completed in a work order execution.
WO Scrapped Quantity	This metric represents the quantity scrapped in a work order execution.
WO Rejected Quantity	This metric represents the quantity rejected in a work order execution.
On Hold Quantity	This metric represents the sum of quantities in work orders that are in On Hold status.
Unreleased Quantity	This metric represents the sum of quantities in work orders that are in Unreleased status.
Overcompletion Quantity	This metric represents the difference between the actual completed quantity and planned work order start quantity; when the completed quantity is greater than the work order start quantity.
Ready Quantity	This metric represents the quantities in Ready state in work order operations.
Completed Quantity	This metric represents the quantity completed in a work order execution at an operation level.
Scrapped Quantity	This metric represents the quantity scrapped in a work order execution at an operation level.
Rejected Quantity	This metric represents the quantity rejected in a work order execution at an operation level.
Manufacturing Lead Time Variance	This metric shows the variation in lead times between the manufacturing lead time and WO lead time.
WO Scrapped Quantity %	This metric represents the percentage of scrapped quantity at the work order level.
WO Rejected Quantity %	This metric represents the percentage of rejected quantity at the work order level.
WO Rework Quantity %	This metric represents the percentage of rejected quantities when compared to the completed quantities.
Work Orders Reworked %	This metric represents the percentage of work orders which has rework operations.
WO Yield %	Percentage of actual production reported when compared to the expected production at the work order level.
Planned Production Attainment	Production attainment tracks how closely the manufacturing plant is producing quantities with respect to the planned production.
Pending Work Orders Count	Number of work orders pending completion or not yet started.
Operation Yield %	Percentage of actual production reported for an operation when compared to the expected production for an operation. The operation yield is computed only for Released, Closed and Completed work orders.
WO Canceled Quantity	This metric represents the sum of quantities in work orders that are in canceled status.
Undercompletion Quantity	This metric represents the difference of Planned Start quantity and Completed quantity when the completed quantity is lesser than the planned start quantity and Undercompleted flag is enabled.
Total Work Orders Count	This metric represents the count of total count of work orders.
Perfect Work Orders Count	This metric represents the count of total count of perfect work orders.
Work Order Age	This metric represents the count of work orders that are in Unreleased, Released, or On Hold statuses whose difference between the past due start date and the current date.
Manufacturing Lead Time	This metric represents the difference of the Actual completion date and the Released date for Closed and Completed Work Orders.
WO Yield Quantity Variance	This metric represents the Quantity of products actually completed when compared to the expected production from a work order.
Behind Plan Percentage	This metric represents the percentage of products that are behind plan and this is a real time metric and historical metric.
Operation Yield Quantity Variance	This metric represents the Quantity of products actually completed when compared to the expected production from a work order and this is computed at operation level.
First Pass Yield	This metric represents the number of good units produced in an Operation for the first time divided by the number of total units going into the production process.
First Pass Yield Quantity Variance	This metric represents the Quantity of products actually completed when compared to the expected production from a work order for the first time and this is computed at operation level.
Throughput	This metric represents the rate of production or the speed at which products move in the shop floor.
Performance Ratio	This metric represents the Actual rate of production compared to the idle rate of production.
Manufacturing Effectiveness	This metric represents how well a manufacturing operation is utilized compared to its full potential, during a time period. This metric is a product of First Pass Yield and Performance Ratio.
Completed and Closed Work Orders Count	This metric represents the count of work orders that are in Completed and Closed status.

Procurement

Procurement - Accrual Balances at Period End (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Period End Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Quantity	This metric shows Accured Quantity in Primary Unit of Measure.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Uninvoiced Quantity	This metric shows Net Accrued Amount in Primary Unit of Measure.
Accrued Amount	This metric shows Amount Accrued due to receiving.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Uninvoiced Receipt Accruals	This metric shows Net Accrual Amount to be Invoiced.

Procurement - Accrual Balances at Receipt (Preview)

These metrics are used in the Analytics Currency (AC) and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Event Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Accrued Quantity	This metric shows Accured Quantity in Primary Unit of Measure.
Invoiced Quantity	This metric shows Invoiced Quantity in Primary Unit of Measure.
Accrued Amount	This metric shows Amount Accrued due to receiving.
Invoiced Amount	This metric shows Amount Invoiced in payables.
Open Accrual Balance	This metric shows Net Accrual Amount to be Invoiced.

Procurement—Agreements

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Agreement Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Agreement Line Quantity	This metric is calculated as sum of agreement line quantity in primary and transaction UOM.
Header Agreed Amount	This metric is calculated as sum of header agreed amount.
Header Released Amount	This metric is calculated as sum of header released amount.
Header Released %	This metric is calculated as total agreement released amount divided by agreement amount.
Line Agreed Amount	This metric is calculated as sum of line agreed amount.
Line Released Amount	This metric is calculated as sum of line released amount.
Line Released Amount %	This metric is calculated as sum of line released amount divided by line agreed amount.
Remaining Header Amount	This metric is calculated as header agreed amount minus header released amount where agreement amount is not null and agreed amount is greater than released amount.
Remaining Header Amount %	This metric is calculated as remaining header amount divided by total header agreed amount.
Remaining Line Amount	This metric is calculated as sum of agreed line amount minus sum of line released amount where agreement line agreed amount is not null and agreed amount is greater than released amount.
Remaining Line Amount %	This metric is calculated as sum of remaining line amount divided by sum of agreed amount.
Expired Header Released %	This metric is calculated as header released amount divided by header agreed amount where agreement amount is not null and considering headers are expired.
Expired Line Released %	This metric is calculated as line released amount divided by line agreed amount where agreement amount is not null and considering lines which are expired.
Average Unit Price	This metric shows Average of unit price at lines.
Header Agreement Count by Release %	This metric shows Count of agreement header release percent in different bucket percentages.
Header Agreement Count Expired in Days	This metric shows Count of agreement header which will expire in different bucket days.
Agreement Header Count	This metric shows Count of distinct agreement headers.
Agreement Lines Count	This metric shows Count of distinct blanket agreement lines.
Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and creation date.
Negotiation to Agreement Approval Cycle Time	This metric is calculated as average difference between agreement approval date for version zero and negotiation line creation date.
Approvers Count	This metric is calculated as average approvers for version zero of an agreement.
Item Count	This metric shows Count of distinct items.
Supplier Count	This metric shows Count of distinct suppliers.
Supplier Site Count	Count of distinct supplier sites.
Buyer Count	Count of distinct buyers.
Header Expiring Days	This metric is calculated as average difference between end date and system date where agreement header end date is not null.
Line Expiring Days	This metric is calculated as average difference between expiration date and system date where either of agreement lines expiration date is not null or header end date is not null.
Average Number of Revisions	This metric is calculated as average of agreement versions.
Amendments Count	This metric is calculated as average amendments done for an agreement.
Internal Amendments Count	This metric is calculated as average number of internal amendments for an agreement.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for an agreement.
Agreement Line Primary Quantity	This metric is calculated as sum of agreement line quantity in primary UOM.
Average Unit Price (Primary UOM)	Average of unit price at lines in primary UOM.

Procurement - Enterprise Contracts - Contracts (Preview)

These metrics are used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the subject area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Contract Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Contract Amount	This metric is calculated as the sum of contract amount.
Contract Agreed Amount	This metric is calculated as the sum of contract agreed amount.
Contract Line Amount	This metric is calculated as the sum of contract line amount.
Contract Line Agreed Amount	This metric is calculated as the sum of contract line agreed amount.
Fulfillment Amount	This metric is calculated as the sum of fulfillment amount.
Fulfillment Agreed Amount	This metric is calculated as the sum of fulfillment agreed amount.
Contract Count	This metric is calculated as the count of distinct contract headers.
Contract Line Quantity	This metric is calculated as the sum of contract line quantity and shows quantity in primary and transaction UOM.
Contract Line Committed Quantity	This metric is calculated as the sum of contract line committed quantity and shows quantity in primary and transaction UOM.
Fulfillment Quantity	This metric is calculated as the sum of fulfillment quantity and shows quantity in primary and transaction UOM.
Fulfillment Agreed Quantity	This metric is calculated as the sum of fulfillment agreed quantity and shows quantity in primary and transaction UOM.
Days to Expiration	This metric is calculated as average difference between system date and header contract end date.
Contract Cycle Time (Days)	This metric is calculated as average difference between contract signed date and contract creation date for latest version with active status.
Non-Standard Clauses Contract Count	This metric is calculated as the count of contracts where clauses are modified.
% Contracts with Non-Standard Clauses	This metric is calculated as the count of contracts where clauses are modified divided by the count of contract headers.

Procurement—Purchase Orders

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Purchase Order Creation Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Ordered Quantity	This metric is calculated as sum of quantity net of cancelled quantity at distribution level in primary and transaction UOM.
Original Ordered Quantity	This metric is calculated as sum of quantity including cancelled quantity at distribution level in primary and transaction UOM.
Cancelled Quantity	This metric is calculated as sum of cancelled quantity at distribution level in primary and transaction UOM.
Consignment Quantity	This metric is calculated as sum of consigned quantity at distribution level in primary and transaction UOM.
Billed Quantity	This metric is calculated as sum of billed quantity at distribution level in primary and transaction UOM.
Delivered Quantity	This metric is calculated as sum of delivered quantity at distribution level in primary and transaction UOM.
Received Quantity	This metric is calculated as sum of received quantity at schedule level in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity at schedule level in primary and transaction UOM.
Accepted Quantity	This metric is calculated as sum of accepted quantity at schedule level in primary and transaction UOM.
Rejected Quantity	This metric is calculated as sum of rejected quantity at schedule level in primary and transaction UOM.
Over Receipt Quantity	This metric shows quantity that is received more that purchase order quantity in primary and transaction UOM.
Purchase Order Count	This metric shows Count of distinct purchase order headers.
Purchase Order Lines Count	This metric shows Count of distinct purchase order lines.
Requisition Lines Count	This metric shows Count of distinct requisition lines associated in purchase order distributions.
Average Number of Revisions	This metric is calculated as average of revision numbers of a purchase order.
Amendments Count	This metric is calculated as average amendments done for a purchase order.
Internal Amendments Count	This metric is calculated as average number of internal amendments for a purchase order.
Supplier Amendments Count	This metric is calculated as average number of supplier initiated amendments for a purchase order.
Pre Processing Lead Time	This metric is calculated as average difference between purchase order approval date and purchase order creation date for version zero.
Approvers Count	This metric is calculated as average number of approvers in a purchase order.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date.
PO Open Cycle Time	This metric is calculated as average difference between purchase order implement date for version zero and purchase order creation date.
PO Close Cycle Time	This metric is calculated as average difference between purchase order close date and purchase order creation date.
Negotiation to PO Cycle Time	This metric is calculated as average difference between purchase order approval date for version zero and negotiation line creation date for purchase orders created from negotiations.
Requisition Based PO %	This metric is calculated as count of distribution with requisition references divided by count of total distributions.
Buyers Count	This metric shows Count of distinct buyers.
Payment Terms Count	This metric shows Count of distinct payment terms.
Ordered Amount	This metric is calculated as sum of ordered amount at distribution level inclusive of inclusive taxes.
Total Exclusive Tax Amount	This metric is calculated as sum of total exclusive tax amount at distribution level.
Total Amount	This metric is calculated as sum of total amount at distribution level.
Non Recoverable Tax Amount	This metric is calculated as sum of non recoverable tax amount at distribution level.
Recoverable Tax Amount	This metric is calculated as sum of recoverable tax amount at distribution level.
Non Recoverable Inclusive Tax Amount	This metric is calculated as sum of non recoverable inclusive tax amount at distribution level.
Recoverable Inclusive Tax Amount	This metric is calculated as sum of recoverable inclusive tax amount at distribution level.
Delivered Amount	This metric is calculated as sum of delivered amount at distribution level.
Billed Amount	This metric is calculated as sum of billed amount at distribution level.
Cancelled Amount	This metric is calculated as sum of cancelled amount at distribution level.
Accepted Amount	This metric is calculated as sum of accepted amount at schedule level.
Accepted Rate	This metric is calculated as sum of accepted amount divided by sum of received amount at schedule level.
Received Amount	This metric is calculated as sum of received amount at schedule level.
Shipped Amount	This metric is calculated as sum of shipped amount at schedule level.
Avg Unit Price	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity.
Max Unit Price	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Min Unit Price	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level.
Average Amount Per PO	This metric is calculated as sum of ordered amount divided by count of distinct purchase orders.
Supplier Count	This metric shows Count of distinct Supplier.
Open PO Count	This metric shows Count of purchase order header status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Count metric.
Closed PO Count	This metric shows Count of purchase order header status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Count metric.
Rejected Quantity %	This metric shows Rejected Quantity percentage to overall Receipt Quantity for a given period.
Over Receipt Quantity %	This metric shows Over Receipt Quantity percentage to overall Receipt Quantity for a given period.
Cancelled Quantity %	This metric shows Cancelled Quantity percentage to overall Ordered Quantity for a given period.
Discounts Amount	This metric shows discount amount for the purchase order lines which has discount type as amount or percentage.
Negotiated Amount	This metric shows amount of the purchase order lines which has negotiated indicator as Y.
Open PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open and Closed for Receiving. This metric is deprecated in 23.R2. Please use the Open Purchase Order Amount metric.
Closed PO Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed for Invoicing, Closed, and Finally Closed. This metric is deprecated in 23.R2. Please use the Closed Purchase Order Amount metric.
Over Receipt Amount	This metric shows amount that is received more than purchase order quantity at schedule level.
Avg Unit Price (Primary UOM)	This metric is calculated as sum of ordered amount excluding inclusive taxes divided by sum of ordered quantity in primary UOM.
Max Unit Price (Primary UOM)	This metric is calculated as maximum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Min Unit Price (Primary UOM)	This metric is calculated as minimum of ordered amount excluding inclusive taxes divided by sum of ordered quantity at distribution level in primary UOM.
Open Purchase Order Count	Count of purchase order header status equal to Open, Closed for Receiving, and Closed for Invoicing.
Closed Purchase Order Count	Count of purchase order header status equal to Closed, and Finally Closed.
Open Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Open, Closed for Receiving, and Closed for Invoicing.
Closed Purchase Order Amount	This metric shows the sum of ordered amount at distribution level inclusive of inclusive taxes with status equal to Closed, and Finally Closed.

Procurement—Receipt Accounting (Preview)

These metrics are used in the Analytics Currency (AC), Document Currency (DC), and Ledger Currency fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Receipt Accounting Transaction Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metrics

Metric	Metric Definition
Transaction Quantity	This metric displays the Receipt Accounting Transaction level Quantity.
Quantity in Primary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Primary Unit of Measure.
Quantity in Secondary UOM	This metric displays the Receipt Accounting Transaction level Quantity in Secondary Unit of Measure.
Debit Amount	This metric displays the Debit Amount for each Receipt Accounting Distribution.
Credit Amount	This metric displays the Credit Amount for each Receipt Accounting Distribution.
Count of Accrued Receipts	This metric displays the count of accrued receipts.

Procurement—Receipts

The fact folders in this subject area show the metrics details described in the table.

Metrics

Metric	Metric Definition
Received Quantity	This metric is calculated as sum of received quantity in primary and transaction UOM.
Accepted Quantity	This metric is calculated as sum of accepted quantity in primary and transaction UOM.
Delivered Quantity	This metric is calculated as sum of delivered quantity in primary and transaction UOM.
Rejected Quantity	This metric is calculated as sum of rejected quantity in primary and transaction UOM.
Returned Quantity	This metric is calculated as sum of returned quantity in primary and transaction UOM.
Consumed Quantity	This metric is calculated as sum of consumed quantity in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity in primary and transaction UOM.
Receipt Headers Count	This metric shows Count of distinct receipt headers.
Receipt Lines Count	This metric shows Count of receipt lines.
Purchase Order Count	This metric shows Count of distinct purchase orders.
Purchase Order Schedule Count	This metric shows Count of distinct purchase order schedule.
Received Lines On Time %	This metric is calculated as count of lines received on time divided by count of receipt lines.
Received Lines Late %	This metric is calculated as count of lines received late divided by count of receipt lines.
Received Lines Early %	This metric is calculated as count of lines received early divided by count of receipt lines.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with atleast one correction transaction.
Receipt Lines with Correction %	This metric is calculated as receipt corrected count divided by receipt line count.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Rejected %	This metric is calculated as receipt rejected count divided by receipt lines count.
Receipt Lines Accepted Count	This metric is calculated as count of receipt lines with accepted quantity greater than zero.
Receipt Lines Accepted %	This metric is calculated as receipt accepted count divided by receipt lines count.
Receipt Lines Returned Count	This metric is calculated as count of receipt lines with returned quantity greater than zero.
Receipt Lines Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
Post Processing Time	This metric is calculated as average difference between deliver date and receipt date.
Processing Time	This metric is calculated as average difference between receipt date and purchase order approval date for version zero.
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice-based receipts.
ASN Receipts %	This metric is calculated as count of advanced shipment notice-based receipts divided by count of receipt headers.
Received Amount	This metric is calculated as sum of received quantity multiplied by unit price from purchase order in primary UOM.
Accepted Amount	This metric is calculated as sum of accepted quantity multiplied by unit price from purchase order in primary UOM.
Delivered Amount	This metric is calculated as sum of delivered quantity multiplied by unit price from purchase order in primary UOM.
Rejected Amount	This metric is calculated as sum fo rejected quantity multiplied by unit price from purchase order in primary UOM.
Returned Amount	This metric is calculated as sum of returned quantity multiplied by unit price from purchase order in primary UOM.
Avg Unit Price (Primary UOM)	Average of unit price at purchase order lines in primary UOM.

Procurement—Requisitions

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Requisition Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Requisition Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split, and replaced line status. This shows quantity in primary and transaction UOM.
Requisition Count	Count of distinct requisitions.
Requisition Line Count	Count of requisition lines excluding reinstate, split, and replaced line status.
Rejected Requisition Count	Count of distinct requisition with rejected status.
Rejected Requisition Lines Count	Count of requisition lines with rejected status and excludes reinstate, split, and replaced line status.
Pending Approval Requisition Lines Count	Count of requisition lines with pending approval status and excludes reinstate, split, and replaced line status.
Unprocessed Requisition Lines Count	Count of requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Approved Requisition Lines Count	Count of requisition lines with approved status and excludes reinstate, split, and replaced line status.
Processed Requisition Lines Count	Count of requisition lines which got converted to purchase order and purchase order header having processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Overdue Requisition %	This metric shows Unfulfilled Overdue Requisition Amount percentage of the overall Requisition Amount for a given period.
Fulfilled Requisition Lines Count	Count of requisition lines for which purchase order got processed and has purchase order line fulfilled flag value as Y. Purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Approval Cycle Time Days	This metric is calculated as average difference between requisition approval date and requisition submitted date for version zero.
PR to PO Cycle Time	This metric is calculated as average difference between purchase order creation date and requisition line approval date. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Cycle Time Days	This metric is calculated as average difference between purchase order line fulfill date and requisition line last submitted date. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Approval to PO Fulfillment Time	This metric is calculated as average difference between purchase order line fulfill date and requisition line last approval date. And fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split and replaced line status.
Unprocessed Average Aging Days	This metric is calculated as average difference between system date and requisition line last approval date for requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status. .
Requisition Amount	This metric is calculated as sum of amount at distribution level and excludes reinstate, split, and replaced line status.
Unprocessed Overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unprocessed status and crossed the requested delivery date and the unprocessed status requisition lines which are yet to get converted to purchase order or purchase order header without processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Approved Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with approved status. This metrics excludes reinstate, split, and replaced line status.
Processed Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with processed status. The processed status requisition lines are those that got converted to purchase order and purchase order header having processed date (version 0). This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status. The unfulfilled status requisition lines are those purchase orders that got processed and have purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Unfulfilled Overdue Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with unfulfilled status and crossed the requested delivery date. The unfulfilled status requisition lines are those purchase orders that got processed and has purchase order line fulfilled flag value as N. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Fulfilled Requisition Amount	This metric is calculated as sum of amount at distribution level with requisition lines with fulfilled status. The fulfilled status requisition lines are those that have purchase order line fulfilled flag value as Y. Purchase order line fulfilled flag will have value as Y only when all the schedule lines for that purchase order line is closed for receiving or invoicing. The fulfilled date is maximum of the schedule receipt dates or invoice dates. This metrics excludes internal requisition and reinstate, split, and replaced line status.
Requisition Primary Quantity	This metric is calculated as sum of quantity at distribution level and excludes reinstate, split and replaced line status. This shows quantity in primary UOM.
Requisition Amount – Without cancelled	This metric is calculated as sum of amount at distribution level and excludes cancelled, reinstate, split, and replaced line status.
Requisition Amount - Parent Reinstate Line	This metric is calculated as sum of amount at distribution level and includes parent reinstate and excludes cancelled, split, and replaced line status.
Requisition Quantity - With Reinstate Line	This metric is calculated as sum of quantity at distribution level and includes parent reinstate and cancelled, but excludes split and replaced line status.
Requisition Line Count - With Reinstate Line	Count of requisition lines excluding split and replaced line status.
Requisition Quantity - Without Cancelled	This metric is calculated as sum of quantity at distribution level and excludes Cancelled , reinstate, split and replaced line status.

Procurement—Spend

These metrics are used in the Analytics Currency (AC) fact folder, Ledger Currency (LC) fact folder, and Document Currency (DC) fact folder in the Subject Areas.

Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Expense Distribution accounting date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies. Currently only accounted invoices are supported.

Metric	Metric Definition
Quantity Invoiced	This metric is calculated as the sum of Quantity Invoiced from Invoice distributions in primary and transaction UOM.
Invoice Amount	This metric is calculated as Sum of Amounts from the Invoice Accounting distribution lines for an invoice distribution.
Avg Invoice Unit Price	This metric is calculated as Sum of Invoice Amounts divided by Sum of Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Max Invoice Unit Price	This metric is calculated as Maximum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Min Invoice Unit Price	This metric is calculated as Minimum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend.
Spend	This metric is calculated as Sum of Invoice Amounts where invoice is approved and invoice distribution is validated. This metric excludes Invoice Distributions for withholding tax invoices and lines, prepayment invoices, and prepayment application lines.
Addressable Spend	This metric is calculated as Sum of 'Spend' where Invoice Distribution Types are Accrual, Item, Exchange Rate Variance, Invoice Price Variance, Retainage and Retro Active Price Accrual.
PO Matched Spend	This metric is calculated as the sum of Invoice Amounts, where Invoice distributions has a Purchase Order Reference.
Agreement Spend	This metric is calculated as the sum of Spend, where Invoice Distributions has a Purchase Order reference, and the corresponding Purchase Order Line has a Blanket Purchase Agreement or Contract Purchase Agreement reference.
Non Agreement Spend	This metric is calculated as the sum of Spend where Invoice Distributions has a Purchase Order reference, and Purchase Order Line does not have a Blanket Purchase Agreement or Contract Purchase agreement reference.
Agreement Leakage Spend	This metric is calculated as the sum of Spend where Invoice Distributions has a Purchase Order reference, and the Purchase Order Line does not have an agreement associated with it, although an open Blanket agreement is available for the item in Purchase order. This metric works only for Inventory Item-based purchase orders.
Other Non Agreement Spend	This metric is calculated as Non Agreement Spend minus Agreement Leakage Spend.
Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is checked for the corresponding Purchase Orders Lines.
Non Negotiated Spend	This metric is calculated as PO Matched Spend where the Negotiated Flag is not checked for the corresponding Purchase Orders Lines.
Average Spend Per invoice	This metric is calculated as the sum of Spend divided by the Count of Spend Invoices.
Electronic Invoices Count	This metric is calculated as the Count of Distinct Invoice Headers where Invoice Header source is not equal to Manual Invoice Entry.
Invoice Lines Count	This metric is calculated as the Count of Distinct invoice Lines.
Invoices Count	This metric is calculated as the Count of Distinct invoice Headers.
Purchase Order Lines Count	This metric is calculated as the Count of Distinct Purchase Order Lines referenced in Invoice Distributions.
Purchase Orders Count	This metric is calculated as the Count of Distinct Purchase Order Headers referenced in Invoice Distributions.
Manual Invoices Count	This metric is calculated as the Count of Distinct Invoice Headers where Invoice Header source is equal to Manual Invoice Entry.
Suppliers Count	This metric is calculated as the Count of Distinct Suppliers on Invoice Headers.
PO Matched Invoices Count	This metric is calculated as the Count of Distinct invoices headers which are fully or partially matched to the purchase order.
Invoices Before PO Creation Count	This metric is calculated as the Count of invoice Headers where Invoice date is greater than the purchase order Creation date.
Paid Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is already paid.
Open Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is not paid yet.
Perfect Invoices Count	This metric is calculated as Count of Distinct Invoice headers where invoice header is partially or fully matched to Purchase Order with no price variance.
Invoices with IPV Count	This metric is calculated as Count of Distinct Invoice headers where invoices have more than one distribution line status in Invoice Price Variance or Tax Invoice Price Variance.
Buyer Count	This metric is calculated as Distinct Buyers on Invoice Headers.
Supplier Site Count	This metric is calculated as Count of Distinct Supplier Sites on Invoice Headers.
Payables Invoicing Business Unit Count	This metric is calculated as distinct count of Payables Invoicing Business Units on Invoice Headers.
Purchasing Category Count	This metric is calculated as Count of Distinct Purchasing Category on Invoice Lines.
Payment Terms Count	This metric is calculated as Count of Distinct Payment Terms on Invoice Headers.
Item Based Purchases %	This metric is calculated as the percentage of Distinct Count of item-based Purchase Order Lines over Distinct Count of Purchase Order Lines.
PO Matched Spend %	This metric is calculated as percentage of PO Matched Spend over Spend.
Non PO Matched Spend %	This metric is calculated as percentage of Non PO Matched Spend over Spend.
Agreement Spend %	This metric is calculated as percentage of Agreement Spend over Spend.
Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Spend.
Agreement Leakage Spend %	This metric is calculated as percentage of Agreement Leakage Spend over Spend.
Negotiated Spend %	This metric is calculated as percentage of Negotiated Spend over Spend.
Supplier Spend %	This metric is calculated as percentage of Spend over Spend across all suppliers. This metric is used to analyze individual supplier Spend against Spend across all suppliers.
Category Spend %	This metric is calculated as percentage of Spend over Spend across all categories. This metric is used to analyze individual category Spend against Spend across all categories.
Invoice Price Variance	This metric is calculated as sum of amounts from Invoice distribution for Distribution Line status Invoice Price Variance.
Primary Quantity Invoiced	This metric is calculated as Sum of Quantity Invoiced from Invoice distributions in primary UOM.
Avg Invoice Unit Price (Primary UOM)	This metric is calculated as Sum of Invoice Amounts divided by Sum of Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Max Invoice Unit Price (Primary UOM)	This metric is calculated as Maximum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Min Invoice Unit Price (Primary UOM)	This metric is calculated as Minimum of Invoice Amounts divided by Invoiced Quantity where Quantity Invoiced is not zero. This metric is calculated for Invoice distributions conforming as Addressable Spend in primary UOM.
Other Non-Agreement Spend %	This metric is calculated as the percentage of other non agreement spend amount over spend amount.
Addressable Spend %	This metric is calculated as percentage of Addressable Spend over Spend.
Category Non Agreement Spend %	This metric is calculated as percentage of Non Agreement Spend over Non Agreement Spend across all categories. This metric is used to analyze individual category Non Agreement Spend against Non Agreement Spend across all categories.
Agreement Leakage to PO Spend %	This metric is calculated as the percentage of agreement leakage amount over PO matched spend amount.
Non Agreement to PO Spend %	This metric is calculated as the percentage of non agreement amount over PO matched spend amount.

Order Management

Order Management - Draft Sales Orders (Preview)

The fact folder in this subject area shows the metrics details below.

Metric	Metric Definition
Quantity Ordered	This metric is calculated as sum of ordered quantity from lines and shows quantity in primary and transaction UOM.
Returned Quantity	This metric is calculated as sum of returned quantity from lines and shows quantity in primary and transaction UOM.
Order List Price Amount	This metric shows order total list price amount.
Order Discount Amount	This metric shows order total discount amount.
Order Net Price Amount	This metric shows order total net price amount.
Order Shipping Amount	This metric shows order total shipping amount.
Order Tax Amount	This metric shows order total tax amount.
Order Credit Amount	This metric shows order total credit amount.
Charge Unit Price	This shows price for one unit of the item in header currency.
Charge Extended Amount	This metric is calculated as Charge Unit Price multiplied by Ordered Quantity in header currency.
Charge Unit Selling Price	This metric is calculated as Charge Unit Price filtered by Price Element Usage as Net Price.
Orders Count	This metric shows Count of distinct sales orders.
Lines Count	This metric shows Count of fulfillment lines with line category of order.
Return Lines Count	This metric shows Count of fulfillment lines with line category of return.
Charge Unit Selling Price (Primary UOM)	This metric is calculated as Charge Unit Price in primary UOM filtered by Price Element Usage as Net Price.
Count of Orders in Draft Status	This metric shows Count of Orders in Draft Status.
Count of Orders in Pending Approval Status	This metric shows Count of Orders in Pending Approval Status.
Count of Orders in Credit Review Pending Status	This metric shows Count of Orders in Credit Review Pending Status.

Order Management - Draft Sales Orders Holds (Preview)

The fact folder in this subject area shows the metrics details below..

Metric	Metric Definition
Fulfillment Lines on Holds Count	This metric is calculated as count of fulfillment lines on hold, considering holds only at fulfillment lines (any order header or line level hold is considered for fulfillment line as well.
Draft Sales Orders Count on Hold	This metric shows Count of distinct Sales order headers where Orders are on hold and the Order status is Draft.

Order Management - Sales Orders

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in the Subject Area. Analytics Currency and Exchange Rate Type are configured when the product is set up. Exchange Rate date basis uses Ordered Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Quantity Ordered	This metric is calculated as sum of ordered quantity from lines and shows quantity in primary and transaction UOM.
Reserved Quantity	This metric is calculated as sum of reserved quantity from lines and shows quantity in primary and transaction UOM.
RMA Delivered Quantity	This metric is calculated as sum of RMA delivered quantity from lines and shows quantity in primary and transaction UOM.
Cancelled Quantity	This metric is calculated as sum of cancelled quantity from lines and shows quantity in primary and transaction UOM.
Shipped Quantity	This metric is calculated as sum of shipped quantity from lines and shows quantity in primary and transaction UOM.
Fulfilled Quantity	This metric is calculated as sum of fulfilled quantity from lines and shows quantity in primary and transaction UOM.
Returned Quantity	This metric is calculated as sum of returned quantity from lines and shows quantity in primary and transaction UOM.
Order List Price Amount	This metric shows order total list price amount.
Order Discount Amount	This metric shows order total discount amount.
Order Net Price Amount	This metric shows order total net price amount.
Order Shipping Amount	This metric shows order total shipping amount.
Order Tax Amount	This metric shows order total tax amount.
Order Credit Amount	This metric shows order total credit amount.
Lines Amount	This metric is calculated as lines amount for line category as order.
Return Lines Amount	This metric is calculated as lines amount for line category as return.
Open Lines Amount	This metric is calculated as lines amount for line category as order for open sales orders.
Return Lines Open Amount	This metric is calculated as lines amount for line category as return for open sales orders.
Return Lines Closed Amount	This metric is calculated as lines amount for line category as return for closed sales orders.
Shipped Lines Amount	This metric is calculated as amount for lines which are shipped.
Billed Lines Amount	This metric is calculated as lines billing amount for line category as order.
Past Due Lines Amount	This metric is calculated as amount for lines where scheduled ship date is less than system date and lines are not shipped and for line category as order.
On Time Shipment Lines Amount	This metric is calculated as amount for lines which are shipped on time.
Perfect Order Lines Amount	This metric is calculated as amount for lines which are perfect order lines.
Perfect Order Lines Amount %	This metric shows Perfect Order Line Amount percentage of the overall Sale Order Fulfilment Line Amount for a given period.
Late Shipped Lines Amount	This metric is calculated as amount for lines which are not shipped on time.
Cancelled Lines Amount	This metric is calculated as amount for lines which are shipped in full.
Cancelled Lines Amount	This metric is calculated as amount for lines which are cancelled.
Lines On Holds Open Amount	This metric is calculated as lines amount for sales orders which are on hold and fulfilment lines are open.
Unit List Price	This metric is calculated as average of unit list price.
Unit Selling Price	This metric is calculated as average of unit selling price.
Charge Unit Price	This shows price for one unit of the item in header currency.
Charge Extended Amount	This metric is calculated as Charge Unit Price multiplied by Ordered Quantity in header currency.
Charge Unit Selling Price	This metric is calculated as Charge Unit Price filtered by Price Element Usage as Net Price.
Perfect Order Lines Count	This metric is calculated as count of lines with line category as order, lines are shipped and meet the following conditions: Scheduled ship date is greater than or equal to actual ship date; Line is shipped in full; Line does not have a return order referenced.
Perfect Order Lines %	This metric is calculated as perfect order lines divided by lines which are shipped.
Perfect Order Count	This metric is calculated as orders which are closed and have all shipped line as perfect order line.
Perfect Order %	This metric is calculated as count of perfect orders divided by count of closed orders.
Lines Shipped in Full Count	This metric is calculated as count of lines shipped in full where line is not split.
Lines Shipped in Full %	This metric is calculated as lines shipped in full divided by count of lines shipped.
Orders Shipped in Full Count	This metric is calculated as orders which are closed and have all shipped line as shipped in full.
Orders Shipped in Full %	This metric is calculated as count of shipped in full orders divided by count of closed orders.
On Time Shipment Lines Count	This metric is calculated as count of lines which are shipped on time.
On Time Shipment Lines %	This metric is calculated as count of lines shipped on time divided by count of shipped lines.
On Time Shipment Lines Count - Requested Delivery Date Based On	This metric is calculated as count of lines which are shipped on time based on requested delivery date.
On Time Shipment Lines % - Requested Delivery Date Based On	This metric is calculated as count of lines shipped on time based on requested delivery date divided by count of shipped lines.
Order To Shipment Lines Cycle Times	This metric is calculated as average of difference between actual ship date and submitted date.
Delayed Scheduled Lines	This metric is calculated as average of difference between schedule ship date and requested ship date.
Received Return Lines Count	This metric is calculated as count of return order lines where material is received.
Closed Orders Count	Count of distinct order headers where orders are closed.
Shipped Lines Count	Count of shipped order lines.
Orders Count	Count of distinct sales orders.
Lines Count	Count of fulfillment lines with line category of order.
Open Orders Count	Count of distinct order headers where orders are open.
Open Lines Count	Count of fulfillment lines with line category of order and lines are open.
Return Lines Count	Count of fulfillment lines with line category of return.
Charge Unit Selling Price (Primary UOM)	This metric is calculated as: Charge Unit Price in primary UOM filtered by Price Element Usage as Net Price.
Order Fill Rate	This metric is calculated as the count of completely Fulfilled Sales Orders divided by the total number of submitted Sales Orders
Order Line Fill Rate	This metric is calculated as the count of completely Fulfilled Order Lines divided by the total number of Order Fulfillment Lines
Unit Cost	This metric shows average unit cost at inventory organization level in primary UOM.
Extended Selling Price	This metric is calculated as sum of ordered quantity in primary UOM multiplied by unit selling price.
Extended Cost	This metric is calculated as sum of ordered quantity in primary UOM multiplied by unit cost.
Projected Gross Margin	This metric is calculated as difference between extended selling price and extended cost.

Order Management - Sales Orders Holds

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Fulfillment Lines on Holds Count	This metric is calculated as count of fulfillment lines on hold, considering holds only at fulfillment lines (any order header or line level hold is considered for fulfillment line as well).
Average Hold Time	This metric is calculated as average of difference between hold released date and hold applied date.
Open Orders Count	Count of distinct order headers where orders are open.

Descriptive Flexfield (DFF)

Cost Management

These descriptive flexfields are supported by Cost Management subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
SCM - Item Cost	Supports Items
SCM - Inventory Valuations	Supports Items
SCM - COGS and Gross Margin	Supports Customer, Customer Account, Transactions Headers, Transactions Lines, and Items

Inventory Management

These descriptive flexfields are supported by Inventory subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
SCM - Inventory Balances	Supports Item Catalog, Item Category, Locator, Subinventory, and Items
SCM - Inventory Transactions	Supports Item Catalog, Item Category, Locator, Subinventory, Transaction Types, Inventory Transactions, and Items
SCM - Picking and Shipping	Supports Customer, Customer Account, Items, and Shipment Lines
SCM - Transfer Orders	Supports Transfer Order, Transfer Order Lines, Transfer Order Distribution, and Items
SCM - Inventory Receipts	Supports Receipt Headers and Items
SCM - Inventory Receipts (Preview)	Supports Item, Receipt Headers and Receipt Transactions.

Manufacturing

These descriptive flexfields are supported by Manufacturing subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
SCM - Manufacturing Work Orders (Preview)	Supports Items, Manufacturing Organizations, Work Areas, Work Centers, Work Orders and Operations
SCM - Manufacturing Operation Transactions (Preview)	Supports Items, Manufacturing Organizations, Work Areas, Work Centers, Work Orders, Operations, Operation Transactions, Outputs and Output Items
SCM - Manufacturing Resources (Preview)	Supports Items, Manufacturing Organizations, Work Areas, Work Centers, Resources, Work Orders, Operations, Operation Resources and Resource Transactions
SCM - Manufacturing Materials (Preview)	Supports Items, Material Items, Manufacturing Organizations, Work Areas, Work Centers, Work Orders, Operations and Operation Materials

Order Management

These descriptive flexfields are supported by Order Management subject areas.

Subject Area Name	Descriptive Flexfield (DFF) Supported
SCM - Sales Orders	Supports Customer, Customer Account and Items
SCM - Sales Orders Holds	Supports Customer and Customer Account
SCM - Draft Sales Orders (Preview)	Supports Customer, Customer Account and Items.
SCM - Draft Sales Orders Holds (Preview)	Supports Customer and Customer Account.

Purchasing

Below Descriptive Flexfields are supported by Procurement subject area.

Subject Area Name	Descriptive Flexfield (DFF) Supported
Procurement - Spend	Supports Suppliers, Supplier Sites, Invoice Headers, Invoice Lines, Invoice Distributions, and Items
Procurement - Purchase Orders	Supports Suppliers, Supplier Sites, Purchase Orders Headers, Purchase Orders Lines, and Items
Procurement - Receipts	Supports Suppliers, Supplier Sites, Receipt Headers, Receipt Lines, and Items
Procurement - Agreements	Supports Suppliers, Supplier Sites, Agreement Headers, Agreement Lines, and Items
Procurement - Requisitions	Supports Suppliers, Supplier Sites, Requisition Headers, Requisition Lines, Requisition Distributions, and Items
Enterprise Contracts - Contracts (Preview)	Supports Contracts and Contracts Lines.
Procurement - Receipt Accounting (Preview)	Supports Items and Suppliers
Procurement - Accrual Balances at Period End (Preview)	Supports Items and Suppliers.
Procurement - Accrual Balances at Receipt (Preview)	Supports Items and Suppliers.