Search Results oki_sales_k_new_v




Overview
Explore in AI Chat

Overview

The view APPS.OKI_SALES_K_NEW_V is a reporting object within the Oracle E-Business Suite Contracts Intelligence module (product code OKI). It exposes information about new contracts — that is, contracts that are not renewals of previously existing contracts. The view sits on top of an OKI fact/staging table (identified by the KNW alias in the view text) and joins to several Oracle EBS lookup/validation tables to resolve codes into their business meanings.

Its practical role is to support sales and contract analytics: feeding Oracle Business Intelligence / Discoverer reports, dashboards, and downstream integrations that distinguish genuinely new commercial agreements from renewals. Because the underlying data is pre-aggregated with both transactional and reporting-set-of-books figures, the view is well suited for revenue trend analysis, win-rate reporting, and pipeline-versus-actual comparisons.

The search term contract_amount_renewed maps directly to this view. The view exposes NVL(KNW.CONTRACT_AMOUNT_RENEWED, 0) CONTRACT_AMOUNT_RENEWED and its SOB and base-currency counterparts, so even though the view reports "new" contracts, it still carries the renewed-amount column for completeness and reconciliation against the renewal view.

Underlying Base Objects

The ETRM metadata records no explicitly documented base objects for this view. From the embedded view text, the primary driving object is aliased KNW, an OKI contracts/sales fact table that supplies the bulk of projected columns. The remaining joins are lookup tables:

Key Columns

Common Use Cases and Queries

Typical uses include isolating new-contract bookings by period, comparing forecast versus actual, and analysing win percentage and amount renewed.

SELECT CONTRACT_NUMBER,
       CUSTOMER_NAME,
       CONTRACT_AMOUNT,
       CONTRACT_AMOUNT_RENEWED,
       CURRENCY_CODE,
       CLOSE_PERIOD_NAME,
       WIN_PERCENT
FROM   APPS.OKI_SALES_K_NEW_V
WHERE  START_YEAR = :p_year
ORDER  BY CONTRACT_AMOUNT DESC;

A second scenario reconciles renewed amounts across currencies for audit:

SELECT CONTRACT_ID,
       CONTRACT_AMOUNT_RENEWED,
       SOB_CONTRACT_AMOUNT_RENEWED,
       BASE_CONTRACT_AMOUNT_RENEWED
FROM   APPS.OKI_SALES_K_NEW_V
WHERE  CONTRACT_AMOUNT_RENEWED <> 0;

Because all amount columns are NVL-guarded, aggregate queries can sum without null-handling and safely feed OKI dashboards and EBS 12.1.1 / 12.2.2 reporting layers.