Search Results push_edw_bres_rescat

Overview

EDW_BOM_RES_M_C is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM as an OTHER API. Its name follows the convention used by Oracle's Enterprise Data Warehouse (EDW) extraction layer, where the _M_C suffix denotes an "interface" or "movement" package responsible for populating EDW staging tables from the transactional E-Business Suite source tables. In the manufacturing and bills-of-material subject area, this package extracts the resource dimension of the BOM model — plants, resources, resource groups, resource types, resource categories, and the departmental hierarchies that own them — and loads that data into table structures consumed by downstream EDW reporting and analytics.

The package status is VALID and its documented dependency set is minimal: it references only SYS.STANDARD and is referenced by the APPS synonym EDW_BOM_RES_M_C. This self-referencing synonym indicates that the package is invoked from the EDW movement layer rather than from standard Oracle EBS application flows.

Key Procedures and Functions

The ETRM documents ten procedures in the package, all of which serve the extraction of a specific resource-related dimension or the orchestration of that extraction:

• PUSH — the primary entry point. It orchestrates execution of the remaining procedures in the package, providing a single callable driver for the resource extraction.
• PUSH_EDW_BRES_PLANT and PUSH_EDW_BRES_PLANT1 — extract plant-level information. The existence of two procedures indicates the plant dimension is populated in more than one form or at more than one granularity.
• PUSH_EDW_BRES_RESOURCE — extracts resource records, the core entities defined in Oracle Bills of Material and used by routings.
• PUSH_EDW_BRES_RESGROUP — extracts resource groups, the logical groupings used in capacity planning and scheduling.
• PUSH_EDW_BRES_RESTYPE — extracts resource type definitions.
• PUSH_EDW_BRES_RESCAT — extracts resource category assignments.
• PUSH_EDW_BRES_PARENT_DEPT — extracts parent-level departmental structures associated with resource ownership.
• PUSH_EDW_BRES_DEPT — extracts department records.
• PUSH_EDW_BRES_DEPT_CLASS — extracts department classification data.

Tables Accessed

Each procedure writes to a corresponding EDW landing table, identified by the _LSTG (listing/staging) suffix:

• EDW_BRES_PLANT_LSTG and EDW_BRES_PLANT1_LSTG — plant-level staging tables.
• EDW_BRES_RESOURCE_LSTG — staged resource records.
• EDW_BRES_RESGROUP_LSTG — staged resource groups.
• EDW_BRES_RESTYPE_LSTG — staged resource types.
• EDW_BRES_RESCAT_LSTG — staged resource categories.
• EDW_BRES_DEPT_LSTG and EDW_BRES_PARENT_DEPT_LSTG — staged department and parent-department rows.
• EDW_BRES_DEPT_CLASS_LSTG — staged department classifications.

The package reads from source and writes to these staging tables; it does not cascade updates into core Oracle EBS tables, consistent with EDW extraction design.

Usage Notes

EDW_BOM_RES_M_C is not invoked interactively from forms or standard concurrent programs. It is called by the EDW movement layer — typically during a scheduled data warehouse refresh — and is reached through its uppercase synonym EDW_BOM_RES_M_C. Because it is referenced by no other application packages, custom extensions should call the PUSH procedure directly rather than invoking individual sub-procedures, and should observe that the package assumes the staged tables exist and have been previously created by the EDW installation scripts. Environments must have the correct APPS grants on the staging tables before the package is executed.