Search Results cto_item_pk




Overview
Explore in AI Chat

Overview

CTO_ITEM_PK is a PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Configure-to-Order (CTO) functionality. Its primary business purpose is to create and manage the inventory items that represent configured products within a CTO sales order. When a customer orders a configurable model, the configuration selected from Oracle Configurator must be translated into concrete, order-specific item definitions that Oracle Order Management, Bills of Material, and inventory processes can act upon. CTO_ITEM_PK performs this translation by creating the ordered item instances, associating them with their parent model and order line context, and linking them into the BOM configuration hierarchy.

The package sits at the intersection of Order Management and Bills of Material. It is classified as an "OTHER" API in the ETRM repository, meaning it is an internal package rather than a formally published open interface. It is marked VALID and is referenced by several other CTO packages, indicating it plays a foundational role in the CTO processing chain.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within CTO_ITEM_PK:

  • CREATE_AND_LINK_ITEM — Creates a single configured item and links it to the relevant CTO order line and BOM configuration structures. This is the granular building block used to instantiate one component or model instance at a time.
  • CREATE_ALL_ITEMS — Creates all items required for a given configuration in a single operation, iterating across the configuration hierarchy to instantiate every needed item rather than a single element.
  • PERFORM_MATCH — Performs matching logic, presumably resolving or matching configured items against existing inventory, model definitions, or order line references so that the newly created items are correctly aligned with existing structures.

The metadata does not document parameter lists for these routines, so callers must be aware that these are internal procedures whose signatures are defined by the package specification and are not part of a published interface contract.

Tables Accessed

CTO_ITEM_PK operates against a focused set of tables, accessed via APPS synonyms:

The direct dependency listing shows a reference to BOM_CTO_ORDER_LINES, confirming that the primary read/write target is the CTO order line data.

Usage Notes

CTO_ITEM_PK is not intended for direct invocation by end users or external interfaces. It is invoked internally by other CTO packages: CTO_MATCH_AND_RESERVE, CTO_WORKFLOW, and CZ_BOM_CONFIG_EXPLOSIONS_PKG all reference it. The typical execution path runs during CTO order processing — when a configuration is exploded via CZ_BOM_CONFIG_EXPLOSIONS_PKG, the workflow orchestrated by CTO_WORKFLOW calls on CTO_ITEM_PK to materialize the configured items, and CTO_MATCH_AND_RESERVE subsequently matches and reserves them. Because it writes to MTL_SYSTEM_ITEMS, callers must ensure proper item validation and organization setup. Customizations should avoid calling this package directly and instead extend the supported CTO workflow mechanisms, since its signature and behavior are subject to change across EBS releases.