Search Results msc_orders_col_v




Overview
Explore in AI Chat

Overview

APPS.MSC_REL_PLAN_PUB is a public PL/SQL package in the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It serves as the planning engine release interface, responsible for converting planned supply recommendations—planned orders, discrete jobs, repetitive schedules, requisitions, and lot-based jobs—into executable transactional records in the source execution systems. The package is central to the "release" step of the plan-to-execute cycle, where approved planner recommendations are written back into inventory, work-in-process, purchasing, and order management as real, actionable documents.

The object is classified as a PUB (public) API package, confirming that its interface is intended for external invocation by concurrent programs, workflows, and other planning packages rather than being an internal implementation detail. It is stored in the APPS schema and carries a VALID status in the documented environments (12.1.1 / 12.2.2).

Key Procedures and Functions

The package exposes 33 documented procedures and functions. The primary release entry point is MSC_RELEASE_PLAN_SC, which drives the release of a planning schedule into downstream execution. Supporting load routines include LOAD_MSC_INTERFACE, which stages planning data into the MSC interface tables, and the family of work-order load procedures: LOAD_WIP_DISCRETE_JOBS, LOAD_OSFM_LOT_JOBS, and LOAD_REPETITIVE_SCHEDULES, each responsible for generating the corresponding manufacturing execution records.

Rescheduling is handled by RESCHEDULE_WIP_DISCRETE_JOBS, RESCHEDULE_OSFM_LOT_JOBS, RESCHEDULE_PO, and RESCHEDULE_PO_WF, which update dates and quantities on existing discrete jobs, lot jobs, and purchase orders, with RESCHEDULE_PO_WF supporting the workflow-enabled purchasing path. Purchasing intake is served by LOAD_PO_REQUISITIONS.

A set of utility functions supplies planning arithmetic and attribute resolution: GET_CAL_DATE (calendar date resolution), GET_COPRODUCT_QTY and GET_REV_CUM_YIELD (yield and co-product quantity calculations), GET_REV_CUM_YIELD_DISC and GET_REV_CUM_YIELD_DISC_COMP (discrete-job variants of reverse cumulative yield), GET_USAGE_QUANTITY, GET_WIP_SUPPLY_TYPE, GET_MODELED_SR_TP_ID, GET_MODELED_TP_SITE_CODE, and DECODE_SALES_ORDER_NUMBER. These functions support the transformation and validation logic required during load and reschedule operations.

Tables Accessed

The package reads and writes through APPS synonyms against a range of ASCP and execution tables. Planning work and supply data are drawn from MSC_DEMANDS, MSC_BOMS, MSC_BOM_COMPONENTS, MSC_COMPONENT_SUBSTITUTES, MSC_ITEM_ATTRIBUTES, MSC_ITEM_ID_LID, and MSC_ITEM_SUPPLIERS. Calendar processing relies on MSC_CALENDAR_DATES. Resource and routing data come from MSC_DEPARTMENT_RESOURCES and MSC_DEPT_RES_INSTANCES. Exception output is stored in MSC_EXCEPTION_DETAILS. Purchasing release uses MRP_ORG_TRANSFER_RELEASE. Instance and concurrent processing metadata are read from MSC_APPS_INSTANCES, FND_CONCURRENT_PROGRAMS, and FND_CONCURRENT_REQUESTS, with FND_PROFILE referenced for profile option lookups.

Usage Notes

MSC_REL_PLAN_PUB is invoked through the ASCP planner workbench release actions, associated concurrent programs, and Oracle Workflow activities. It is referenced by nine other packages—including MSC_EXP_WF, MSC_RELEASE_PK, MSC_RP_RELEASE_PUB, MSC_REL_WF, MSC_PLAN_RELEASE, and the package itself—as well as by the views MSC_ORDERS_V, MSC_ORDERS_COL_V, MSC_ORDERS_DRP_V, and MSC_ORDERS_DRP_COL_V. Notably, the user-searched view MSC_ORDERS_DRP_V depends on this package, reflecting its role in exposing planner-facing order data. Custom code should call only the documented public procedures, as internal package-body logic is not part of the supported interface.