Search Results export_rtg

Overview

APPS.BOM_RTG_EXP is a PL/SQL specification package in Oracle E-Business Suite that supports the export of manufacturing routing definitions from the Bills of Material (BOM) module. Its single documented routine, EXPORT_RTG, allows callers to retrieve a complete routing definition for a given assembly and organization into strongly typed PL/SQL record and table structures, rather than persisting it directly to a database table. This makes the package a retrieval and staging layer used by integration, migration, or replication utilities that need to move routing data between environments, systems, or interfaces.

The package is defined with AUTHID CURRENT_USER, meaning that runtime privilege checks are performed against the invoking schema; the owner (APPS) does not inherently grant access to the underlying objects. The header history dates the initial creation to October 2002, and the source file is identified as BOMREXPS.pls. The API is classified as OTHER in the ETRM metadata, indicating it is not one of the primary public routing APIs (such as BOM_RTG_PUB), but rather a supporting export utility.

Key Procedures and Functions

The package exposes a single documented procedure, EXPORT_RTG. It accepts the organization code, assembly item name, and alternate routing designator that together identify the routing to be exported. It also provides optional initialization and debugging controls, including a debug flag and an output directory for a debug log file.

The procedure returns the routing data through a set of NOCOPY OUT parameters that correspond to the public routing data types defined in BOM_RTG_PUB. These outputs include the routing header record, a routing revision table, an operation table, an operation resource table, a sub-resource table, and an operation network table. Two additional output parameters report the return status and message count, following the standard Oracle EBS API error-handling convention. Because the outputs are typed against BOM_RTG_PUB structures, the exported routing can be consumed directly by routing creation or update APIs without intermediate transformation.

Tables Accessed

The package reads from a defined set of BOM, WIP, and cost management tables through APPS synonyms. Routing structure data is drawn from BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_SEQUENCES, and BOM_OPERATION_RESOURCES. Resource and sub-resource definitions come from BOM_RESOURCES, BOM_SUB_OPERATION_RESOURCES, and BOM_SETUP_TYPES. Routing revisions are sourced from MTL_RTG_ITEM_REVISIONS, while item context is validated against MTL_SYSTEM_ITEMS_KFV. WIP_LINES supplies line and department context, and CST_ACTIVITIES contributes cost activity information. PLITBLM is an internal PL/SQL table used within the package. The combined read pattern reflects an export that produces a self-contained routing definition, including operations, resources, revisions, and associated cost and line references.

Usage Notes

EXPORT_RTG is typically invoked from custom PL/SQL routines, conversion scripts, or integration programs rather than from a standard Oracle form. It is commonly used during data migration, during setup replication between instances, or as the extraction half of an export/import utility for routings. Because it returns data through PL/SQL collection types rather than writing files or rows directly, the caller is responsible for persisting or transmitting the results. The debug parameters support troubleshooting when the export produces unexpected output. As the package is not referenced by other documented packages, it should be treated as a standalone utility and called explicitly by name.