Search Results change_sequence

Overview

OKC_CHANGES_V is a validation view in the Oracle E-Business Suite Contracts Core (OKC) module, owned by the APPS schema. It presents a denormalized, language-aware read interface over the contract change history stored in the underlying OKC_CHANGES_B and OKC_CHANGES_TL tables. Its primary purpose is to expose change records — each representing a discrete modification applied to a contract — together with their translated text attributes, so that forms, concurrent programs, and reporting integrations can retrieve change information without joining the base and translation tables directly.

This view is documented in ETRM for both Oracle EBS 12.1.1 and 12.2.2. Users frequently locate it while researching the change_sequence attribute, which is exposed by the view from the OKC_CHANGES_B base table and identifies the ordinal position of a change within a contract's change history. The view masks the multi-language table design (TL) and the base table (B) by resolving the language at runtime through USERENV('LANG'), ensuring callers always see change text in the session's current language.

Underlying Base Objects

The view is defined over two documented base objects, both referenced by synonym in the APPS schema:

• OKC_CHANGES_B — the base table holding language-independent change attributes such as the change ID, object version number, change sequence, CRT reference, descriptive flexfield (DFF) attribute columns, and the standard WHO audit columns.
• OKC_CHANGES_TL — the translation table holding language-dependent text: CHANGE_TEXT, SHORT_DESCRIPTION, and the SFWT_FLAG used to indicate whether the translated text has been submitted for translation.

The two tables are joined on ID (CORB.ID = CORT.ID) with the additional predicate CORT.LANGUAGE = USERENV('LANG'), restricting the translation row to the caller's language. ROW_ID is drawn from the base table's ROWID, providing a stable physical row identifier for the view.

Key Columns

• ROW_ID — the ROWID of the corresponding OKC_CHANGES_B row; commonly used in DML-capable view contexts.
• ID — the unique change identifier, used as the join key between the base and translation tables.
• CHANGE_SEQUENCE — the ordinal number of the change; this is the column most frequently sought by users researching change history ordering and is the natural sort key for reporting.
• OBJECT_VERSION_NUMBER — optimistic locking column reflecting the version of the change record.
• CRT_ID — reference to the parent contract or contract line to which the change belongs.
• CHANGE_TEXT / SHORT_DESCRIPTION — translated narrative and summary text describing the change (from OKC_CHANGES_TL).
• SFWT_FLAG — "submitted for translation" indicator for the translated text.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–15 — descriptive flexfield segments available for contract change records.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include reporting the change history for a contract in sequence order, auditing who changed what and when, and integrating change data into downstream systems. A common query retrieves all changes for a given contract ordered by change sequence:

SELECT change_sequence, id, crt_id, short_description, change_text,
       created_by, creation_date
FROM   okc_changes_v
WHERE  crt_id = :p_contract_id
ORDER BY change_sequence;

Because the translation join is resolved via USERENV('LANG'), callers should ensure the session language is set appropriately, or the change text may return in the base language unexpectedly. To identify the latest change for a contract:

SELECT *
FROM   okc_changes_v v
WHERE  v.crt_id = :p_contract_id
AND    v.change_sequence =
       (SELECT MAX(change_sequence)
        FROM   okc_changes_v
        WHERE  crt_id = :p_contract_id);

The view is primarily read-oriented for reporting and integration; direct DML is generally performed against the base tables or through the Contracts forms, with the view serving as the standard query interface for change records across releases.