Search Results oki_base_currency

Overview

OKI_RNW_BY_STS_DTL_V is an Oracle E-Business Suite reporting view owned by the APPS schema and delivered as part of the Oracle Knowledge and Information (OKI) module, which underpins the Service Contracts renewal and entitlement tracking functionality. The view consolidates renewal activity into a single, aggregated data set partitioned by General Ledger period, operating organization, contract category, and contract status. Its distinguishing characteristic is the exposure of a derived column named renewal_process_code, which classifies each summarized row into a distinct phase of the renewal lifecycle. In the documented excerpt these phases include the literal value 'Expired' for renewal lines whose end date has passed, and 'WIP' for sales contracts that have been entered but not yet closed. A third UNION branch continues in the source definition but is truncated in the metadata.

The view functions primarily as a reporting and analysis object rather than a transactional entry point. It allows operational and financial users to measure the count of contracts and the base-currency value of renewal business at each stage of the renewal process, without needing to join the underlying header, line, exchange-rate, and accounting-period tables manually.

Underlying Base Objects

The view is defined over four underlying objects, combined through three UNION branches. The documented base objects are:

• OKI_SALES_K_HEADERS_V — the sales contract header view, supplying authoring organization, category, status, and contract identifiers.
• OKI_EXPIRED_LINES_V — the expired contract line view, driving the 'Expired' branch.
• oki_sales_k_renew_v — the renewal contract view, filtering rows where status_type_code = 'ENTERED' for the 'WIP' branch.
• OKI_DAILY_RATES — the daily currency conversion table, joined on the base currency and the default reporting currency.
• GL_PERIODS — the accounting period definition table, used to bucket transactions by period_set_name, period_type, and period_name.

Although the ETRM metadata listed no documented base tables, the view text clearly joins these sources. The currency logic converts amounts from the profile value OKI_BASE_CURRENCY to the profile value JTF_PROFILE_DEFAULT_CURRENCY.

Key Columns

• renewal_process_code — the classification column central to this view; documented values include 'Expired' and 'WIP'.
• period_set_name, period_type, period_name — the GL period attributes used for time-based aggregation.
• authoring_org_id, organization_name — the owning organization of the contract.
• category_code, category_meaning — the contract category classification.
• status_code, status_meaning — the contract lifecycle status.
• contract_count — a distinct count of contracts for the expired branch and a plain count for the renewal branch.
• base_contract_amount — the sum of negotiated or negotiated contract value converted to the base currency.
• base_currency_code — the base currency derived from OKI_BASE_CURRENCY.

Common Use Cases and Queries

The view supports renewal pipeline dashboards, period-close reporting, and reconciliation of renewal revenue by process stage. A typical query groups output by process code and period:

SELECT renewal_process_code,
       period_name,
       organization_name,
       SUM(contract_count)      total_contracts,
       SUM(base_contract_amount) total_amount
FROM   apps.oki_rnw_by_sts_dtl_v
WHERE  period_name = :p_period
GROUP  BY renewal_process_code, period_name, organization_name;

Analysts frequently filter on renewal_process_code to isolate expired versus in-progress renewals, and join to GL period definitions when building period-over-period trend reports.