Search Results bom_cto_order_lines_s1

Overview

APPS.CTO_UPDATE_CONFIGS_PK is a configuration management package body in Oracle E-Business Suite that supports the Configure-to-Order (CTO) and Assemble-to-Order (ATO) model. Its central responsibility is to maintain, populate, and synchronize the configuration data that links sales order lines to configured bills of material, ATO model structures, and source organization assignments. In a CTO/ATO flow, when a customer orders a configurable item, the selections made by the user must be translated into concrete order lines, inventory components, and WIP supply relationships. This package provides the backend procedures that perform that translation and keep the configuration tables consistent with the originating order.

The package is classified as OTHER in the ETRM documentation and is registered as VALID in the APPS schema. It is documented against the Oracle EBS 12.1.1 and 12.2.2 object library and is not referenced by any other database object, meaning it acts as a high-level driver rather than a utility consumed by dependent code.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions. Their names indicate the following purposes:

• UPDATE_CONFIGS — The primary driver that updates configuration records for affected order lines.
• POPULATE_ALL_MODELS — Populates configuration data for all applicable ATO/CTO models.
• POPULATE_CAT_MODELS — Populates models belonging to a specific item category.
• POPULATE_CONFIG — Constructs the configuration record for a given order line.
• POPULATE_BCOLU_FROM_BAC — Derives BOM_CTO_ORDER_LINES_UPG (BCOLU) rows from BOM_ATO_CONFIGURATIONS data.
• POPULATE_CHILD_CONFIG — Handles configuration for child or nested configured items.
• POPULATE_LINK_TO_LINE_ID — Establishes the line identifier linkage between configuration and order lines.
• POPULATE_PLAN_LEVEL — Assigns planning level attributes to configured lines.
• POPULATE_WIP_SUPPLY_TYPE — Determines the WIP supply type for configured components.
• POPULATE_PARENT_ATO — Resolves and populates the parent ATO relationship.
• CONTIGUOUS_TO_SPARSE_BCOLU — Converts contiguous BCOLU storage into sparse form.
• WRITETOLOG — Writes diagnostic entries to the concurrent manager log.
• WRITE_CONFIG_STATUS — Records the current configuration status.
• UPDATE_ATP_ATTRIBUTES — Refreshes available-to-promise attributes on configured items.

Tables Accessed

The package reads and writes a range of configuration, order, and inventory tables:

• BOM_CTO_ORDER_LINES and its companion BOM_CTO_ORDER_LINES_S1 and BOM_CTO_ORDER_LINES_UPG — the primary staging tables for configured order lines.
• BOM_ATO_CONFIGURATIONS — the master source of ATO configuration definitions.
• BOM_BILL_OF_MATERIALS and BOM_INVENTORY_COMPONENTS — bills of material and component definitions.
• BOM_CTO_SRC_ORGS_B — source organization assignments for CTO.
• OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL — the originating sales order header and line records.
• MRP_ASSIGNMENT_SETS, MRP_ASSIGNMENT_SETS_S, and MRP_SR_ASSIGNMENTS — planning assignment data.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, and MTL_ITEM_CATEGORIES — item master and category data.

Usage Notes

CTO_UPDATE_CONFIGS_PK is typically invoked from CTO/ATO order processing flows, either through concurrent programs (as suggested by FND_REQUEST, FND_CONC_GLOBAL, and FND_FILE dependencies) or directly from custom extension code. It relies on standard EBS APIs such as FND_API, FND_MSG_PUB, CTO_MSG_PUB, CTO_MSUTIL_PUB, and CTO_UTILITY_PK for message handling and utility operations, and references OE_DEBUG_PUB and CTO_CONFIG_ITEM_PK for item and debugging support. Because it is not referenced by any other database object, callers should invoke its procedures explicitly and be aware that it manipulates persistent configuration staging tables directly.