Search Results edw_items_m




Overview
Explore in AI Chat

Overview

The concurrent program EDW_ITEMS_M is owned by the ENI – Product Intelligence product/module within Oracle E-Business Suite. Its user-facing name is Collect Item Dimension, and it is documented with the description "Item Dimension Collect Program." The program is enabled (Enabled: Yes) in the documented ETRM 12.1.1 metadata.

Functionally, EDW_ITEMS_M is a dimension collection program. In the Product Intelligence / Enterprise Data Warehouse (EDW) architecture, item data is a foundational dimension for downstream analytics, reporting, and data mart population. The program extracts and stages item attribute information so that it can be loaded into the Product Intelligence analytical model, typically as part of a broader dimension and fact collection cycle. Because item data changes over time, this program operates against date-ranged selections, enabling incremental or point-in-time collection rather than a single full refresh.

Execution Details

The documented execution details are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: EDW_ITEMS_M
  • Execution Filename: EDW_ITEMS_M_C.Push
  • Subroutine Name: (not specified)
  • Executable User Name / Description: EDW_ITEMS_M / Item Dimension Collect Program

The executable name and the concurrent program name are identical (EDW_ITEMS_M), and the execution file is exposed as EDW_ITEMS_M_C.Push, indicating the entry point into the collection logic. Because the execution method is PL/SQL Stored Procedure, submission invokes database-side code directly rather than an external script or Java class.

How to Run

Users submit EDW_ITEMS_M through the standard Oracle EBS Submit Request (SRS) flow for the Product Intelligence responsibility, selecting the request named Collect Item Dimension. The documented request set arguments include the following:

  • FROM_DATE — associated with the descriptive flexfield segment ATTRIBUTE1 ($SRS$.EDW_ITEMS_M); Display, Insert, and Update flags are all Y.
  • TO_DATE — associated with the descriptive flexfield segment ATTRIBUTE2 ($SRS$.EDW_ITEMS_M); Display, Insert, and Update flags are all Y.

In practice, the FROM_DATE and TO_DATE parameters define the collection window, allowing the program to gather item dimension records for the specified period. Users should choose dates consistent with the enterprise's EDW load schedule and with any dependent dimension or fact programs that must run before or after it. The default type and default value fields are blank in the documented metadata, so values are supplied at submission time. Because the arguments are exposed through the SRS descriptive flexfield, they appear on the request submission form for entry and are stored in the request record for reference.

Related Objects

EDW_ITEMS_M sits within the Product Intelligence collection framework, which generally comprises multiple dimension and fact collection programs sharing a common staging and load architecture. Commonly associated objects include:

  • Other EDW dimension collection concurrent programs (for example, supplier, customer, and organization dimension collectors) submitted alongside or sequenced with item collection.
  • The staging/interface tables used by the Product Intelligence load process, which are populated by the collection programs before being consumed by the analytical model.
  • The executable EDW_ITEMS_M_C.Push and its underlying PL/SQL package, which encapsulate the extraction and load logic.

Because the ETRM metadata for this object documents only the program-level attributes and the two date arguments, administrators and implementers should consult the Product Intelligence implementation documentation for the exact interface tables and load sequence associated with the item dimension in a given EBS 12.1.1 or 12.2.2 environment.