Search Results edw_bom_res_m




Overview
Explore in AI Chat

Overview

EDW_BOM_RES_M is an Oracle E-Business Suite concurrent program that belongs to the ENI - Product Intelligence product family, also referenced under BIS - Applications BIS in the ETRM metadata for release 12.2.2. Its user-facing name is Collect Resource Dimension, and it functions as a Resource Dimension Collect Program. The program is enabled in the environment and is designed to populate or refresh the resource dimension used by the Product Intelligence (formerly Business Intelligence System) analytical schemas. Resource dimensions in this context represent manufacturing or planning resources — such as work centers, departments, and machines — that are consumed by bills of material and routings. By extracting and staging this dimension data, the program supports downstream reporting and analytics on resource utilization, capacity, and cost. The object is delivered as part of the standard EBS installation and is not a custom component.

Execution Details

The documented execution method for EDW_BOM_RES_M is PL/SQL Stored Procedure with a Standard argument method. The executable and execution filename are recorded as EDW_BOM_RES_M and EDW_BOM_RES_M_C.PUSH respectively, indicating that a package-based implementation drives the collection logic. The program is registered with the SRS (Standard Request Submission) framework, meaning it is submitted through the standard concurrent manager. Because it uses the standard argument method, its parameters are defined generically rather than through a dedicated value set UI, and they are passed positionally at submission time. The metadata also confirms the program is enabled and available for scheduling or on-demand execution.

How to Run

Users submit EDW_BOM_RES_M through the Standard Request Submission (SRS) window, typically by navigating to a responsibility that includes the Product Intelligence or BIS collection menu. The request can be run on demand or scheduled periodically depending on the freshness requirements of the analytical data. The documented arguments follow the standard date-range pattern used across EDW collection programs:

  • FROM_DATE (mapped to ATTRIBUTE1) — the beginning of the collection window.
  • TO_DATE (mapped to ATTRIBUTE2) — the end of the collection window.

Both arguments are shown as displayable, insertable, and updatable, and both are associated with the shared name $SRS$.EDW_BOM_RES_M, confirming that the parameters are surfaced to the user at submission. General guidance is to supply a date range that covers the period for which resource dimension changes must be captured, and to avoid overlapping runs that could duplicate records. The program should be run after any master data changes to resources, work centers, or departments so that the dimension reflects current values.

Related Objects

EDW_BOM_RES_M operates within the broader Product Intelligence collection framework. Because its execution file is EDW_BOM_RES_M_C.PUSH, the underlying PL/SQL package drives inserts into the EDW staging tables that feed the resource dimension. Commonly associated objects include companion collection programs for other dimensions (such as item, organization, and bill of material dimensions), the EDW staging and interface tables into which the resource records are loaded, and the analytical reports or dashboards that consume the resource dimension. In EBS 12.1.1 and 12.2.2 the program is referenced from the BIS/ENI collection request sets, and it should be scheduled in coordination with related BOM and routing collection programs to maintain referential consistency across the dimensional model.