Search Results populate_inc_table_inc




Overview
Explore in AI Chat

Overview

OKI_DBI_LOAD_CLEB_PVT is a private PL/SQL package owned by APPS that supports the Oracle Order Management and Oracle Contracts (OKC/OKI) reporting and analytics infrastructure. Its primary business function is to stage, transform, and load contract and order data into the DBI (Daily Business Intelligence) cleb fact and staging tables that underpin the CLEB (Contract and Lease Event Bookings) reporting subject area. The package orchestrates a multi-phase Extract, Transform, Load (ETL) cycle that harvests transactional rows from the Order Management, Contracts, and Installed Base tables, then normalizes them into the staging structures consumed by the analytics layer.

The "_PVT" suffix indicates that this is a private package, meaning it is not intended to be called directly by customer code. It is invoked internally by its parent DBI loader programs. The package header carries the revision string $Header: OKIRILES.pls 120.1 2006/03/28 ..., indicating it belongs to the OKIRILES (OKI Reports Integration Load) family of loaders.

Key Procedures and Functions

The package exposes twenty-one documented procedures, grouped functionally below.

  • Logging and Utility: RLOG and ROUT write diagnostic output to a log and result destination respectively; RESET_BASE_TABLES truncates or reinitializes the base staging tables prior to a load cycle.
  • Load Drivers: DIRECT_LOAD performs a full (direct) load of records; INCR_LOAD performs an incremental load. Both return the count of processed records. INITIAL_LOAD is the top-level entry point that accepts start and end date parameters and drives the complete initial load sequence.
  • Incremental Staging: POPULATE_INC_TABLE_INIT and POPULATE_INC_TABLE_INC populate the initial and incremental staging tables that track changed records between load runs.
  • Currency and Cleanup: REPORT_MISSING_CURRENCIES identifies currency codes absent from the system currency list; LOAD_CURRENCIES loads currency data; PROCESS_DELETES handles removal of deleted or logically eliminated records from staging.
  • Relationship and Delta Processing: POPULATE_REN_REL populates renewed/related object relationships; POPULATE_PREV_INC builds prior incremental snapshots; DELTA_CHANGES computes changed rows; UPDATE_LHS and UPDATE_RHS update the left-hand and right-hand side attributes of staged records.
  • Staging Update: UPDATE_STAGING is the procedure of interest for the search term "update_staging". It accepts a worker number, a total worker count, and returns a processed-record count. It performs the parallel update of staging rows, and its worker-based signature indicates it is designed to run within a parallel worker framework.
  • Parallel Execution Framework: WORKER executes a specific phase for a given worker number; LAUNCH_WORKER is a function that spawns (or returns the handle for) an individual worker. LOAD_STAGING performs the staging load for a single worker.

Tables Accessed

All table access is performed through APPS synonyms, reflecting the schema owner pattern.

Usage Notes

Because OKI_DBI_LOAD_CLEB_PVT is a private package, it is not a supported public API. It is invoked indirectly by the DBI CLEB loader concurrent programs and by its two referencing packages, which manage phase sequencing and worker partitioning. The worker-oriented signatures (p_worker, p_no_of_workers) indicate the package is designed for parallel concurrent processing in Oracle EBS 12.1.1 and 12.2.2. Customers should not call individual procedures such as UPDATE_STAGING directly; doing so risks data inconsistency in the DBI staging tables. Customizations should instead target the public DBI loader entry points or request extensions through Oracle Support.