Search Results oki_sales_k_renew_v




Overview
Explore in AI Chat

Overview

The view OKI_SALES_K_RENEW_V belongs to the Oracle E-Business Suite module OKI – Contracts Intelligence, a product line that is documented as obsolete in ETRM reference material for releases 12.1.1 and 12.2.2. The view is designed to present information about renewal contracts, consolidating contract header attributes, status and category lookups, customer identifiers, monetary amounts, currency designations, and a broad set of date and period dimensions into a single denormalized reporting structure. Its principal role is analytical: it exposes renewal-oriented contract data in a shape suitable for Contracts Intelligence dashboards and for ad hoc reporting on renewal activity, including the renewed contract amount and its counterparts expressed in functional (SOB), base, and transactional currencies. Because the product is marked obsolete, the view should be treated as a legacy artifact. Organizations running ETRM on 12.1.1 or 12.2.2 may still encounter it in historical customizations, migrated reports, or archived extracts, but it is not a supported object for new development. Users searching for the column name CONTRACT_AMOUNT_RENEWED will find that it originates here, where it is exposed alongside its SOB and base-currency equivalents.

Underlying Base Objects

The documented metadata records no referenced base objects for this view, and the ETRM implementation data states it is not implemented in the database for the documented environment. Nevertheless, the view text itself reveals the internal aliases used in its definition. The primary source is aliased RNW, which supplies contract identity, organization, customer, amount, currency, date, period, inventory organization, and descriptive flexfield attribute columns. Lookup enrichment is provided by additional aliases: SCS supplies the category meaning (MEANING) derived from RNW.SCS_CODE, STS supplies the status meaning from RNW.STS_CODE, STE supplies the status type meaning from STS.STE_CODE, and TRN supplies the termination meaning from RNW.TRN_CODE. These aliases indicate joins to contract header and lookup/setup sources, but the exact base tables are not disclosed in the provided metadata and must be confirmed against the actual database definition. Practitioners should not assume the view exists until its presence is verified in the target instance.

Key Columns

Common Use Cases and Queries

Typical usage centers on renewal revenue analysis, renewal win-rate reporting, and period-based trend analysis of renewed versus forecast amounts. A representative query filters and aggregates renewal amounts by status and period:

  • SELECT CONTRACT_NUMBER, CUSTOMER_NAME, STATUS_MEANING, CONTRACT_AMOUNT_RENEWED, CURRENCY_CODE_RENEWED, DATE_RENEWED FROM OKI_SALES_K_RENEW_V WHERE DATE_RENEWED BETWEEN :start_date AND :end_date;
  • SELECT START_YEAR, START_QUARTER, SUM(SOB_CONTRACT_AMOUNT_RENEWED) FROM OKI_SALES_K_RENEW_V GROUP BY START_YEAR, START_QUARTER;
  • SELECT CATEGORY_MEANING, STATUS_MEANING, COUNT(*), SUM(BASE_CONTRACT_AMOUNT_RENEWED) FROM OKI_SALES_K_RENEW_V GROUP BY CATEGORY_MEANING, STATUS_MEANING;
  • SELECT CONTRACT_NUMBER, WIN_PERCENT, CONTRACT_AMOUNT, FORECAST_AMOUNT, CONTRACT_AMOUNT_RENEWED FROM OKI_SALES_K_RENEW_V WHERE WIN_PERCENT IS NOT NULL;

Before relying on any such query, verify that the view exists in the target environment, since the metadata indicates it is not implemented there and the OKI product is obsolete. Where the view is absent, equivalent renewal data should be sourced from supported contract tables or the current Contracts Intelligence replacement.