Search Results update_supdem_entries

Overview

MSC_X_HZ_UPDATE is an Oracle Applications (APPS) PL/SQL package shipped with Oracle Advanced Supply Chain Planning (ASCP), a component of the Oracle E-Business Suite value chain planning stack. The package resides in the MSC schema family and is classified in the ETRM repository as an API of type OTHER. Its single documented purpose is to synchronize supply and demand entries that originate from order capture and customer-facing source systems into the ASCP planning tables, particularly those tied to the HZ (Trading Community / customer) model.

The "$Header" comment in the source — MSCXHZUS.pls 120.1 2005/06/07 — establishes that the file lineage predates the 12.x releases and has been carried forward largely unchanged into 12.1.1 and 12.2.2. The name combines "MSC" (the ASCP schema prefix), "X" (indicating an extension or cross-reference utility rather than a core planning engine package), and "HZ" (the Trading Community Architecture customer tables). In practice, this package supports the collection and refresh cycle that moves customer-specific supply and demand data into the MSC_SUP_DEM_ENTRIES staging structures.

Key Procedures and Functions

The ETRM metadata documents exactly one callable program unit:

• UPDATE_SUPDEM_ENTRIES — The sole documented procedure. Its declared signature includes an error message output parameter (NOCOPY VARCHAR2) and a query identifier input parameter. The procedure refreshes or recalculates supply and demand entry records associated with a given planning query. Because a query identifier is accepted, the procedure is scoped to a specific plan or collection run rather than operating globally.

No public functions are documented. The procedure is exposed in the package specification, making it callable from SQL*Plus, concurrent program logic, or custom PL/SQL. The presence of an OUT NOCOPY error message suggests a standard EBS error-handling convention: the caller inspects the message buffer and raises or logs an exception if it is populated.

Tables Accessed

The documented table references fall into several functional groups:

• Supply/demand core: MSC_SUP_DEM_ENTRIES and MSC_SUP_DEM_ENTRIES_S (the base table and its MLS/_S variant) are the primary targets of UPDATE_SUPDEM_ENTRIES.
• Customer/trading partner model: MSC_TRADING_PARTNERS, MSC_TRADING_PARTNER_MAPS, MSC_COMPANY_RELATIONSHIPS, MSC_ITEM_CUSTOMERS, and MSC_ITEM_SUPPLIERS resolve the customer and supplier identities attached to each entry.
• Item master: MSC_ITEMS and MSC_SYSTEM_ITEMS provide the planned item and system-item cross-reference.
• UI staging: MSC_HZ_UI_HEADERS and MSC_HZ_UI_LINES hold the header-and-line UI data that the procedure maps into planning entries.
• Calendar/refresh helpers: MSC_CALENDAR_DATES, MSC_CAL_WEEK_START_DATES, MSC_PERIOD_START_DATES, and MSC_CL_REFRESH_S supply date bucketing and refresh bookkeeping.

Usage Notes

MSC_X_HZ_UPDATE is not referenced by any other documented package ("Referenced by 0 other packages"), indicating it is an endpoint utility invoked externally rather than a shared subroutine. Typical invocation scenarios include ASCP collection and refresh concurrent programs, planning data manager processing that picks up HZ-sourced customer demand, and custom extensions written against the ASCP schema.

Because the package writes directly into MSC_SUP_DEM_ENTRIES staging, callers should invoke it only within the supported collection window and after dependent trading-partner and item data have been loaded. In 12.1.1 and 12.2.2 the package remains in the APPS schema and is executed with APPS credentials; direct modification is unsupported, and any customization should be layered through a wrapper rather than editing MSCXHZUS.pls.