Skip to the content.

MSC Plan Order Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

MSC Plan Order Upload ===================== Upload to action Plan Order recommendations.

This upload can be used to either select for release or release Plan Order Recommendations from ASCP planning instances.

Currently supported recommendations that can be actioned by this upload are:

Additionally, it allows the user to amend the recommended Implement Date and/or Quantity.

In the generated Excel the user can amend the following columns:

Update Release Status can be either

This is determined by the Report Parameter: Upload Mode

For plan orders not yet selected for release, to amend the implement date and/or implement quantity, the Update Release Status column must also be specified as ‘Select for Release’ or ‘Release the Order’ against the Plan Order. If a plan order is already selected for release, then the user can amend the implement date and/or quantity in the generated excel without specifying a value in the Update Release Status column.

The report parameter Upload mode determines the allowable action to be taken against the plan order recommendations in the upload (‘Select for Release’ or ‘Release the Order’)

The report parameter Auto Populate Release Status if set to Yes, will automatically populate the ‘Update Release Status’ column and set the status to pending validation against all downloaded plan order recommendations in the generated excel. In this scenario, the generated excel can be saved and uploaded without the user needing to manually review and select the specific plan orders to be updated in the generated excel

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Auto Populate Release Status, Planning Instance, Plan, Organization, Source Organization, Category Set, Category, Item, Explode Assemblies, Project, Planner, Buyer, Make/Buy, Order Type, Action, Selected for Release, Suggested Due From, Suggested Due To, Show Item Descriptive Attributes

Oracle EBS Tables Used

msc_system_items, msc_item_categories, msc_category_sets, msc_boms, msc_bom_components, msc_safety_stocks, msc_supplies, msc_apps_instances, msc_plans, msc_plan_organizations

Report Categories

Enginatics, Upload

MSC Pegging Hierarchy, MSC Plan Orders, MSC Horizontal Plan, MSC Vertical Plan, MSC Exceptions, MRP Plan Orders, CAC ICP PII Inventory and Intransit Value (Period-End), CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory Pending Cost Adjustment - No Currencies

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import MSC_Plan_Order_Upload.xml
SQL Source MSC Plan Order Upload.sql
Full Report on Enginatics www.enginatics.com/reports/msc-plan-order-upload/

MSC Plan Order Upload - Case Study & Technical Analysis

Executive Summary

The MSC Plan Order Upload is a powerful tool that allows planners to “action” the recommendations from the ASCP plan in bulk. Instead of manually clicking “Release” on hundreds of planned orders in the Planner’s Workbench, users can download the recommendations to Excel, review/modify them, and upload the release actions back to Oracle.

Business Challenge

The “Planner’s Workbench” UI can be slow and cumbersome for mass updates.

Solution

The MSC Plan Order Upload bridges the gap between analysis (Excel) and execution (Oracle).

Key Features:

Technical Architecture

The tool uses a WebADI-style upload mechanism to update the plan tables.

Key Tables and Views

Core Logic

  1. Download: Retrieves Planned Orders based on criteria (Plan, Org, Planner).
  2. User Action: The user updates the “Update Release Status” column (e.g., to ‘Release’) and optionally modifies dates/quantities.
  3. Upload: The tool updates the corresponding records in MSC_SUPPLIES with the new status and values.
  4. Execution: A subsequent concurrent request (in Oracle) processes these marked records and generates the actual WIP Jobs or Purchase Requisitions.

Business Impact


© Enginatics GmbH