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 22.R2_May2022_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 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.
Note:
Job roles are the same as job-specific groups.Business Questions
Overview
For each business question in this section, click the links for more detailed information about the subject areas, job roles, 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 22.R2_May2022_Fusion_SCM_Analytics_BusinessQuestions.html.
Note:
Job roles are the same as job-specific groups.Job Roles
Overview
For each job role in this section, click the links for more detailed information about the duty roles, subject areas, and business questions associated with the job role.
Download this ZIP file that contains available job roles 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 22.R2_May2022_Fusion_SCM_Analytics_JobRoles.html.
Note:
Job roles are the same as job-specific groups.Duty Roles
Overview
For each duty role in this section, click the links for more detailed information about the job roles, subject areas, and business questions associated with the duty role.
Download this ZIP file that contains available duty roles 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 22.R2_May2022_Fusion_SCM_Analytics_DutyRoles.html.
Note:
Job roles are the same as job-specific groups.Subject Area Metric Details
Cost Management
Cost Management - Item Cost
These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in 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. |
Inventory
Inventory - Inventory Balances
These fact folder in this subject area shows below metrics details.
| 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
These fact folder in this subject area shows below metrics details.
| Metric | Metric Definition |
|---|---|
| Issue Quantity | This metric is calculated as sum of issue quantity based on primary unit of measure. |
| Receipt Quantity | This metric is calculated as sum of receipt quantity based on primary unit of measure. |
| Primary Quantity | This metric is calculated as sum of primary quantity. |
| Secondary Quantity | This metric is calculated as sum of secondary quantity. |
| Transaction Quantity | This metric is calculated as sum of transaction quantity. |
| Consignment Received Quantity | This metric is calculated as sum of consignment received quantity. |
| Consignment Transferred Quantity | This metric is calculated as sum of consignment transferred quantity. |
Inventory - Inventory Valuations
These metrics will be used in the Analytics Currency (AC) and Cost Currency fact folder in 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 - Picking and Shipping
The fact folder in this subject area shows below metrics details.
| 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. |
Order Management
Order Management - Sales 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 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
These fact folder in this subject area shows below metrics details.
| 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. |
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 |
|---|---|
| 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 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. |
| 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 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 |
|---|---|
| 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. |
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 |
| SCM - Picking and Shipping | Supports Customer, Customer Account, Items, and Shipment Lines |
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, and Items |
| Procurement - Receipts | Receipt Headers, Receipt Lines, and Items |
| Procurement - Agreements | Supports Suppliers, Supplier Sites, and Items |
| Procurement - Requisitions | Supports Suppliers, Supplier Sites, Requisition Headers, Requisition Lines, Requisition Distributions, and Items |