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 11.13.17.05.0 and laterOracle Fusion Planning Central Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.
Purpose
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
| Purpose |
| 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 |