Order Management

This section provides information about Oracle Fusion SCM Analytics Order Management subject area metric details.

Topics

Order Management - Draft Sales Orders (Preview)

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

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

Order Management - Draft Sales Orders Holds (Preview)

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

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

Order Management - Sales Orders

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

Metric Metric Definition
Billed Lines Amount This metric is calculated as lines billing amount for line category as order.
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.
Cancelled Quantity This metric is calculated as sum of cancelled quantity from lines and shows quantity in primary and transaction UOM.
Charge Extended Amount This metric is calculated as Charge Unit Price multiplied by Ordered Quantity in header currency.
Charge Unit Price This shows price for one unit of the item in header currency.
Charge Unit Selling Price This metric is calculated as Charge Unit Price filtered by Price Element Usage as Net Price.
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.
Closed Orders Count Count of distinct order headers where orders are closed.
Delayed Scheduled Lines This metric is calculated as average of difference between schedule ship date and requested ship date.
Extended Cost This metric is calculated as sum of ordered quantity in primary UOM multiplied by unit cost.
Extended Selling Price This metric is calculated as sum of ordered quantity in primary UOM multiplied by unit selling price.
Fulfilled Quantity This metric is calculated as sum of fulfilled quantity from lines and shows quantity in primary and transaction UOM.
Late Shipped Lines Amount This metric is calculated as amount for lines which are not shipped on time.
Lines Amount This metric is calculated as lines amount for line category as order.
Lines Count Count of fulfillment lines with line category of order.
Lines On Holds Open Amount This metric is calculated as lines amount for sales orders which are on hold and fulfilment lines are open.
Lines Shipped in Full % This metric is calculated as lines shipped in full divided by count of lines shipped.
Lines Shipped in Full Count This metric is calculated as count of lines shipped in full where line is not split.
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 % - 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.
On Time Shipment Lines Amount This metric is calculated as amount for lines which are shipped on time.
On Time Shipment Lines Count This metric is calculated as count of lines which are shipped on time.
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.
Open Lines Amount This metric is calculated as lines amount for line category as order for open sales orders.
Open Lines Count Count of fulfillment lines with line category of order and lines are open.
Open Lines Quantity Count of fulfillment lines quantity with line category of order and line are open.
Open Orders Count Count of distinct order headers where orders are open.
Order Credit Amount This metric shows order total credit amount.
Order Discount Amount This metric shows order total discount amount.
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 List Price Amount This metric shows order total list price amount.
Order Net Price Amount This metric shows order total net price amount.
Orders Count Count of distinct sales orders.
Order Shipping Amount This metric shows order total shipping amount.
Orders Shipped in Full % This metric is calculated as count of shipped in full orders divided by count of closed orders.
Orders Shipped in Full Count This metric is calculated as orders which are closed and have all shipped line as shipped in full.
Order Tax Amount This metric shows order total tax amount.
Order To Shipment Lines Cycle Times This metric is calculated as average of difference between actual ship date and submitted date.
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.
Perfect Order % This metric is calculated as count of perfect orders divided by count of closed orders.
Perfect Order Count This metric is calculated as orders which are closed and have all shipped line as perfect order line.
Perfect Order Lines % This metric is calculated as perfect order lines divided by lines which are shipped.
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.
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.
Projected Gross Margin This metric is calculated as difference between extended selling price and extended cost.
Quantity Ordered This metric is calculated as sum of ordered quantity from lines and shows quantity in primary and transaction UOM.
Received Return Lines Count This metric is calculated as count of return order lines where material is received.
Reserved Quantity This metric is calculated as sum of reserved 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.
Return Lines Amount This metric is calculated as lines amount for line category as return.
Return Lines Closed Amount This metric is calculated as lines amount for line category as return for closed sales orders.
Return Lines Count Count of fulfillment lines with line category of return.
Return Lines Open Amount This metric is calculated as lines amount for line category as return for open sales orders.
RMA Delivered Quantity This metric is calculated as sum of RMA delivered quantity from lines and shows quantity in primary and transaction UOM.
Shipped Lines Amount This metric is calculated as amount for lines which are shipped.
Shipped Lines Count Count of shipped order lines.
Shipped Quantity This metric is calculated as sum of shipped quantity from lines and shows quantity in primary and transaction UOM.
Unit Cost This metric shows average unit cost at inventory organization level in primary UOM.
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.

Order Management - Sales Orders Holds

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

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