Search Results create_in_src_orgs

Overview

CTO_BOM_RTG_PK is a PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Configure-to-Order (CTO) and Assemble-to-Order (ATO) manufacturing model. Its principal business function is the automated creation of bills of material and routings for configured items, along with ATP-related processing and the propagation of those structures into source organizations. When a customer orders a configured product, the CTO workflow must synthesize a manufacturing definition unique to that configuration. This package provides the programmatic mechanism that builds those BOM and routing records in the appropriate organizations, enabling the order to be fulfilled as a discrete, buildable assembly.

The package is classified as OTHER under the API taxonomy and is not documented as a formally supported public interface. It operates as an internal building block called by higher-level CTO processing packages rather than as a directly invoked end-user API.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within the package:

• CREATE_ALL_BOMS_AND_ROUTINGS — The primary routine responsible for generating the complete set of bills and routings required for a configured item or model. It drives the creation of manufacturing structures across the relevant organizations.
• CREATE_IN_SRC_ORGS — Creates the BOM and routing definitions within source organizations, supporting multi-organization environments where a configured assembly must be defined in organizations other than the primary one.
• UPDATE_ATP — Handles updates related to Available-to-Promise processing, reflecting the impact of newly created or modified manufacturing structures on ATP calculations for the configured item.

No parameter lists are documented in the available metadata, and none are inferred here.

Tables Accessed

The package reads and writes across several functional areas, referencing the following tables through APPS synonyms:

• BOM and model definition: BOM_ATO_CONFIGURATIONS, BOM_CTO_MODEL_ORGS, BOM_CTO_ORDER_LINES, BOM_CTO_SRC_ORGS_B, BOM_BILL_OF_MTLS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE — used to resolve configuration, model organization, and source organization context and to stage interface records for BOM and inventory component creation.
• Costing: CST_COST_TYPES, CST_ITEM_COSTS, CST_ITEM_COST_DETAILS — consulted when cost information must accompany the created structures.
• Inventory and planning: MTL_MATERIAL_TRANSACTIONS, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_PARAMETERS, MTL_PLANNERS — support organization parameters, planner defaults, and transaction staging.
• Calendar and user context: BOM_CALENDAR_DATES and FND_USER — provide scheduling and audit context.

Usage Notes

CTO_BOM_RTG_PK is an internal dependency rather than a directly invoked API. ETRM shows it is referenced by three other packages: CTO_MATCH_AND_RESERVE, CTO_WORKFLOW, and CZ_BOM_CONFIG_EXPLOSIONS_PKG. This confirms its role within the broader CTO engine — invoked during configuration match-and-reserve processing, CTO workflow execution, and configuration explosion.

In typical EBS 12.1.1 and 12.2.2 deployments, the package is triggered indirectly when a configured sales order is processed and a manufacturing structure must be generated or propagated across organizations. Customizations should not call it directly; supported extension points lie in the higher-level CTO APIs and workflow activities. Any direct invocation carries upgrade risk because the metadata records no supported parameter interface.