Search Results bom_mfg_routing

Overview

BOM_DEFAULT_RTG_HEADER is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the manufacturing routing domain, classified under the business entity BOM_MFG_ROUTING. Its stated purpose, as reflected in the package specification source (BOMDRTGS.pls), is to copy and default attribute values onto a Routing Header record. When an existing routing header record is supplied, any attribute that carries a null value or that was not provided by the caller is defaulted to an appropriate value. For create operations, where no prior (OLD) record exists, each attribute is defaulted independently, allowing a user to supply only minimal information for the operation to succeed. The package is declared AUTHID CURRENT_USER and is marked with a lifecycle status of active and a compatibility rating of S in the ETRM repository.

Key Procedures and Functions

The package exposes seven documented procedures and functions, which together implement its defaulting and lookup behavior:

• ATTRIBUTE_DEFAULTING — Performs the core defaulting of individual routing header attributes, resolving null or omitted values to appropriate defaults.
• ENTITY_ATTRIBUTE_DEFAULTING — Applies defaulting logic at the entity level, coordinating attribute defaulting for the routing header record as a whole.
• POPULATE_NULL_COLUMNS — Fills null columns on the routing header record with defaulted values, supporting both the create and update paths.
• GET_ROUTING_SEQUENCE — Retrieves the routing sequence value used to key or order routing header records.
• GET_CFM_ROUTING_FLAG — Returns the flag indicating whether the routing is associated with flow (CFM) manufacturing.
• GET_MIXED_MODEL_MAP_FLAG — Returns the flag relating to mixed-model map configuration for the routing.
• GET_CTP_FLAG — Returns the configure-to-order (CTP) flag value applicable to the routing header.

These routines operate on the exposed and unexposed routing header record types defined in the companion BOM_RTG_PUB package, with the defaulted values returned through an IN OUT NOCOPY parameter.

Tables Accessed

The package reads and writes through APPS synonyms against the following base tables:

• BOM_OPERATIONAL_ROUTINGS — The primary routing header table, holding routing definitions against which defaults are applied and column values populated.
• BOM_OPERATIONAL_ROUTINGS_S — The corresponding intersection or supplemental routing table, accessed alongside the operational routings entity.
• MTL_SYSTEM_ITEMS — The item master, consulted to validate and derive item-related default values for the routing header.

Usage Notes

BOM_DEFAULT_RTG_HEADER is a private API, not intended for direct invocation by external custom code, but rather as an internal service consumed by the public routing APIs and by Oracle forms and concurrent programs that create or maintain manufacturing routings. The ETRM metadata records that it is referenced by four other packages, confirming its role as a shared defaulting utility within the BOM routing stack. Because defaulting is centralized here, callers can supply minimal routing header data and rely on the package to complete required attributes, preserving consistency across the Routing Header creation and update flows in Oracle EBS 12.1.1 and 12.2.2.