Search Results oki_refresh_pvt




Overview
Explore in AI Chat

Overview

OKI_REFRESH_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms the core refresh engine of the Oracle Knowledge Integration (OKI) module, which underpins the Service Contracts and Telecommunications Service Management functionality delivered through Oracle's Enterprise Telecommunications Resource Management (ETRM) applications. The package is classified as a Private (PVT) API, meaning it is intended for internal invocation by sibling OKI packages and public APIs rather than by external or customer-written code.

Its principal business function is to maintain and synchronize the OKI refresh staging tables (referenced via OKI_REFRESHS) with operational contract data held in the OKC contract tables and with general ledger, human resources, and inventory reference data. This ensures that downstream OKI load processes operate against an accurate, current snapshot of contract headers, lines, addresses, sales representatives, pricing rules, and coverage periods. Refresh operations are typically executed on a scheduled basis, supporting daily rate updates and periodic contract data resynchronization.

Key Procedures and Functions

The package exposes approximately twenty-five documented procedures and functions. The principal groups are as follows:

Parameter lists are not documented in the ETRM metadata and should be obtained by inspecting the package specification in the database.

Tables Accessed

The package reads and writes the following tables through APPS synonyms. Contract data is drawn from OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_ITEMS, OKC_K_PARTY_ROLES_B, OKC_K_REL_OBJS, OKC_K_VERS_NUMBERS, OKC_STATUSES_B, OKC_OPERATION_LINES, OKC_CONTACTS, and OKC_GOVERNANCES. Reference and lookup data is sourced from CSI_ITEM_INSTANCES (installed base items), GL_DAILY_RATES and FND_CURRENCIES (currency conversion), GL_PERIODS (accounting periods), and HR_ORGANIZATION_INFORMATION (organization attributes). The package also references OKI_REFRESHS, the staging table that holds the refreshed output consumed by OKI load programs.

Usage Notes

OKI_REFRESH_PVT is referenced by eleven other packages, most notably the OKI load packages (OKI_LOAD_ENR_PVT, OKI_LOAD_ETR_PVT, OKI_LOAD_FBO_PVT, OKI_LOAD_OKV_PVT, OKI_LOAD_RAG_PVT, OKI_LOAD_RBK_PVT, OKI_LOAD_RBS_PVT, OKI_LOAD_SGR_PVT, OKI_LOAD_WBC_PVT, and OKI_LOAD_YRA_PVT) and the public wrapper OKI_REFRESH_PUB. It is therefore invoked indirectly through those layers rather than called directly. In practice, refresh activity is triggered by concurrent programs and scheduled jobs that call the public API, which in turn delegates to this private package. Customers extending ETRM should invoke OKI_REFRESH_PUB or the relevant load APIs; direct calls to OKI_REFRESH_PVT are not supported and are vulnerable to change between releases. Both Oracle EBS 12.1.1 and 12.2.2 retain this package with a VALID status, and its dependency footprint is consistent across both releases.