Search Results oki_load_fbo_pvt




Overview
Explore in AI Chat

Overview

The OKI_LOAD_FBO_PVT package is a private PL/SQL package owned by the APPS schema within Oracle E-Business Suite. Its name follows the standard EBS naming convention in which the OKI prefix designates the Oracle Knowledge Inventory (formerly Oracle Advanced Supply Chain Planning and Demand Planning) product family, while the _PVT suffix classifies the package as a private implementation unit. Objects carrying the PVT classification are not intended to be called directly by external code; they encapsulate internal logic that is exposed through a corresponding public package, in this case OKI_LOAD_FBO_PUB.

The business purpose of this package is to load forecast-by-organization data into the EBS forecasting schema. The forecast-by-orgs structure supports demand and supply planning activities by storing organization-specific forecast quantities and associating them with sales key header information and GL period definitions. This enables planners to view and maintain forecast data segmented by inventory organization over defined accounting periods.

Key Procedures and Functions

The ETRM metadata documents one procedure within OKI_LOAD_FBO_PVT:

  • CRT_FCST_ORG — Creates or loads forecast-by-organization records. This procedure encapsulates the logic required to populate the OKI_FORECAST_BY_ORGS structures based on incoming forecast and sales key header data. As a private procedure, it is invoked from within the OKI_LOAD_FBO_PUB public wrapper rather than directly by external callers. The metadata does not expose a parameter list; callers should always reference OKI_LOAD_FBO_PUB for the supported public signature.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • OKI_FORECAST_BY_ORGS — The primary target table into which forecast-by-organization records are inserted or updated by CRT_FCST_ORG.
  • OKI_FORECAST_BY_ORGS_S1 — The supporting sequence used to generate unique primary keys for new forecast-by-orgs rows.
  • OKI_SALES_K_HDRS — The sales key headers table, providing the header context that associates forecasts with planning keys and hierarchies.
  • GL_PERIODS — The General Ledger periods table, used to validate and resolve the accounting period names or numbers under which forecast rows are stored.
  • DUAL — The standard Oracle single-row utility table, referenced for simple lookups or sequence value retrieval.

Usage Notes

Direct invocation of OKI_LOAD_FBO_PVT is not supported. The package is referenced internally by OKI_LOAD_FBO_PUB, which serves as the public entry point for forecast loading operations. The metadata records exactly one dependent package referencing OKI_LOAD_FBO_PVT (OKI_LOAD_FBO_PUB) and confirms that the package itself references the OKI and OKI_REFRESHS objects, indicating interaction with the forecast refresh mechanism.

Typical invocation occurs during forecast upload or forecast maintenance processes initiated through Oracle Demand Planning or Advanced Supply Chain Planning concurrent programs and forms. Custom implementations requiring forecast-by-org loading should call the public wrapper package procedures, which internally delegate to CRT_FCST_ORG. Because this is a private unit, Oracle Applications does not guarantee signature stability across releases; any custom code extending forecast loading must be revalidated when applying EBS 12.1.1 or 12.2.2 patches.