Search Results create_config_reservation

Overview

CTO_MATCH_AND_RESERVE is an Oracle Order Management (OM) technical package body owned by APPS and classified under ETRM as "OTHER." Its documented purpose, per the source header, is to create a package holding the procedures invoked from the Match and Reserve menu option on the Order Entry "Enter Orders" form. In Configure-to-Order (CTO) and Assemble-to-Order (ATO) flows, an order line representing a configuration must be linked to a specific configuration item before Inventory quantity can be evaluated and reserved. This package performs that linkage, drives the availability inquiry against Inventory's APIs, and, where the configuration line resolves to a reservable item, creates the reservation. The header notes that match_inquiry checks eligibility, links the order line to a configuration item by matching oe_order_lines_all against bom_ato_configurations, and returns TRUE when available-to-reserve quantity exists. Historical fixes show the package also rolls up purchase price, updates config line status after a matched item is linked, and returns zero available quantity for drop-shipped items (Bugfix#2342412, #2367720).

Key Procedures and Functions

• CREATE_CONFIG_RESERVATION — The reservation creation routine, and the object most commonly targeted by searches such as "create_config_reservation." It is invoked to establish a reservation for a matched CTO/ATO configuration line once a configuration item has been identified and availability confirmed. It is the counterpart of the eligibility and linking logic performed during match inquiry.
• CONFIG_LINE_EXISTS — A validation function used to determine whether the order line is already associated with a configuration item. Its result governs whether the package reuses an existing config item for the available quantity inquiry or attempts a fresh match between oe_order_lines_all and bom_ato_configurations.
• FAILS — The standardized error-handling callback, invoked when a package procedure raises an exception so that failure context can be surfaced through the Oracle EBS message/notification framework.

Three procedures/functions are documented for this object in ETRM 12.2.2; parameter signatures are not reproduced in the metadata and are therefore not enumerated here.

Tables Accessed

• OE_ORDER_LINES_ALL, OE_ORDER_HEADERS_ALL, OE_TRANSACTION_TYPES_TL — Source of the order line, its header, and transaction type context used to determine match/reserve eligibility.
• BOM_CTO_ORDER_LINES, BOM_CTO_SRC_ORGS_B — CTO configuration linkage and source organization definition for the configuration structure.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, MTL_PARAMETERS, MTL_SALES_ORDERS — Item attributes of the matched configuration item and Inventory setup/organization parameters used in the availability and reservation logic, including sales order reference for reservations.
• BOM_CALENDAR_DATES — Calendar validation used when assessing scheduling/availability.
• FND_LANGUAGES — Language context for translated descriptive lookups.
• PLITBLM — The PL/SQL index-by table used for bulk message handling and error notification.

Usage Notes

The package is primarily invoked from the Order Management Enter Orders form's Match and Reserve menu for ATO/CTO lines, and is referenced by four other packages within the EBS codebase. Because it is not formally classified as a Public API, it should be treated as an internal OM utility: custom code that requires configuration reservation behavior should generally call the documented Order Management APIs rather than invoking CREATE_CONFIG_RESERVATION directly. The source header carries a standing "To Do" to finalize the error notification content, and it is registered with a ship-date revision of 2011/11/14 ($Header: CTOMCRSB.pls 120.3), indicating limited change activity across the 12.1.1 and 12.2.2 releases.