Results for “cto_config_routing_pk”

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

Overview

APPS.CTO_CONFIG_ROUTING_PK is a PL/SQL package in the Oracle E-Business Suite Configure-to-Order (CTO) module. Its responsibility is to create and validate the routing (manufacturing operations) associated with configured items generated from a CTO model. When a user configures a model in Oracle Configurator or Order Management, the resulting configuration item requires a manufacturing routing that reflects the operations needed to assemble the configured parent and its option-class components. CTO_CONFIG_ROUTING_PK provides the packaged logic that generates those routing records for each CTO order line, ensuring that the configured item is manufacturable within the standard Bills of Material and Work in Process structures.

The package is classified as OTHER in the ETRM 12.2.2 metadata and is documented as VALID in the APPS schema. It sits alongside the broader CTO configuration-generation stack, including CTO_BOM_RTG_PK, which references this package.

Key Procedures and Functions

The package exposes two documented procedures:

• CHECK_ROUTING – Validates whether a routing already exists (or is required) for a given configured item or CTO order line. It is used during configuration generation to avoid duplicating routing records and to determine whether the CREATE_ROUTING_ML routine should be invoked.
• CREATE_ROUTING_ML – Creates the routing records for a configured item. The "_ML" suffix indicates that the procedure handles multi-language (translated) seeded data, so routing operation descriptions and related reference data are inserted in the appropriate language context. It writes into the BOM_OPERATIONAL_ROUTINGS family of tables and their interface/temporary counterparts.

Both procedures are internal APIs within the CTO generation flow rather than standalone user-facing entry points.

Tables Accessed

The package reads from and writes to the following documented tables (via APPS synonyms):

• BOM_OPERATIONAL_ROUTINGS, BOM_OPERATIONAL_ROUTINGS_S – the routing header and its translation table, where the configured item's routing is created.
• BOM_OPERATION_SEQUENCES, BOM_OPERATION_SEQUENCES_S, BOM_OPERATION_SEQUENCES_TEMP – operation sequence lines and their translations/temporary staging for the routing.
• BOM_OPERATION_RESOURCES, BOM_COMPONENT_OPERATIONS, BOM_SUB_OPERATION_RESOURCES, BOM_OPERATION_NETWORKS – resource assignments, component-to-operation links, sub-operation resources, and operation network detail associated with each operation.
• BOM_CTO_ORDER_LINES – identifies the CTO order lines for which routing must be generated.
• BOM_INVENTORY_COMPS_INTERFACE – interface table used when routing/component data is staged for import.
• BOM_CALENDAR_DATES – calendar data used for scheduling or validation of routing operations.
• MTL_SYSTEM_ITEMS, MTL_RTG_ITEM_REVISIONS, MTL_PARAMETERS – item master, routing item revision, and organization parameters that supply item/organization context.

Usage Notes

CTO_CONFIG_ROUTING_PK is normally invoked indirectly by the CTO configuration-generation process rather than being called directly by end users. It is referenced by CTO_BOM_RTG_PK and by its own package body, indicating that it is a supporting routine within the CTO BOM/Routing generation stack. In Oracle EBS 12.1.1 and 12.2.2, routing generation for configured items is triggered when a CTO configuration is instantiated for a sales order or work order — for example, during AutoCreate of work orders or when Oracle Configurator finalizes a configuration. Custom extensions or diagnostic scripts that need to regenerate routing for a configured item may call CHECK_ROUTING first, then CREATE_ROUTING_ML. Because it manipulates BOM routing tables directly, any custom invocation should be performed in a controlled environment with proper validation, as incorrect use can produce duplicate or inconsistent routing records for configured items.