Search Results oki_dbi_reset_pvt

Overview

The APPS.OKI_DBI_RESET_PVT package body is a private (PVT-classified) PL/SQL utility within the Oracle E-Business Suite service contracts and intelligence schema. Its name reflects its role in the Oracle Knowledge Intelligence (OKI) and Daily Business Intelligence (DBI) family of objects, where it functions as a reset handler that restores selected baseline collection tables to a known pre-refresh state. In EBS 12.1.1 and 12.2.2, DBI and related contract-intelligence dashboards depend on summary and staging tables that accumulate data during high-volume collection runs. When a collection cycle is interrupted, aborted, or must be re-executed, the affected tables can be left holding partial or inconsistent data. This package provides the programmatic mechanism to clear and reinitialize those base tables so that subsequent collection processes begin from a clean, deterministic starting point. The package carries a status of VALID in the ETRM registry, confirming it is a supported, compiled object within the APPS schema.

Key Procedures and Functions

The documented package exposes a single entry point:

• RESET_BASE_TABLES — The sole documented procedure. Its purpose is to reset the base staging and summary tables used by the contract-intelligence collection process. It performs the clearing and reinitialization logic that returns these tables to their baseline condition prior to a new collection run. Because this is a private package, the procedure is intended for invocation by the collection framework and its supporting utilities rather than by external callers. No public parameter list is documented in the ETRM record.

The procedure relies on several supporting dependencies to carry out its work, notably BIS_COLLECTION_UTILITIES, which provides the shared collection-framework helper routines used across DBI packages; FND_MESSAGE, used to raise standardized, translatable error and status messages; and OKC_API, the service contracts public API, which supplies contract-domain context and validation logic. The package also references FND_INSTALLATION, indicating that it verifies installation or patch state before proceeding.

Tables Accessed

The ETRM metadata records no directly referenced application tables outside the package's own dependencies; the base-table manipulation is performed through the above helper packages rather than through literal SQL against named application tables within the package body itself. In practice, the object being reset by RESET_BASE_TABLES is the OKI/DBI base collection table set that underlies contract-intelligence dashboards. These tables are truncated or reinitialized so that partial rows from an aborted collection cannot contaminate a subsequent run. Reference data and installation-state reads are routed through FND_INSTALLATION and FND_MESSAGE.

Usage Notes

OKI_DBI_RESET_PVT is a private package and is therefore not exposed through standard EBS forms menus or directly to end users. It is invoked internally by the collection and refresh infrastructure and, where required, by custom code or concurrent program wrappers that orchestrate a full re-collection of contract-intelligence data. The ETRM record confirms that the package is not referenced by any other database object, while it itself references one other package, giving it the character of a terminal orchestration utility at the end of the collection chain. Typical invocation scenarios include rerunning a failed DBI collection, resetting staging data after a data-correction exercise, and preparing an environment for a fresh full refresh. Because it alters base collection data, it should be executed only in controlled windows, ideally with the collection concurrent programs halted, and never during an active collection cycle. In 12.2.2 online-patching environments, the same considerations apply, with the additional caution that the object resides in the APPS schema and is delivered and updated through standard EBS patching.