Search Results msc_sch_wb




Overview
Explore in AI Chat

Overview

ORDER_SCH_WB is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Order Management and Advanced Supply Chain Planning scheduling infrastructure, providing the shared workbench ("WB") logic that supports available-to-promise (ATP) processing, scheduling, and supply/demand resolution across the EBS order fulfillment and planning modules.

The package sits at a foundational layer of the scheduling stack. ETRM metadata classifies it as a package in VALID status with an API classification of OTHER, meaning it is an internal utility routine rather than a public, supported open interface. Its primary consumers are the MSC (Advanced Planning) ATP family of packages and the OE (Order Management) availability routines, indicating that ORDER_SCH_WB centralizes scheduling logic so that both the planning engine and the order entry forms operate against a consistent timing and availability model.

Key Procedures and Functions

The ETRM metadata documents 16 procedures and functions. Notable ones include:

  • GET_SUPPLY_SOURCES_LOCAL — retrieves the supply sources applicable to the local organization context used during scheduling.
  • GET_ATP_RESULT — returns available-to-promise results for the requested item/date criteria.
  • GET_ATP_RULE_NAME — resolves the ATP rule name applicable to the current scheduling context.
  • GET_ASSIGNMENT_SET — identifies the assignment set associated with the ATP or sourcing setup.
  • MRP_TIMING — applies MRP-based timing logic to scheduling calculations.
  • ATP_DEBUG — provides diagnostic output for ATP processing.
  • GET_PERIOD_ATP_STRINGS — builds the period-level ATP string representations used in availability display and calculation.
  • CALC_EXCEPTIONS — computes scheduling or ATP exceptions.
  • PIPE_UTILITY — provides pipelined or delimiter-based utility handling for internal data processing.
  • SET_SESSION_ID — establishes the session identifier used by dependent scheduling calls.
  • GET_MASTER_ORG — returns the master organization for the current item/organization context.
  • DELETE_LINES — removes transient scheduling work lines.
  • GET_SUPPLY_DEMAND_SOURCE_NAME — resolves display names for supply and demand sources.
  • EXTEND_OTHER_COLS — extends a record or collection with additional columns required by callers.
  • COMMIT_DB — performs an explicit database commit for changes made within the package's processing.
  • GET_PROFILE — wraps FND_PROFILE lookups for scheduling-related profile options.

Tables Accessed

The ETRM excerpt does not enumerate base tables directly; it documents dependencies on APPS.FND_GLOBAL, APPS.FND_PROFILE, and SYS.STANDARD. FND_GLOBAL supplies the runtime context (user ID, responsibility, organization) that governs which supply sources, ATP rules, and assignment sets are visible. FND_PROFILE provides the profile option values consumed by GET_PROFILE. Any persistent scheduling results and exceptions are written through the MSC and OE scheduling tables owned by the calling packages.

Usage Notes

ORDER_SCH_WB is not intended to be called directly from custom code. ETRM records that it is referenced by 12 other packages, including MSC_ATP_24X7, MSC_ATP_EXCEPTIONS, MSC_ATP_FUNC, MSC_ATP_PEG, MSC_ATP_PROC, MSC_ATP_PUB, MSC_ATP_PVT, MSC_BAL_UTILS, MSC_SATP_FUNC, MSC_SCH_WB, OE_OE_AVAILABILITY, and OE_OE_PRICING_AVAILABILITY. This dependency graph demonstrates that it is invoked indirectly whenever ATP is calculated, when the 24x7 ATP engine runs, during planning workbench scheduling, and when order entry forms display item availability. The user search term "msc_sch_wb" reflects this relationship: MSC_SCH_WB is one of the direct callers of ORDER_SCH_WB. Because the package performs explicit commits through COMMIT_DB, custom code should not wrap it in a transaction that assumes rollback control.