Search Results oki_load_wbc_pvt




Overview
Explore in AI Chat

Overview

OKI_LOAD_WBC_PVT is a private PL/SQL package that resides in the APPS schema and belongs to the Oracle E-Business Suite Order Management/Order Capture (OKI) product family. Its name reflects its role as a loader for "WBC" data, which in the OKI context refers to the Work Breakdown or customer-facing aggregated order data staged in the OKI_WIP_BY_CUSTOMERS tables. The package operates as the private implementation layer (the "PVT" suffix) behind the public package OKI_LOAD_WBC_PUB, and it is classified as an API of the PVT type, meaning it is intended for internal invocation by sibling packages, concurrent programs, and the public wrapper rather than by external custom code.

Its principal business function is to populate and refresh the summary of Work-In-Process (WIP) or open order commitments grouped by customer, enabling downstream reporting and reconciliation of customer order backlog. The package status is VALID, and it forms part of the standard dependency chain in a functioning EBS 12.1.1 / 12.2.2 installation.

Key Procedures and Functions

The documented interface exposes a single procedure:

  • CRT_WIP_BY_CUST — Creates or repopulates the "WIP by Customer" data set. Based on its name, it drives the load of aggregated work-in-process/backlog figures keyed by customer into the OKI_WIP_BY_CUSTOMERS staging tables, drawing from the covered-period lines and sales header sources. It is the sole documented entry point and is presumed to be called by the public wrapper OKI_LOAD_WBC_PUB.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The procedure is described here strictly by its documented purpose.

Tables Accessed

The package references the following objects through APPS synonyms:

  • GL_PERIODS — Provides the accounting period calendar used to select the reporting period(s) for which WIP-by-customer figures are calculated.
  • OKI_COV_PRD_LINES — Supplies covered-period line details, likely the order scheduling and coverage records that feed the aggregation.
  • OKI_SALES_K_HDRS — The sales/order header source that supplies customer and order-level attributes for grouping.
  • OKI_WIP_BY_CUSTOMERS — The primary target table where the aggregated WIP-by-customer results are inserted or refreshed.
  • OKI_WIP_BY_CUSTOMERS_S1 — A supplementary table (S1 designation), typically a secondary or staging/overflow structure supporting the main target.
  • DUAL — Used for single-row control queries and standard PL/SQL constructs.

In addition, the package depends on the OKI schema components and OKI_REFRESHS, consistent with a data-refresh utility that coordinates with the OKI refresh framework.

Usage Notes

OKI_LOAD_WBC_PVT is a private package and should not be called directly by customer extensions. It is referenced by OKI_LOAD_WBC_PUB, which acts as the supported public entry point, and it is self-referenced internally. In practice it is invoked when the WIP-by-customer summary requires regeneration — typically at the end of an order/backlog refresh cycle, during period-close reporting, or from a concurrent program that calls the public wrapper. Because it is status VALID and documented across both 12.1.1 and 12.2.2, its behavior is expected to be consistent between these releases. Customizations should target OKI_LOAD_WBC_PUB rather than this private implementation, preserving supportability and avoiding direct dependency on internal procedure signatures.