Results for “validate_link”

22 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CTO_MANUAL_LINK_CONFIG is an Oracle Application Object Library (APPS) PL/SQL package that supports the manual configuration linkage workflow used by Oracle Order Management when processing Configure-to-Order (CTO) and Assemble-to-Order (ATO) items. The package header identifies its primary business purpose through the Match and Reserve feature invoked from the Enter Orders form in Order Entry. When a user selects the Match and Reserve menu option against a model line, this package determines whether the order line is eligible for configuration matching and reservation, attempts to associate the line with the appropriate configuration item stored in the BOM ATO configurations repository, and then invokes Oracle Inventory availability logic to determine whether sufficient on-hand quantity exists to satisfy the reservation request.

The source header (CTOLINKS.pls, version 120.1, last updated June 21, 2005) establishes that this is a long-standing component of the Oracle Manufacturing application family, originally authored in May 1999. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema, which is significant for security and synonym resolution in an EBS environment.

Key Procedures and Functions

  • VALIDATE_LINK — This procedure validates the linkage between an order line and a matched configuration. It is responsible for confirming that the association between the sales order line and the corresponding configuration item in the ATO configuration tables is logically consistent and eligible for reservation. It forms the eligibility check referenced in the package description as the step that determines whether an order line "is eligible to be matched and reserved."
  • FAILS — This procedure handles failure outcomes arising from the matching or validation process. Given the original source comment "To Do: Handle Errors," the FAILS routine consolidates error reporting and, where applicable, raises notification information back to the calling form. It ensures that invalid or ineligible link attempts are surfaced to the user or logged for diagnosis rather than silently discarded.

Although the package header also documents an internal function named match_inquiry, only VALIDATE_LINK and FAILS are recorded as documented procedures in the ETRM metadata for release 12.2.2.

Tables Accessed

  • OE_ORDER_LINES_ALL — Stores the sales order line data. The package reads the model line identifier from this table to determine the top model and to check whether the line is already linked to a configuration item.
  • BOM_CTO_ORDER_LINES — Holds the CTO order line context in the Bills of Material schema. It is used to match the order line against bom_ato_configurations when establishing the configuration link.
  • MTL_SYSTEM_ITEMS — Provides item master attributes for the configuration item, confirming that the item is defined, enabled, and valid for the organization in which availability is being queried.
  • PLITBLM — A PL/SQL index-by table used internally as an in-memory structure for passing and collecting values during processing, particularly around error or message handling.

Usage Notes

CTO_MANUAL_LINK_CONFIG is invoked interactively from the Order Entry Enter Orders form when the Match and Reserve action is selected. It is also referenced by one other documented package, indicating reuse within a broader configuration management flow. The package is not typically scheduled as a standalone concurrent program; rather, it executes synchronously in response to user action. Customizations that call this package directly should respect its AUTHID CURRENT_USER declaration and ensure that the calling schema has appropriate synonyms and privileges on OE_ORDER_LINES_ALL, BOM_CTO_ORDER_LINES, and MTL_SYSTEM_ITEMS.