My Oracle Support Banner

Unconstrained Supply Planning: Supply Planning Measures Common Issues and FAQ (Doc ID 2672548.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Oracle Supply Planning Cloud Service - Version and later
Information in this document applies to any platform.


 This document provides information about Supply Planning Measures Common Issues and Frequently asked questions (FAQ) .


The functionality described in this document is applicable to Fusion Supply Planning Cloud.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Frequently Asked Questions
 Is there a list of predefined measures for Supply Chain Planning Cloud Products?
 How is the measure Total End Item Cost calculated?
 What is logic for Revenue and Gross Margin Calculation in Supply Planning?
 How is Inventory Turn Calculated?
 How to Highlight and Lock the cells for Weekend (Saturday & Sunday) for Seeded & User Defined Measures.
 What are the measures used to calculate the 'Revenue And Margin' Infotile?
 How To Review The Past Due Sales Orders In Material Plan?
 How to view Buy Planned Order and Purchase Order information by Supplier & Supplier Site
 Is there a suggested method to display the measures from the Material Plan by the "as-is" date, i.e. the way the PO dates are shown as of that point in time?
 How is Average Daily Demand Calculated ?
 How to Verify Value for Reserved Supply Seeded Measure
 How the "Fill Quantity" measure is calculated
 How to visually identify editable measures?
 How "Obsolete On Hand" measure is calculated?
 How "Total Excess" measure is calculated?
 How measure "Demand Within Excess Horizon" is calculated?
 How measure "Demand Within Obsolescence Horizon" is calculated?
 How measure "Excess on Hand" is calculated?
 How measure "Value of Excess on Hand" calculated?
 How measure "Excess on Order" is calculated?
 How measure "Value of Excess on Order" is calculated?
 What Is the Formula for Projected Onhand (POH)?
 How to see previous periods demand information using Material Plan?
 Common Issues & Errors
 Projected Available Balance (PAB) is not considering the Scheduled Receipts.
 Measure data in table MSC_MEASURE_DATA not reflecting recent changes. Do we have any dynamic table in which recent values of measures reside after immediate change in Pivot table?
 Scheduled Receipt and Purchase Order in different buckets
 Shipping Cost Measure Does Not Calculate & Display Any Value In Supply Plan.
 Sales Order quantities not included in Total Demand measure values in custom table but available in seeded material plan table
 Measure independent demand does not include configured sales orders
 Audit Trail of Measure Updates does not display Planned Order updated in Supplies and Demand.
 Consensus forecast measure value not populated in supply plan output when S&OP plan is demand schedule.
 Days of Supply analysis graph is showing error

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.