Search Results opi_edw_cogs_f_c




Overview
Explore in AI Chat

Overview

OPI_EDW_COGS_F_C is an Oracle Applications (APPS) PL/SQL package that belongs to the Oracle Project Intelligence / Enterprise Data Warehouse (EDW) family of programs concerned with cost of goods sold (COGS) reporting and extraction. The package is responsible for collecting, transforming, and pushing COGS fact data from transactional E-Business Suite sources into the EDW staging and incremental collection tables. Within the 12.1.1 and 12.2.2 releases, it forms part of the extract-load infrastructure that supplies the Oracle Projects and Supply Chain Intelligence warehouse with a consolidated view of material, order, and invoicing costs.

The package header carries the version marker OPIMCOGS.pls 120.1, dated 2005/06/10, indicating it is a long-standing component that has remained stable across the EBS codelines. Its ETRM API classification is "OTHER," meaning it is not an end-user callable business API but an internal data-warehouse driver invoked by the collection framework. The header is also referenced by one other package, which most likely controls the scheduling or orchestration of the COGS load.

Key Procedures and Functions

The documented interface exposes two program units:

  • PUSH — An entry-point procedure that drives the COGS extraction cycle. It accepts an error buffer and return code for standard concurrent-program error handling, together with a from-date and to-date range expressed as VARCHAR2. These date parameters define the accounting or transaction window from which COGS records are gathered, enabling incremental, period-based loads rather than full refreshes.
  • PUSH_TO_LOCAL — A function that takes a view identifier and a sequence identifier and returns a NUMBER. It supports the local-instance push mechanism, using the EDW_LOCAL_INSTANCE configuration to determine the target warehouse instance. The returned numeric value typically communicates success or failure status back to the controlling process.

The naming convention (PUSH, PUSH_TO_LOCAL) is characteristic of OPI EDW collection packages, which stage data locally before transmitting it to the central warehouse.

Tables Accessed

The package reads and writes an extensive set of transactional and warehouse tables, resolved through APPS synonyms:

Usage Notes

OPI_EDW_COGS_F_C is not intended for direct invocation from EBS forms or ad hoc SQL. It is executed by the Oracle EDW collection framework, typically through a concurrent program that supplies the from-date and to-date range. In practice, the package runs on a scheduled basis as part of the broader COGS fact collection cycle, feeding the staging and incremental tables that the warehouse uses to build COGS analysis. Customizing or calling this package outside that framework requires careful attention to the date-range semantics and to the EDW_LOCAL_INSTANCE configuration, since incorrect parameters can result in incomplete or duplicated cost records in the warehouse.