Search Results oki_load_sgr_pvt




Overview
Explore in AI Chat

Overview

OKI_LOAD_SGR_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. The _PVT suffix indicates a private API classification, meaning the package is intended for internal use by Oracle's Order Management and Contracts Intelligence (OKI) modules rather than for direct invocation by external or custom code. Its principal purpose is to load and maintain sequence growth rate (SGR) data used in forecasting and analytics within the Oracle Knowledgebase Intelligence / Contracts Intelligence product family.

At a functional level, the package populates the OKI_SEQ_GROWTH_RATE table based on historical sales activity and period definitions. Sequence growth rate computations are used to model anticipated future business volumes and drive forecast-oriented reporting. The private designation signals that OKI_REFRESH_PVT and other internal OKI processes drive it as part of a broader data refresh cycle rather than exposing it as a supported integration point.

Key Procedures and Functions

The documented package exposes one procedure:

  • CRT_SEQ_GRW — Creates sequence growth rate records. This routine is the core worker of the package, responsible for deriving growth rate figures and writing them into the OKI_SEQ_GROWTH_RATE repository. Because the ETRM metadata does not publish a parameter list, no signature details are asserted here; its behavior is understood from the tables and dependencies it touches.

Internal dependencies confirmed in the metadata include OKI_UTL_PVT, OKI_REFRESH_PVT, FND_FILE, FND_GLOBAL, FND_MESSAGE, FND_PROFILE, and the STANDARD package. These indicate that CRT_SEQ_GRW relies on shared OKI utilities, concurrent program file handling and message logging, and standard Oracle built-ins.

Tables Accessed

The following tables are referenced through APPS synonyms:

  • GL_PERIODS — Supplies the accounting period calendar used to bucket historical sales and align growth rate calculations to valid fiscal periods.
  • OKI_SALES_K_HDRS — Provides the sales history header data (shipped/booked amounts and dates) from which sequence growth is calculated. The "_K" naming reflects the knowledgebase fact tables in the OKI schema family.
  • OKI_SEQ_GROWTH_RATE — The target table. CRT_SEQ_GRW inserts or updates the computed growth rate values here for downstream forecasting use.

Usage Notes

OKI_LOAD_SGR_PVT is not referenced by any other database object, confirming it is a top-of-chain private worker invoked programmatically rather than through declarative dependencies.

Typical invocation paths include:

  • Concurrent program logic — The presence of FND_FILE and FND_PROFILE dependencies indicates the package is called from within an EBS concurrent manager context, likely as part of an OKI data refresh or forecasting report program where it emits log output and reads profile option settings.
  • Internal OKI refresh routines — OKI_REFRESH_PVT references this package as part of a larger sequence that populates knowledgebase and analytics tables.
  • Custom code caution — Because the API is classified PVT and is undocumented for external use, direct calls from customer extensions are unsupported. Any customization should instead consume the resulting OKI_SEQ_GROWTH_RATE data rather than calling CRT_SEQ_GRW directly.

This package's behavior is consistent across EBS 12.1.1 and 12.2.2, as the OKI data model and its growth rate logic were not fundamentally restructured between those releases.