Search Results bom_cto_model_orgs_s1

Overview

CTO_MSUTIL_PUB is a public PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports Configure-to-Order (CTO) sourcing and supply chain processing within Oracle Manufacturing. The package provides utility modules that populate and maintain intermediate working tables used during the configuration and sourcing of CTO model and configuration items. Its primary responsibilities include populating the temporary tables BOM_CTO_ORDER_LINES and BOM_CTO_SRC_ORGS, updating these tables with the configuration item identifier, and copying sourcing rule assignments from a model to its configuration item.

The package was originally created on 04-OCT-2003 by Sushant Sawant as part of the CTOMSUTB.pls module, and has since been maintained through a series of bug fixes addressing sourcing behavior across organizations, matched configuration transitions, and supply chain traversal for configured items. As a result of this evolution, the package embodies logic that governs how sourcing rules are resolved and propagated for configured items across multiple operating units and inventory organizations.

Key Procedures and Functions

The ETRM metadata documents sixteen public procedures and functions within this package. Notable ones relevant to item organization handling and sourcing include:

• GET_ALL_ITEM_ORGS — Returns the complete set of inventory organizations relevant to an item, supporting downstream sourcing and organization resolution logic. This is the entry point most commonly referenced by users searching for organization-level item data.
• GET_OTHER_ORGS — Retrieves organizations other than the current or primary organization, used to broaden the sourcing candidate set.
• GET_MASTER_ORGS — Identifies master organizations associated with the CTO processing context.
• POPULATE_SRC_ORGS and POPULATE_SRC_ORGS_UPG — Populate the sourcing organizations temporary table, with the UPG variant supporting upgrade scenarios.
• INSERT_VAL_INTO_BCSO and INSERT_ALL_INTO_BCSO — Insert sourcing organization records into the BOM_CTO_SRC_ORGS structure, including dropship, procure, and no-assignment-set cases.
• QUERY_SOURCING_ORG_MS — Queries sourcing organization assignments for matched configurations.
• INITIALIZE_ASSIGNMENT_SET — Initializes the assignment set used in sourcing rule generation.
• CREATE_SOURCING_RULES and CREATE_TYPE3_SOURCING_RULES — Create sourcing rules, including Type 3 rules applicable to specific supply chain configurations.
• SET_BOM_BATCH_ID — Establishes the batch identifier used across BOM processing operations.
• SYNCUP_ITEM_MEDIA_INDEX — Synchronizes the item media index following CTO processing.
• SWITCH_TO_OE_CONTEXT and SWITCH_CONTEXT_BACK — Manage operating unit context switching, ensuring Order Entry context is set appropriately and then restored.
• RAISE_EVENT_FOR_SEIBEL — Raises an event for the Service Enabled Item Business Event Layer (SEIBEL), enabling downstream subscribers to react to CTO processing events.

Tables Accessed

The package reads from and writes to a range of CTO and manufacturing tables via APPS synonyms. BOM_CTO_MODEL_ORGS and BOM_CTO_MODEL_ORGS_S1 hold model organization relationships, while BOM_CTO_ORDER_LINES and BOM_CTO_ORDER_LINES_UPG store intermediate CTO order line processing data. BOM_CTO_SRC_ORGS_B persists sourcing organization records. BOM_PARAMETERS supplies BOM configuration settings, and MTL_PARAMETERS and MTL_SYSTEM_ITEMS provide item and organization master data. Sourcing logic draws on MRP_ASSIGNMENT_SETS, MRP_SOURCING_RULES, MRP_SR_ASSIGNMENTS, MRP_SR_ASSIGNMENTS_S, MRP_SR_RECEIPT_ORG, and MRP_SR_SOURCE_ORG. FINANCIALS_SYSTEM_PARAMS_ALL is referenced for operating unit and financial system context.

Usage Notes

CTO_MSUTIL_PUB is typically invoked by other CTO and sourcing-related packages — the metadata indicates it is referenced by fourteen other packages — as well as by concurrent programs that process configured order lines and sourcing rule assignment. It may also be called from custom extensions that need to resolve item organizations or replicate model sourcing rules to configuration items. Because the package manages operating unit context internally through SWITCH_TO_OE_CONTEXT and SWITCH_CONTEXT_BACK, callers should not set conflicting contexts. Organizations running EBS 12.1.1 or 12.2.2 should ensure the corresponding CTO and MRP patches are applied, since several fixes to sourcing behavior across operating units and matched configuration transitions are embedded in the package history. The GET_ALL_ITEM_ORGS function is frequently queried for reporting and validation of item-organization combinations, and callers should expect it to honor the current CTO processing schema context.