Search Results chv_load_orders




Overview
Explore in AI Chat

Overview

The APPS.CHV_LOAD_ORDERS package is a PL/SQL stored program unit within the Oracle E-Business Suite 12.1.1 and 12.2.2 APPS schema that supports the Oracle Supply Chain Management "Supply Chain Planner" / build schedule feature. Its principal responsibility is the population and refreshing of order data used by the planning engine within the CHV (Supply Chain Planning) module — specifically loading item orders, planned orders, and approved requisitions into staging structures that the planning logic consumes. The package is classified as an "OTHER" API classification object, meaning it is not an open public interface but an internal processing routine invoked by other planning components, most notably CHV_BUILD_SCHEDULES. It has a dependency on the SYS.STANDARD package as its only documented referenced object, and it is referenced by one other package.

Key Procedures and Functions

The ETRM metadata documents seven stored program units, four of which are named in the excerpt:

  • NAME — a helper routine, likely used to resolve or return the object/record identifier during order loading processing.
  • LOAD_ITEM_ORDERS — loads item-level order data into the planning staging tables. This is the primary routine responsible for placing discrete item order records into CHV_ITEM_ORDERS and its interface table CHV_ITEM_ORDERS_S.
  • LOAD_PLANNED_ORDERS — loads planned order suggestions, typically derived from the MRP planning engine output, into the CHV planning structures.
  • LOAD_APPROVED_REQUISITIONS — loads approved purchase requisitions (both headers and lines) so that approved demand is visible to the planning engine.

The remaining three program units are not individually named in the supplied metadata and are presumed to be internal helper routines supporting the loading operations. No parameter lists are documented; per ETRM convention these routines are callable only within the package's private scope unless exposed via the package specification.

Tables Accessed

The package reads from and writes to the following documented tables via APPS synonyms:

  • CHV_ITEM_ORDERS and CHV_ITEM_ORDERS_S — the primary targets where loaded item order records are stored; the _S suffix indicates a shadow/interface table used during load transactions.
  • MRP_RECOMMENDATIONS — the planning engine's recommendation table, read to determine planned order quantities and dates.
  • MTL_SUPPLY — the supply staging table used by the planning engine to compute available supply.
  • PO_HEADERS — purchase order headers, read to obtain approved purchase commitments.
  • PO_REQUISITION_HEADERS and PO_REQUISITION_LINES — read to load approved requisition demand into the planning structures.

Usage Notes

CHV_LOAD_ORDERS is an internal utility package invoked programmatically rather than interactively. It is called from APPS.CHV_BUILD_SCHEDULES as part of the build schedule generation process, and it is also self-referential (it appears in its own "referenced by" list), indicating one procedure calls another within the package body. The package is not exposed through an Oracle Forms interface in the documented metadata. Typical invocation occurs during planning engine runs, MRP/MPS concurrent program execution, or custom extensions that require the CHV staging tables to be refreshed before downstream planning calculations. Because it writes directly to public planning tables, care should be taken to invoke it only within the supported planning cycle; ad hoc execution outside that context may produce inconsistent planning results. In EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and carries a VALID status, confirming it is compiled and available in the documented ETRM environment.