Search Results close_period_name




Overview
Explore in AI Chat

Overview

OKI_SALES_K_HDRS is a core table within the Oracle E-Business Suite Contracts Intelligence (OKI) module, a component of the ETRM (Enterprise Trade and Revenue Management) product family. It stores information about contracts of the sell intent — that is, the header-level records representing sales-side contracts tracked and analyzed by Contracts Intelligence. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the primary repository for the contract header attributes that drive downstream reporting, forecasting, approval, renewal, and revenue analysis.

The table resides in the OKI schema and is documented as VALID with 92 columns in the ETRM 12.1.1 physical schema. Its primary key is OKI_SALES_K_HDRS_PK, defined on the CHR_ID column. Two unique indexes provide business-key candidates: OKI_SALES_K_HDRS_U1 on CHR_ID and OKI_SALES_K_HDRS_U2 on the combination of CONTRACT_NUMBER and CONTRACT_NUMBER_MODIFIER, which together form the human-readable contract identifier.

The heuristic Data Vault classification mined from the foreign key structure is standalone. This suggests that, from a modeling perspective, OKI_SALES_K_HDRS behaves as an independent entity rather than as a link or satellite attached to a parent hub within a Data Vault construct. Its foreign keys point outward to reference and setup tables (FND_SECURITY_GROUPS, MTL_INV_PICKING_RULES, and PN_PAYMENT_TERMS_ALL) rather than to upstream transactional hubs.

Key Information Stored

The table captures the full commercial, financial, temporal, and organizational profile of each sales contract. Among the most significant columns are:

Common Use Cases and Queries

Typical reporting scenarios include active contract listings, revenue forecasting, renewal pipelines, and contract value by customer or organization. A representative query might be:

  • Listing current, active sell-side contracts with their base amounts: SELECT contract_number, customer_name, base_contract_amount, base_currency_code FROM oki_sales_k_hdrs WHERE is_latest_yn = 'Y' AND end_date >= SYSDATE;
  • Aggregating contract value by organization and currency for financial dashboards, grouping on AUTHORING_ORG_ID and BASE_CURRENCY_CODE.
  • Identifying contracts approaching expiry for renewal preparation, filtering on END_DATE within a forward window and RENEWAL_TYPE_USED.
  • Version analysis, comparing MAJOR_VERSION and MINOR_VERSION across records sharing CONTRACT_NUMBER and CONTRACT_NUMBER_MODIFIER where IS_LATEST_YN is not 'Y'.
  • Forecast reporting using FORECAST_AMOUNT, BASE_FORECAST_AMOUNT, and WIN_PERCENT for weighted pipeline estimates.

Because the table exposes pre-derived START_QUARTER, START_YEAR, CLOSE_QUARTER, and CLOSE_YEAR columns, period-based rollups can be written without complex date functions, improving query performance in large datasets.

Related Objects

The documented foreign keys establish these significant relationships:

  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID, governing row-level access control.
  • MTL_INV_PICKING_RULES — joined via INV_RULE_ID, defining inventory picking rules for the contract.
  • PN_PAYMENT_TERMS_ALL — joined via PAYMENT_TERM_ID, supplying payment term definitions.

In addition, related OKI tables and views (such as line-level or detail tables sharing CHR_ID as a foreign key) depend on this header, and standard EBS APIs for contract creation and maintenance operate against it. The AGREEMENT_ID column links to sourcing agreement structures, while AUTHORING_ORG_ID ties to HR and inventory organization definitions.