1. Reference for Fusion SCM Analytics
  2. Subject Areas

7 Subject Areas

Subject Areas

Overview

This chapter provides information on the subject areas with data you maintain in Oracle Fusion SCM Analytics.

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 roles 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.

Procurement—Agreements

Description

This is a detailed subject area that provides the ability to report on purchasing agreement measures like consumed amount, count of agreements, day to expire analyzed by supplier, procurement item and business units.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of agreements.

Time dimension is linked to Document Date for version zero.

Transactional Grain

The grain is at the agreement price break level.

Special Considerations

None.

Procurement—Purchase Orders

Description

This is a detailed subject area that combines the information from purchase orders, purchase order costs and purchase schedules with the ability to report on committed amounts, contract spend and purchase orders of the suppliers of an organization across suppliers, company, products, item categories and associated hierarchies at purchase order line level.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of purchase orders.

Time dimension is linked to Purchase Order Document Date for version zero (Implement Date for version zero).

Transactional Grain

The grain is at the purchase order distribution level.

Special Considerations

None.

Procurement—Receipts

Description

This is a detailed subject area that provides the ability to report on actual spend and purchase receipts of the suppliers of an organization across suppliers, company, location, products, item categories and associated hierarchies at purchase receipt line level, including reporting based on receiving time.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of receipts.

Time dimension is linked to Receipt Header Creation Date.

Transactional Grain

The grain is at the receipt lines level.

Special Considerations

None.

Procurement — Requisitions

Description

This is a detailed subject area that provides the ability to analyze key metrics on requested spend and purchase requisitions for the enterprise across suppliers, company, business units, products, item categories and associated hierarchies at purchase requisition line level.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of requisitions.

Time dimension is linked to Requisition Header Date.

Transactional Grain

The grain is at the purchase requisition distribution.

Special Considerations

None.

Procurement—Spend

Description

This detailed subject area provides the ability to report on total spending of an organization across suppliers, products, item categories, business units, cost centers, buying locations, supplier locations, and associated hierarchy.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Procurement

Time Reporting

This subject area supports historic analysis of expense distributions.

Time dimension is linked to Invoice Date.

Transactional Grain

The grain is at the AP invoice expense distribution level.

Special Considerations

None.

SCM — Inventory Balances

Description

This subject area provides information about inventory balances by quantity for products/categories by business organization which is warehouse, distribution , manufacturing etc.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Inventory

Time Reporting

This subject area supports historic analysis of inventory balances.

Time dimension is linked to Snap Shot Date and Time. .

Transactional Grain

The grain is at the locator.

Special Considerations

Supports only 12 months of historic balances.

SCM — Inventory Transactions

Description

Analyse the product-related issuance and receipt transactions that occur during a product's lifecycle at an inventory location of a business organization. The transactions are typically performed against business documents that authorize such transactions.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Inventory

Time Reporting

This subject area supports historic analysis of transactions.

Time dimension is linked to Transaction date.

Transactional Grain

The grain is at the transaction number (ID).

Special Considerations

None.

SCM — Inventory Valuations

Description

Analyze inventory valuations based on cost organization, cost book, valuation unit, valuation structure code, valuation structure type and cost currency. And ability to analyze inventory valuations for items or item category for a given period.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Cost Management

Time Reporting

This subject area supports historic analysis of inventory valuations.

Time dimension is linked to Date range between Period Start Date and Period End Date..

Transactional Grain

The grain is at the valuation ID.

Special Considerations

None.

SCM — Item Cost

Description

This subject area provides ability to analyze unit cost by cost organization, cost book, valuation unit, valuation structure code, valuation structure type and cost currency. And ability to analyze unit cost for items or item category for a given period.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Cost Management

Time Reporting

This subject area supports historic analysis of item cost.

Time dimension is linked to Cost As-of Date and this will show period end date cost based on the time attribute selected..

Transactional Grain

The grain is at the cost element, expense pool, cost level.

Special Considerations

None.

SCM — Sales Orders

Description

Analyse the enterprise's sales order demand, volume of bookings, order backlog, returns authorized, order shipped on time, shipped in full , cycle times by organization, customer, product, time and order details.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Order Management

Time Reporting

This subject area supports historic analysis of sales orders.

Time dimension is linked to Ordered Date.

Transactional Grain

The grain is at the fulfillment line.

Special Considerations

None.

SCM — Sales Orders Holds

Description

Analyses sales orders which are held, how many are affected, and what is holds applied to release cycle times.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Order Management

Time Reporting

This subject area supports historic analysis of sales orders holds.

Time dimension is linked to Hold Applied Date.

Transactional Grain

The grain is at the hold line.

Special Considerations

None.

Business Questions

How effective is an organization to schedule and manage fulfillment end-to-end cycle times?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How is purchase distributed across suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How long does it take for purchase requisitions to get approved?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How many approvers on a average are approving agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How many approvers on a average are approving purchase orders?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How many non-catalog purchase requisitions are created by volume, item, and amount?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How many times are we amending agreements and whether amendment initiation is internal or external?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How many times are we amending purchase orders and whether amendment initiation is internal or external?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

How much did the organization spend with suppliers, commodities, buyers, cost center, contracts vs non contracts, leakage etc.?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Identify items and categories with cost-saving potential in procurement operations based on prices.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Identify items, categories, and suppliers with compliance issues in their purchase agreements.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Identify the key areas for improving process efficiencies.

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Is a company using strategic suppliers and contracts effectively?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Top 10 inventory movements by plant or item category

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Top 10 items issues by transaction type

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Top 10 items receipts by transaction type

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are cycle times in terms of PR and PO Approval, PR to PO conversion?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my cycle times for agreement approvals?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my lead time standard and variances in purchase cycles?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my negotiation to agreement approval cycle times?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my processing and post processing lead time standards and variances for an Item?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my products and services for which we have agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are my purchase volume across business units?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are purchase orders creation sources and corresponding requisition sources?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are return rates for suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are the agreements utilization rates?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is an organization's current period order booking, open, shipped, invoiced, returned, open returned, past due amount in terms of quantity and amounts?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What are the creation sources for agreements?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is an organization's inventory position across supply chain in terms of quantity?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is an organization's inventory value across supply chain for an item, item category, and organization?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is my contract vs off contract spend?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the average hold times for different kinds of holds?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the centralized view of all procurement requests for purchasing department?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the classification of purchase requisitions by status, type, source of created for a period and associated purchase order details?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the inventory valuations for items or item category for a given period?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the item unit cost by different cost subelements like material, material overhead, and overhead by value and percentage?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the item unit cost for a cost organization and different cost books?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the shipment and delivery performance for an organization in terms of perfect order, shipped in full and on time (shipment and delivery) percentages?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the total booking, returns, shipped, on time shipped, perfect orders, shipped in full, late shipped amounts trends?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the trend for onhand quantity by product and category?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the trend in inventory movement in and out for items, item category, and plants?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the trend in inventory valuations for items and organizations?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is the trend of item costs over a period of time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What items are showing most volatile trend over a period of time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What commodities and services have been purchased, in what volume and price?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What is accepted and rejected rates for commodities, by suppliers?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What receipts are created manually or through ASNs?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What type of holds are applied to orders?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

What,when and how much materials are being returned?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

When were products shipped and what is the average delivery times?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Which agreements are under utilized?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Which agreements are utilized before expiry?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Which all orders have holds applied currently and in the past?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Which product, category, organization are high in terms of inventory quantity in the asset subinventory location?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Which suppliers deliver consistently on time?

Subject Areas

The following subject areas contain the folders and attributes needed to answer this business question:

Job Roles

The following job roles secure access to the data related to this business question:

Duty Roles

The following duty roles secure access to the data related to this business question:

Job Roles

Account Payable Invoice Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_INVOICE_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Account Payable Payment Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_PAYMENT_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Accounts Payable Manager

Code Name

ORA_AP_ACCOUNTS_PAYABLE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Accounts Payable Specialist

Code Name

ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Accounts Payable Supervisor

Code Name

ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Buyer

Code Name

ORA_PO_BUYER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Category Manager

Code Name

ORA_PON_CATEGORY_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Cost Accountant

Code Name

ORA_CST_COST_ACCOUNTANT_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Inventory Manager

Code Name

ORA_INV_INVENTORY_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Order Administrator

Code Name

ORA_DOO_ORDER_ADMINISTRATOR_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Order Manager

Code Name

ORA_DOO_ORDER_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Procurement Contract Administrator

Code Name

ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Procurement Manager

Code Name

ORA_PO_PROCUREMENT_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Purchase Analysis

Code Name

ORA_PO_PURCHASE_ANALYSIS_ABSTRACT

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Warehouse Manager

Code Name

ORA_INV_WAREHOUSE_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

Subject Areas

This job role secures access to the following subject areas:

Business Questions

This job role secures access to data that can answer the following business questions:

Duty Roles

Inventory Balances Analysis Duty

Code Name

OAX_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Inventory Transactions Analysis Duty

Code Name

OAX_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Inventory Valuations Analysis Duty

Code Name

OAX_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Item Cost Analysis Duty

Code Name

OAX_SCM_CST_ITEM_COST_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Order Management Analysis Duty

Code Name

OAX_SCM_OM_SALES_ORDER_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Order Management Holds Analysis Duty

Code Name

OAX_SCM_OM_HOLDS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Procurement Purchase Agreement Analysis

Code Name

OAX_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Procurement Purchase Order Analysis Duty

Code Name

OAX_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Procurement Purchase Receipts Analysis Duty

Code Name

OAX_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Procurement Requisitions Analysis Duty

Code Name

OAX_PROC_REQUISITIONS_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Procurement Spend Analysis Duty

Code Name

OAX_PROC_SPEND_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

Subject Areas

This duty role secures access to the following subject areas:

Business Questions

This duty role secures access to data that can answer the following business questions:

Subject Area Metric Details

This is the start of your topic.

Cost Management

Cost Management - Item Cost

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 to average unit cost for a given period.
Material Overhead Cost % Shows average material overhead cost to average unit cost for a given period.
Resource Cost % Shows average resource cost to average unit cost for a given period.
Overhead Cost % Shows average overhead cost to average unit cost for a given period.
Profit in Inventory % Shows average profit in inventory cost to average unit cost for a given period.

Inventory

Inventory - Inventory Balances

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 Transactions

Metric Metric Definition
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
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 issue quantity based on primary unit of measure
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 Valuations

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.

Order Management

Order Management - Sales Orders

Metric Metric Definition
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 line 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 to 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 met 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.
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.
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 Management - Sales Orders Holds

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

Purchasing

Procurement—Agreements

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder in 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
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 Quantity This metric is calculated as sum of agreement line quantity in primary and transaction UOM.
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 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

These fact folder in this subject area shows below metrics details.

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.
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.
Shipped Quantity This metric is calculated as sum of shipped quantity in primary and transaction UOM.
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 Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Requisition Creation Date to convert to 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 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 analytics currency. Metrics in these folders show amounts in their respective currencies. Currently we support only accounted invoices.

Metrics

Metric Metric Definition
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.
Quantity Invoiced This metric is calculated as the sum of Quantity Invoiced from Invoice distributions in primary and transaction UOM.
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.

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

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 Items
SCM - Inventory Transactions Supports Items and Inventory Transactions

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, and Invoice Distributions Descriptive Flexfields.
Procurement - Purchase Orders Supports Suppliers and Supplier Sites Descriptive Flexfields.
Procurement - Receipts Receipt Headers and Receipt Lines Descriptive Flexfields.
Procurement - Agreements Supports Suppliers and Supplier Sites Descriptive Flexfields.
Procurement - Requisitions Supports Suppliers and Supplier Sites, Requisition Headers, Requisition Lines, and Requisition Distributions