Search Results opi_edw_inv_daily_stat_f_c




Overview
Explore in AI Chat

Overview

The APPS.OPI_EDW_INV_DAILY_STAT_F_C package is a PL/SQL program unit within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It resides in the APPS schema and is classified under the ETRM as an "OTHER" API type. Its primary business function is to support the Oracle Product Information (OPI) Enterprise Data Warehouse (EDW) inventory daily statistics fact collection process. In the EBS architecture, OPI packages bridge operational transactional data with the analytical EDW layer. This package specifically handles the extraction, staging, and pushing of daily inventory statistics into a fact staging table, from which the data is subsequently loaded into the EDW's inventory daily statistics fact table. The package status is recorded as VALID, indicating it is compiled and functional in the documented environment.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package: PUSH.

  • PUSH: As the sole documented procedure, PUSH is the core operational routine of this package. Its purpose is to transfer or "push" data from the source operational tables into the EDW staging and logging infrastructure. The procedure likely orchestrates the movement of daily inventory statistics records into the fact staging table OPI_EDW_INV_DAILY_STAT_FSTG, while recording the outcome of the operation into the OPI_IDS_PUSH_LOG table. The naming convention aligns with the EBS process for propagating data from the transactional system to the analytical EDW repository.

It is important to note that the ETRM documentation does not provide the parameter list for this procedure. Therefore, no specific parameter details are asserted here; only the documented procedure name and its inferred purpose are described.

Tables Accessed

The package accesses the following tables via APPS synonyms:

  • OPI_EDW_INV_DAILY_STAT_FSTG: This is the fact staging table for inventory daily statistics. The PUSH procedure reads from or writes to this table as the primary destination for the extracted daily inventory statistics before they are loaded into the final EDW fact tables.
  • OPI_IDS_PUSH_LOG: This log table records the status, timing, and possibly the volume of data pushed during each execution of the PUSH procedure. It provides an audit trail for the data propagation process.
  • EDW_LOCAL_SYSTEM_PARAMETERS: This table stores local system parameters that control the behavior of the EDW collection process. The PUSH procedure likely reads from this table to determine configuration settings, such as batch sizes, enabled flags, or environmental details.
  • DUAL: A standard Oracle one-row dummy table, typically used within the package for simple computations, date retrieval, or validation queries that do not require an actual application table.

Usage Notes

The OPI_EDW_INV_DAILY_STAT_F_C package is typically invoked as part of the Oracle Product Information EDW data collection and fact load cycle. In a standard EBS implementation, such packages are usually called by concurrent programs or by higher-level collection packages. The ETRM metadata confirms that OPI_EDW_INV_DAILY_STAT_F_C is referenced by another package, OPI_EDW_COLLECT_MBI_FACTS_F_C. This indicates that the collection package likely orchestrates the invocation of OPI_EDW_INV_DAILY_STAT_F_C.PUSH as part of a broader fact collection process for MBI (possibly "Management Business Intelligence" or a similar EDW acronym). The package is not typically called directly from Oracle Forms; instead, it operates within a batch or scheduled environment. When troubleshooting daily inventory statistics in the EDW, DBAs and developers would check the OPI_IDS_PUSH_LOG table and the execution logs of the parent collection package to verify that PUSH executed successfully. Custom code should not call this package directly unless it adheres to the same transactional and logging conventions employed by the standard collection framework.