Search Results populate_prev_inc

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.

• Order Management: OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL supply order header and line transaction data.
• Contracts: OKC_K_HEADERS_ALL_B, OKC_K_LINES_B, OKC_K_ITEMS, OKC_K_PARTY_ROLES_B, OKC_K_REL_OBJS, and OKC_CLASS_OPERATIONS provide contract header, line, item, role, and relationship data.
• Agreements: OE_AGREEMENTS_B and OE_AGREEMENTS_TL provide agreement headers and translations.
• Installed Base: CSI_ITEM_INSTANCES supplies installed base instance records.
• Resources and Setup: JTF_RS_SALESREPS, MTL_PARAMETERS, and FINANCIALS_SYSTEM_PARAMS_ALL provide salesrep, inventory organization, and financial system parameter context.

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.