Search Results create_src_rules

Overview

BOM_CTO_SRC_ORGS is an APPS-owned database view in the Oracle E-Business Suite Bills of Material (BOM) module that serves the Configure-to-Order (CTO) sourcing rule engine. It presents the set of sourcing organizations associated with a configuration model line, combining organization-level defaults defined on the top model with model-line overrides. The view is part of the CTO "Auto Create Configuration Items" infrastructure, which drives the automatic generation of configured item bills of material, routing, and sourcing rules at order entry time.

Because the sourcing rule records physically reside in the concealed base table BOM_CTO_SRC_ORGS_B, the view acts as an integration and reporting layer. It applies DECODE logic so that each attribute resolves to the model-level value from BOM_CTO_MODEL_ORGS when a group reference exists, and otherwise falls back to the line-level value on BOM_CTO_SRC_ORGS_B. This makes the view the authoritative read interface for reporting and for concurrent programs that evaluate the CREATE_SRC_RULES flag.

Underlying Base Objects

Per documented ETRM 12.2.2 metadata, the view is defined over two synonyms: BOM_CTO_MODEL_ORGS and BOM_CTO_SRC_ORGS_B, both owned by APPS. BOM_CTO_SRC_ORGS_B stores the per-line sourcing organization rows, keyed by LINE_ID and TOP_MODEL_LINE_ID. BOM_CTO_MODEL_ORGS stores model-level (top model) defaults keyed by GROUP_REFERENCE_ID. The join is expressed through a decode on BCMO.GROUP_REFERENCE_ID: when it is null, the view returns the line-level (BCSO) values; when populated, it returns the model-level (BCMO) values.

Key Columns

• LINE_ID — Identifier of the CTO source organization line (from BCSO).
• TOP_MODEL_LINE_ID — Reference to the parent top model line.
• GROUP_REFERENCE_ID — Resolved group reference; drives whether model or line attributes win.
• REFERNCE_ID — Reference identifier (note the documented misspelling in the column alias).
• CREATE_BOM / COST_ROLLUP / CREATE_SRC_RULES — Boolean-style flags controlling auto-creation of BOM, cost rollup, and sourcing rules.
• CONFIG_ITEM_ID, MODEL_ITEM_ID — Configured item and model item identifiers.
• ORGANIZATION_ID, RCV_ORG_ID, ORGANIZATION_TYPE — Target sourcing/shipping organization and its type.
• RANK — Priority ranking of the sourcing organization.
• Audit columns (REQUEST_ID, PROGRAM_ID, CREATED_BY, LAST_UPDATED_BY, etc.) resolve from the effective record.

Common Use Cases and Queries

The primary scenario matching the search term create_src_rules is verifying which CTO lines have sourcing rule auto-creation enabled. A typical query is:

SELECT LINE_ID, TOP_MODEL_LINE_ID, ORGANIZATION_ID, RANK, CREATE_SRC_RULES FROM APPS.BOM_CTO_SRC_ORGS WHERE CREATE_SRC_RULES = 1;

Developers and support analysts also use the view to reconcile differences between model-level and line-level sourcing settings, to troubleshoot sourcing rules that were not generated during order entry, and to confirm RCV_ORG_ID values prior to shipping. Because BOM_CTO_SRC_ORGS respects the documented model-versus-line resolution, it should be preferred over querying the base tables directly when diagnostic reporting is required.