Search Results atp_debug

Overview

MSC_SCH_WB (Supply Chain Scheduling Workbench) is an Oracle Applications package body owned by APPS that supports the Oracle Advanced Supply Chain Planning scheduling workbench and Available-to-Promise (ATP) processing within Oracle E-Business Suite 12.1.1 and 12.2.2. The package provides the server-side logic required to assemble ATP supply and demand records, resolve supply sources, translate internal identifiers into user-facing labels, and manage temporary scheduling data used by the scheduling workbench UI. It acts as a bridge between planning data stored in MSC and MRP tables and the ATP engine exposed through MRP_ATP_PUB.

The central routine, GET_ATP_RESULT, reads records from MRP_ATP_SCHEDULE_TEMP for a given session, applies override logic for firm sources and dates, and passes the resulting supply/demand, period, and detail structures to the ATP public API. This makes the package integral to online ATP inquiry and order scheduling from within the workbench.

Key Procedures and Functions

• GET_SUPPLY_SOURCES_LOCAL — Resolves the list of valid supply sources (organizations) local to the current context, used to populate and validate supply source references during scheduling.
• GET_ATP_RESULT — The primary entry point that collects ATP records for a session and forwards them to the ATP engine, honoring override flags for source organization and ship dates.
• CLEANUP_DATA — Removes temporary working rows associated with a completed or abandoned session.
• SET_SESSION_ID — Establishes the session identifier used throughout the workbench processing.
• GET_ALLOC_RULE_VARIABLES — Retrieves allocation rule parameters applied during ATP and scheduling calculations.
• GET_ATP_RULE_NAME — Returns the descriptive name of an ATP rule for display and validation.
• GET_MSC_ASSIGN_SET / GET_ASSIGNMENT_SET — Fetch assignment set definitions used to scope planning and sourcing behavior.
• GET_LABEL — Resolves display labels for workbench fields.
• MRP_TIMING — Performs timing and calendar-related calculations.
• ATP_DEBUG — Emits diagnostic messages when the MSC_ATP_DEBUG profile is enabled.
• GET_PERIOD_ATP_STRINGS — Builds period-based ATP display strings.
• CALC_EXCEPTIONS — Computes exception conditions surfaced to the user.
• PIPE_UTILITY — Supports pipelined/row-by-row data extraction.
• GET_MASTER_ORG — Determines the master organization for the session.
• DELETE_LINES, COMMIT_DB, EXTEND_OTHER_COLS — Manage temporary line data, transaction control, and column extension.
• GET_SUPPLY_DEMAND_SOURCE_NAME, GET_PROFILE — Resolve source names and profile option values.

Tables Accessed

The package reads and writes several MSC and MRP tables through APPS synonyms. MRP_ATP_SCHEDULE_TEMP, MRP_ATP_SCHEDULE_TEMP_S, and MRP_ATP_DETAILS_TEMP hold session-scoped ATP scheduling data. MRP_ASSIGNMENT_SETS and MSC_ASSIGNMENT_SETS provide sourcing and planning scope. Calendar tables — BOM_CAL_WEEK_START_DATES, BOM_PERIOD_START_DATES, MRP_SCHEDULE_DATES, MSC_CAL_WEEK_START_DATES, and MSC_PERIOD_START_DATES — supply timing boundaries for period ATP. MTL_ATP_RULES and MTL_PARAMETERS define ATP rules and organization parameters. MSC_APPS_INSTANCES, MSC_DEMAND_CLASSES, and MSC_TRADING_PARTNERS supply instance, demand classification, and trading partner data.

Usage Notes

MSC_SCH_WB is invoked primarily from the scheduling workbench forms and supporting concurrent programs, and is referenced by 37 other packages. It should not be called directly from custom code without understanding session setup (SET_SESSION_ID) and cleanup (CLEANUP_DATA) requirements. Debugging is controlled through the MSC_ATP_DEBUG profile option, which enables verbose output from ATP_DEBUG.