Search Results contract_count




Overview
Explore in AI Chat

Overview

OKI_RNW_BY_STS_DTL_V is a Contracts Intelligence reporting view that presents summarized information about renewal contracts grouped by contract status and General Ledger period. It belongs to the OKI product family, which is documented in Oracle EBS 12.1.1 and 12.2.2 as obsolete, meaning it is retained for backward compatibility but is not part of any current implementation path. The view is not implemented in the database according to its documented metadata; its definition exists only as reference text.

The view aggregates renewal activity into two distinct renewal process categories: expired contracts (RENEWAL_PROCESS_CODE = 'EXPIRED') and work-in-progress renewals (RENEWAL_PROCESS_CODE = 'WIP'). Each row represents a combination of period set, period type, period name, authoring organization, category, and status, with counts of distinct contracts and a converted base contract amount. Because of the base_currency_code column, the view is directly relevant to users investigating currency normalization in renewal reporting.

Underlying Base Objects

The view is defined over four base objects. OKI_SALES_K_HEADERS_V supplies contract header attributes such as authoring organization, organization name, category, and status. OKI_EXPIRED_LINES_V provides line-level pricing (BASE_PRICE_NEGOTIATED) and contract end dates for the expired branch. OKI_SALES_K_RENEW_V supplies renewal pipeline records, expected close dates, and a pre-computed BASE_CONTRACT_AMOUNT for the WIP branch. OKI_DAILY_RATES provides the currency conversion rate used to translate amounts into the reporting base currency.

GL_PERIODS is joined to map contract dates onto General Ledger period boundaries. No base objects are documented in the ETRM metadata, so the relationships above derive from the view text itself. The view also relies on two profile options at runtime: OKI_BASE_CURRENCY and JTF_PROFILE_DEFAULT_CURRENCY.

Key Columns

Common Use Cases and Queries

This view supports renewal pipeline analysis by accounting period, particularly for organizations that need amounts expressed in the OKI base currency. A typical query filters on the currency and process code to isolate renewed versus expired activity.

SELECT period_name, renewal_process_code, status_meaning, contract_count, base_currency_code, base_contract_amount FROM oki_rnw_by_sts_dtl_v WHERE base_currency_code = 'USD' AND renewal_process_code = 'WIP' ORDER BY period_name;

Another common pattern summarizes total renewal value by organization and category, providing a period-over-period view of renewal performance converted into the configured base currency. Because the object is documented as obsolete and not implemented, any SQL referencing it should be validated against the target environment before use, and migration to a supported Contracts Intelligence or service contracts reporting alternative is advisable.