My Oracle Support Banner

Unconstrained Supply Planning: Supply Planning Diagnostic Scripts (Doc ID 2662876.1)

Last updated on MAY 21, 2023

Applies to:

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


 This document provides useful diagnostic scripts for Supply Planning.

Troubleshooting Steps

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
Troubleshooting Steps
 External Forecast Details
 Shipped Sales Order Details in Plan
 Open Sales Orders Details in Plan
 Time Fence Details
 Item Order Modifiers/Lead Time
 Supply Pegging Details (same level)
 Demands Pegged Early
 Unconstrained or Constrained Planning
 Query to check Item in a certain organization is included/Not-Included in the plan
 Query to check if supply is included in the plan
 Query to check if component operation is not part of the routing
 Query to check if UOM conversion for Resource UOM exists
 Supply Pegging Details (all level)
 Demand Pegging Details (All Level)
 Plan Order Dates (Including Calendar Used)
 Query to know the transit time, shipping method information used in a plan for a specified Sourcing Rule
 SnapShot query for resource availability
 Query to check whether weeks and periods overlap
 Query to check if we have any periods overlap
 Query to check if we have any month and quarter overlaps in fiscal calendar
 Query to check if we have loaded periods for manufacturing calendar
 Query to get Supplier Capacity for a given supplier name
 BOM Explosion Query
  How to get Plan tables
 Query to check list of processes submitted by parent Plan Run request

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