Search Results l_setup_good




Overview
Explore in AI Chat

Overview

OPI_DBI_INV_CCA_OPM_PKG is a PL/SQL package body owned by the APPS schema that supports Oracle Daily Business Intelligence (DBI) inventory cycle count analysis for Oracle Process Manufacturing (OPM). Its principal responsibility is to extract cycle count transaction data from OPM and Oracle Inventory base tables and stage it into the OPI_DBI_INV_CCA_STG table, which serves as the reporting source for DBI inventory cycle count dashboards and analytics. The package header carries the revision identifier OPIDEICCAPB.pls 120.1 2005/08/02, indicating delivery on the 11i platform and its continued presence through EBS 12.1.1 and 12.2.2. As an "OTHER" classification package, it is not published as a public API; it functions as an internal ETL utility invoked by the DBI collection infrastructure.

Key Procedures and Functions

  • RUN_INITIAL_LOAD_OPM — The primary entry point. It performs the initial (full) extraction of OPM inventory cycle count data and populates the OPI_DBI_INV_CCA_STG staging table. This procedure is responsible for validating global setup values, including the global start date and global currency code, before initiating the load. The package defines several user-defined exceptions that gate this processing, including GLOBAL_START_DATE_NULL (ORA-20900), GLOBAL_SETUP_MISSING (ORA-20901), and OPM_EXTRACTION_ERROR (ORA-20910), each accompanied by a descriptive error message constant. These exceptions indicate that the procedure verifies setup prerequisites and aborts with a meaningful error if the global start date or currency code is absent or invalid.
  • GET_UNIT_COST — A helper function that retrieves the unit cost applicable to an item during cycle count valuation. It supports the cost-based aggregation performed in the extraction by returning cost figures that are staged alongside cycle count quantities for DBI reporting purposes.

Tables Accessed

The package reads and writes a documented set of tables through APPS synonyms. On the OPM side, it draws from IC_CYCL_HDR, IC_CYCL_DTL, and IC_CYCL_ADT (cycle count header, detail, and adjustment data), IC_ITEM_MST_B (item master), IC_RANK_MST (rank master), IC_TRAN_CMP (transaction components), IC_WHSE_INV and IC_WHSE_MST (warehouse inventory and warehouse master), and GL_SUBR_LED (subledger accounting entries). From Oracle Inventory, it references MTL_SYSTEM_ITEMS_B for item definition data. The staged output is written to OPI_DBI_INV_CCA_STG. Together these tables supply item attributes, warehouse context, cycle count transactions and adjustments, and valuation data needed to construct the DBI cycle count fact records.

Usage Notes

OPI_DBI_INV_CCA_OPM_PKG is invoked by the DBI collection and extraction framework rather than directly by end users. In practice, it is driven by the Daily Business Intelligence inventory collection concurrent programs that execute on a scheduled basis to refresh cycle count analytics. The ETRM metadata records that it is referenced by one other package, reflecting this dependent-collection pattern. Direct calls from custom code are not recommended, as the package relies on concurrent manager return codes (g_OK, g_WARNING, g_ERROR) and internal setup validation for the global start date and global currency code. Administrators diagnosing failures should inspect the exception messages defined in the package, particularly GLOBAL_START_DATE_NULL and GLOBAL_SETUP_MISSING, which signal missing DBI global setup rather than data defects, and verify that OPI_DBI_INV_CCA_STG has been populated before reviewing downstream cycle count reports. The single occurrence of the search term l_setup_good typically corresponds to a local Boolean flag used within the extraction logic to track the success of setup validation prior to the load.