7 Subject Areas
Subject Areas
Overview
This chapter provides information on the subject areas with data you maintain in 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 23.R1_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.Usage Tracking
Description
Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In Oracle Fusion Analytics Warehouse 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 KPIs, 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 KPIs show progress towards such goals.
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?
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.
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
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.
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 Analytics Warehouse, 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 23.R1_Fusion_SCM_Analytics_BusinessQuestions.html.
Note:
Job roles are the same as job-specific groups.Job-Specific Groups
Overview
For each job-specific group in this section, click the links for more detailed information about the duty roles, subject areas, and business questions associated with the job-specific group.
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_DOO_ORDER_ADMINISTRATOR_JOB | Order Administrator | Has Author privileges |
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 FAW_SCM_Author |
Order Management |
| ORA_DOO_ORDER_MANAGER_JOB | Order Manager | Has Author privileges |
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 FAW_SCM_Author |
Order Management |
| ORA_INV_INVENTORY_MANAGER_JOB | Inventory Manager | Has Author privileges |
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 FAW_SCM_Author |
Inventory |
| ORA_INV_WAREHOUSE_MANAGER_JOB | Warehouse Manager | Has Author privileges |
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 FAW_SCM_Author |
Inventory, Procurement |
| ORA_CST_COST_ACCOUNTANT_JOB | Cost Accountant | Has Author privileges |
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 FAW_SCM_Author |
Cost Management |
| ORA_PO_PURCHASE_ANALYSIS_ABSTRACT | Purchase Analysis | Has Author privileges |
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_AP_ACCOUNTS_PAYABLE_MANAGER_JOB | Accounts Payable Manager | Has Author privileges |
OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY FAW_SCM_Author |
Procurement |
| ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB | Accounts Payable Specialist | Has Author privileges |
OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY FAW_SCM_Author |
Procurement |
| ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB | Accounts Payable Supervisor | Has Author privileges |
OA4F_FIN_AP_BUSINESS_UNIT_DATA OA4F_PROC_SPEND_ANALYSIS_DUTY OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY FAW_SCM_Author |
Procurement |
| ORA_PO_BUYER_JOB | Buyer | Has Author privileges |
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 FAW_SCM_Author |
Procurement |
| ORA_PO_PROCUREMENT_MANAGER_JOB | Procurement Manager | Has Author privileges |
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 FAW_SCM_Author |
Procurement |
| ORA_PON_CATEGORY_MANAGER_JOB | Category Manager | Has Author privileges |
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 FAW_SCM_Author |
Procurement |
| ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB | Procurement Contract Administrator | Has Author privileges |
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 FAW_SCM_Author |
Procurement |
Common Job-Specific Groups
The common job-specific groups are applicable across the analytics applications that are part of Oracle Fusion Analytics Warehouse 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 |
Data Roles
Overview
For each data role in this section, links are provided for more detailed information about the job-specific groups, subject areas, and business questions associated with the data role.
| Data Role Code | Data Role Name | Description | Functional Area |
|---|---|---|---|
| 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_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_CST_COSTING_ORG_DATA | Supply Chain Costing Organization Data Security | Data security role to access supply chain costing organization based data. | Cost Management |
| OA4F_PROC_REQ_BUSINESS_UNIT_DATA | Procurement Requisition Business Unit Data Security | Data security role to access procurement requisition business unit based data. | Inventory |
| 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 |
Duty Roles
Overview
For each duty role in this section, click the links for more 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 |
|---|---|---|---|---|
| OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY | Order Management Analysis Duty | Object security role to control presentation catalog access to Sales Orders subject area. | Order Management | SCM - Sales Orders |
| OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY | Order Management Holds Analysis Duty | Object security role to control presentation catalog access to Sales Holds subject area. | Order Management | SCM - Sales Orders Holds |
| OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY | Inventory Transactions Analysis Duty | Object security role to control presentation catalog access to Inventory Transactions subject area. | Inventory | SCM - Inventory Balances |
| OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY | Inventory Balances Analysis Duty | Object security role to control presentation catalog access to Inventory Balances subject area. | Inventory | SCM - Inventory Transactions |
| OA4F_SCM_CST_ITEM_COST_ANALYSIS_DUTY | Item Cost Analysis Duty | Object security role to control presentation catalog access to Item Cost subject area. | Cost Management | SCM - Item Cost |
| OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY | Inventory Valuations Analysis Duty | Object security role to control presentation catalog access to Inventory Valuations subject area. | Cost Management | SCM - Inventory Valuations |
| OA4F_SCM_INV_PICKING_AND_SHIPPING_ANALYSIS_DUTY | Picking and Shipping Analysis Duty | Object security role to control presentation catalog access to Picking and Shipping subject area. | Inventory | SCM - Picking and Shipping |
| OA4F_SCM_INV_INVENTORY_TRANSFER_ORDER_ANALYSIS_DUTY | Transfer Order Analysis Duty | Object security role to control presentation catalog access to Transfer Order subject area. | Inventory | SCM - Transfer Orders |
| 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 |
| OA4F_SCM_CST_COGS_AND_GROSSMARGIN_ANALYSIS_DUTY | COGS and Gross Margin Analysis Duty | Object security role to control presentation catalog access to COGS and Gross Margin subject area. | Cost Management | SCM - COGS and Gross Margin |
| OA4F_PROC_SPEND_ANALYSIS_DUTY | Procurement Spend Analysis Duty | Object security role to control presentation catalog access to Procurement Spend subject area. | Procurement | Procurement - Spend |
| OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY | Procurement Purchase Order Analysis Duty | Object security role to control presentation catalog access to Procurement Purchase Order subject area. | Procurement | Procurement - Purchase Orders |
| OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY | Procurement Purchase Agreement Analysis Duty | Object security role to control presentation catalog access to Procurement Purchase Agreement subject area. | Procurement | Procurement - Agreements |
| OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY | Procurement Purchase Receipts Analysis Duty | Object security role to control presentation catalog access to Procurement Purchase Receipts subject area. | Procurement | Procurement - Receipts |
| OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY | Procurement Requisitions Analysis Duty | Object security role to control presentation catalog access to Procurement Requisitions subject area. | Procurement | Procurement - Requisitions |
| OA4F_SCM_OM_SALES_ORDER_ANALYSIS_CONTENT_DUTY | Order Management Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Sales Orders" subject area. | Order Management | SCM - Sales Orders |
| OA4F_SCM_OM_HOLDS_ANALYSIS_CONTENT_DUTY | Order Management Holds Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Sales Holds" subject area. | Order Management | SCM - Sales Orders Holds |
| OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_CONTENT_DUTY | Inventory Transactions Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Inventory Transactions" subject area. | Inventory | SCM - Inventory Transactions |
| OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_CONTENT_DUTY | Inventory Balances Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Inventory Balances" subject area. | Inventory | SCM - Inventory Balances |
| OA4F_SCM_CST_ITEM_COST_ANALYSIS_CONTENT_DUTY | Item Cost Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Item Cost" subject area. | Cost Management | SCM - Item Cost |
| OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_CONTENT_DUTY | Inventory Valuations Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "SCM - Inventory Valuations" subject area. | Cost Management | SCM - Inventory Valuations |
| OA4F_PROC_PURCHASE_ORDER_ANALYSIS_CONTENT_DUTY | Procurement Purchase Order Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "Procurement - Purchase Orders" subject area. | Procurement | Procurement - Purchase Orders |
| OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_CONTENT_DUTY | Procurement Purchase Receipts Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "Procurement - Receipts" subject area. | Procurement | Procurement - Receipts |
| OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_CONTENT_DUTY | Procurement Purchase Agreement Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "Procurement - Agreements" subject area. | Procurement | Procurement - Agreements |
| OA4F_PROC_REQUISITIONS_ANALYSIS_CONTENT_DUTY | Procurement Requisitions Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "Procurement - Requisitions" subject area. | Procurement | Procurement - Requisitions |
| OA4F_PROC_SPEND_ANALYSIS_CONTENT_DUTY | Procurement Spend Analysis Content Duty | Object security role to control presentation catalog access to DV projects and KPIs built against the "Procurement - Spend" subject area. | Procurement | Procurement - Spend |
| OA4F_SCM_CST_COST_ACCOUNTING_ANALYSIS_DUTY | Cost Accounting Analysis Duty | Object security role to control presentation catalog access to Cost Accounting subject area. | Cost Management | SCM - Cost Accounting (Preview) |
Common Duty Roles
The common duty roles are applicable across the analytics applications that are part of Oracle Fusion Analytics Warehouse such as 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 subject area. | Common | Common - Warehouse Refresh |
| 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 - Cost Accounting (Preview)
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 | Shows the debit amount for the transactions. |
| Transaction Credit Amount | Shows the credit amount for the transactions. |
| Transaction Net Amount | Shows the activity amount of the transactions. Where activity amount = Sum of debit amount - Sum of credit amount. |
| Accounted Debit Amount | Shows the accounted debit amount for the transactions. |
| Accounted Credit Amount | Shows the accounted credit amount for the transactions. |
| Accounted Net Amount | Shows the activity amount of the transactions. Where activity amount = Sum of accounted debit amount - Sum of accounted credit amount. |
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 - 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 | Shows average unit cost by distinct item and distinct valuation unit for a given period. |
| Material Cost | Shows average material cost by distinct item and distinct valuation unit for a given period. |
| Material Overhead Cost | Shows average material overhead cost by distinct item and distinct valuation unit for a given period. |
| Resource Cost | Shows average resource cost by distinct item and distinct valuation unit for a given period. |
| Overhead Cost | Shows average overhead cost by distinct item and distinct valuation unit for a given period. |
| Profit in Inventory | Shows average profit in inventory cost by distinct item and distinct valuation unit for a given period. |
| Material Cost % | Shows average material cost percentage of the average unit cost for a given period. |
| Material Overhead Cost % | Shows average material overhead cost percentage of the average unit cost for a given period. |
| Resource Cost % | Shows average resource cost percentage of the average unit cost for a given period. |
| Overhead Cost % | Shows average overhead cost percentage of the average unit cost for a given period. |
| Profit in Inventory % | Shows average profit in inventory cost percentage of the average unit cost for a given period. |
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 | Shows onhand balance for a given period. |
| Unit Cost | Shows unit cost for a given period. |
| Costed OnHand Amount | Shows costed onhand balance for a given period. |
| Accounted OnHand Amount | Shows accounted onhand balance for a given period. |
| Unaccounted OnHand Amount | Shows unaccounted onhand balance for a given period. |
Inventory
Inventory - Inventory Balances
The fact folders in this subject area show the metrics details described in the table.
| Metric | Metric Definition |
|---|---|
| Onhand Quantity | Shows inventory quantity for a given period in primary unit of measure. |
| Secondary Onhand Quantity | Shows inventory quantity 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 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 - 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. |
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. |
Order Management
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 |
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. |
Procurement
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.
Metrics
| 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 | Average of unit price at lines. |
| Header Agreement Count by Release % | Count of agreement header release percent in different bucket percentages. |
| Header Agreement Count Expired in Days | Count of agreement header which will expire in different bucket days. |
| Agreement Header Count | Count of distinct agreement headers. |
| Agreement Lines Count | 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 | Count of distinct items. |
| Supplier Count | 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—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.
Metrics
| 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 | Count of distinct purchase order headers. |
| Purchase Order Lines Count | Count of distinct purchase order lines. |
| Requisition Lines Count | 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 | Count of distinct buyers. |
| Payment Terms Count | 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 | Count of distinct Supplier. |
| Open PO Count | Count of purchase order header status equal to Open and Closed for Receiving. |
| Closed PO Count | Count of purchase order header status equal to Closed for Invoicing, Closed, and Finally Closed. |
| 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. |
| 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. |
| 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. |
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 | Count of distinct receipt headers. |
| Receipt Lines Count | Count of receipt lines. |
| Purchase Order Count | Count of distinct purchase orders. |
| Purchase Order Schedule Count | 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.
Metrics
| 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. |
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.
Metrics
| 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 the sum of Spend, where invoice distribution has a Purchase Order reference, and Invoice Line types are either Item or Misc, and excludes any tax-related lines in invoices. |
| 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. |
Descriptive Flexfield (DFF)
Cost Management
These descriptive flexfields are supported by Cost Management subject areas.
Descriptive Flexfield (DFF)
| 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.
Descriptive Flexfield (DFF)
| 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 |
Order Management
These descriptive flexfields are supported by Order Management subject areas.
Descriptive Flexfields (DFF)
| Subject Area Name | Descriptive Flexfield (DFF) Supported |
|---|---|
| SCM - Sales Orders | Supports Customer, Customer Account and Items |
| SCM - Sales Orders Holds | Supports Customer, Customer Account and Items |
Purchasing
| 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 |