Results for “pegging_flag”

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

Overview

CTO_SUBASSEMBLY_SUP_PK is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Configure-to-Order (CTO) manufacturing and supply processing. Its primary business function is to explode a top-level configured item into its child configurations and to create the work-in-process (WIP) subassembly jobs required to build those configured subassemblies. In the context of Oracle EBS 12.1.1 and 12.2.2, this package sits within the CTO supply chain feature set, bridging order management, bills of material, and work in process. It is classified as an OTHER API package, meaning it is invoked by Oracle's own CTO processing logic rather than exposed as a formal public open interface.

Key Procedures and Functions

The ETRM documentation lists two documented program units within the package:

• GET_CHILD_CONFIGURATIONS — Retrieves the child configuration items associated with a parent configured item. This unit is used to resolve the model structure hierarchy so downstream logic knows which configured subassemblies must be supplied or built.
• CREATE_SUBASSEMBLY_JOBS — Creates subassembly WIP jobs for the configured children identified during the explosion. It drives the generation of discrete jobs that manufacture the subassemblies required by the top-level configuration.

These two units operate as a pair: the first identifies children, the second generates the jobs to supply them.

Tables Accessed

The package reads and writes a broad set of CTO, BOM, WIP, and order management tables via APPS synonyms:

• BOM structure and routing: BOM_INVENTORY_COMPONENTS, BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_SEQUENCES, BOM_CALENDAR_DATES, BOM_PARAMETERS — used to validate and explode the bill and routing of configured assemblies.
• CTO supply workspaces: BOM_CTO_MLSUPPLY_MAIN_TEMP and BOM_CTO_MLSUPPLY_FLOW_TEMP — temporary staging tables for multi-level supply explosion.
• Item and WIP: MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, MTL_PARAMETERS, WIP_LINES, WIP_FLOW_SCHEDULES, WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_SCHEDULE_INTERFACE_S — source of item attributes and target of job creation.
• Order management: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL — order context driving the configuration demand.

Usage Notes

CTO_SUBASSEMBLY_SUP_PK is invoked by other CTO packages rather than directly by users. The ETRM metadata shows it is referenced by CTO_CHANGE_ORDER_PK, CTO_FLOW_SCHEDULE, CTO_WIP_UTIL, and by CTO_SUBASSEMBLY_SUP_PK itself (recursive internal calls). It is therefore part of Oracle's internal CTO supply and scheduling flow, reached during configuration change order processing and flow schedule generation. Custom development should not call this package directly; any extension should hook into supported CTO open interfaces or concurrent programs. Debugging typically involves enabling PL/SQL trace on the calling CTO program to observe GET_CHILD_CONFIGURATIONS and CREATE_SUBASSEMBLY_JOBS execution.