Search Results config_line_exists

Overview

APPS.CTO_MATCH_AND_RESERVE is an Oracle E-Business Suite PL/SQL package that supports the Configure-to-Order (CTO) matching and reservation flow within Order Management. It is invoked from the Match and Reserve menu of the Enter Orders form in Order Entry, and its purpose is to determine whether an ATO (Assemble-to-Order) model order line can be matched to an existing configuration item and, if so, whether that configuration has quantity available to reserve.

The package header dates to release 11i-era source (CTOMCRSS.pls, version 120.1), and the package remains documented in ETRM for 12.1.1 and 12.2.2 as an OTHER-classified API owned by APPS. The core function, match_inquiry, performs three sequential checks: it validates that the order line is eligible for match and reserve; it resolves the configuration item by checking whether the line is already linked to a configuration and, if not, by matching against bom_ato_configurations; and it then calls Inventory's available quantity API to determine whether on-hand and available-to-reserve supply exists for that configuration. Where quantity is available to reserve, the inquiry returns true.

Key Procedures and Functions

ETRM documents three program units within this package:

• CONFIG_LINE_EXISTS — Determines whether a configuration line already exists for the order line under evaluation. This is the logic that underlies the match step: before the package attempts to match a configuration from oe_order_lines to bom_ato_configurations, it checks whether an existing configuration item association is already present. This function is the direct referent of the "config_line_exists" search term and is the entry point most commonly examined when diagnosing CTO match behavior.
• CREATE_CONFIG_RESERVATION — Creates the reservation against the matched configuration, applying the reserved quantity to the configuration item once matching and availability have been confirmed. This is the write-side counterpart to the inquiry logic.
• FAILS — A utility routine used within the package's error handling path. It is invoked when a validation or processing step cannot be satisfied, returning control to the calling form so that an appropriate message can be surfaced to the user.

Parameter lists are not reproduced here; the package metadata documents unit names and purposes only.

Tables Accessed

The package operates against a broad set of Order Management, Bills of Material, and Inventory tables, referenced through APPS synonyms:

• BOM_CTO_ORDER_LINES and BOM_CTO_SRC_ORGS_B — CTO-specific order line and source organization data used during configuration matching and sourcing.
• BOM_CALENDAR_DATES — Calendar data used when evaluating dates associated with matching and reservation.
• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_TRANSACTION_TYPES_TL — Order header, line, and transaction type information used to identify the order line and validate its eligibility.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, MTL_PARAMETERS, and MTL_SALES_ORDERS — Item definition, key flexfield, parameter, and sales order reference data used to resolve the configuration item and support the availability inquiry.
• FND_LANGUAGES — Language reference data, typically for translated lookups or messages.
• PLITBLM — The standard PL/SQL table used for message handling in EBS APIs.

Usage Notes

CTO_MATCH_AND_RESERVE is not a standalone concurrent program. It is invoked interactively through the Match and Reserve menu in the Enter Orders form, where match_inquiry drives the availability inquiry presented to the user. Because the package is documented in ETRM and referenced by four other packages, it is also a legitimate dependency for custom CTO extensions; however, direct calls should be limited to code that replicates the standard Order Entry match-and-reserve flow, since the package assumes order line and configuration context established by the form. In 12.1.1 and 12.2.2 the package resides in the APPS schema and should be accessed through APPS synonyms only.