Search Results group_by2




Overview
Explore in AI Chat

Overview

APPS.OKE_K_FUNDING_SUMMARY_V is a supplementary view in the Oracle E-Business Suite (EBS) Applications schema (APPS), owned by the Oracle Contracts Core (OKE) module. It is catalogued as a VALID database object and registered under FND Design Data as OKE.OKE_K_FUNDING_SUMMARY_V. The view is defined as a "supplementary view used to simplify forms coding," meaning its principal role is to provide a consolidated, denormalized projection of contract funding data that Oracle Forms-based inquiry screens can consume without embedding complex join logic in form blocks.

The view exposes contract funding summaries at the header level, combining initial, incremental, and current funding amounts alongside invoice and revenue hard limits. Amounts are presented in two currencies simultaneously: the funding currency and the contract currency, distinguished by the F_ and K_ column prefixes. Because the object is documented as Oracle Internal Use Only, Oracle Corporation does not support direct access to its data except from standard Oracle Applications programs, and Oracle explicitly warns that the view is not recommended for querying or alteration by customers and may change dramatically in subsequent minor or major releases.

Underlying Base Objects

The documented referenced base objects for OKE_K_FUNDING_SUMMARY_V are:

  • OKE_FUNDING_INQUIRY (PACKAGE) — the packaged API that drives funding inquiry logic. The view supplies rows shaped to match the inquiry requirements this package serves, rather than sourcing directly from a single base table.
  • OKE_K_FUND_VERS_SUMMARY_V (VIEW) — an underlying contract-version-level funding summary view that aggregates funding revisions per contract document version.

This dependency chain indicates that OKE_K_FUNDING_SUMMARY_V does not select from a physical base table directly; instead, it builds on the version-level funding summary view and aligns with the funding inquiry package. This layered design is characteristic of ETRM contract funding objects, where funding revisions are accumulated over versions and then summarized for presentation.

Key Columns

Common Use Cases and Queries

The view is primarily consumed by Oracle Forms funding inquiry screens to display the funding position of a contract, including amounts funded versus invoice and revenue limits, across both funding and contract currencies. A typical querying pattern retrieves the current funding and limits for a specific contract document version:

  • SELECT object_id, major_version, funding_currency_code, f_curr_amount, k_curr_amount, f_curr_hard_limit, f_curr_rev_hard_limit, k_curr_hard_limit, k_curr_rev_hard_limit FROM apps.oke_k_funding_summary_v WHERE object_id = :p_contract_id AND major_version = :p_major_version;
  • Filtering with WHERE object_type = 'OKE_K_HEADERS' to scope results to contract header objects.
  • Aggregating by GROUP_BY1_CODE and GROUP_BY2_CODE to break funding totals down by the configured grouping dimensions.

Because the object is flagged Oracle Internal Use Only and its definition is subject to significant change across releases, any custom use should be limited to read-only inquiry, and customers are advised to obtain funding data through supported APIs such as OKE_FUNDING_INQUIRY rather than depending on this view's structure.