Search Results variable_description




Overview
Explore in AI Chat

Overview

APPS.OKC_TERMS_GLOBAL_VAR_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 ETRM (Enterprise Contracts) module. It exposes global variable definitions used by the contract terms authoring framework, specifically those global variables that support user interface manipulations within the Contract Terms and Conditions (OKC) subsystem. The view consolidates variable metadata — name, description, code, datatype, and value set attributes — together with the runtime global value stored against a specific document. This dual purpose lets report and integration authors resolve both the structural definition of a variable and its current assigned value in a single query.

The object carries the standard Oracle warning: it is designated for Oracle Internal Use Only, and Oracle Corporation does not support direct access except through standard Oracle Applications programs. Consequently, it is best treated as a read-only reporting source rather than a supported integration interface.

Underlying Base Objects

Documented dependency metadata identifies three referenced objects:

  • OKC_BUS_VARIABLES_VL (VIEW) — the base view holding variable definitions, including the description, code, type, datatype, value set, and external flag columns.
  • OKC_K_ARTICLES_B (SYNONYM) — the contract articles base table, providing the document-type/document-id context for each article.
  • OKC_K_ART_VARIABLES (SYNONYM) — the article-to-variable association table, linking defined variables to specific contract articles and carrying the stored global value.

Because the view is internal and not referenced by any other database object, it functions as a leaf reporting object. Its columns are assembled by joining the variable definition view to the article-variable association, scoped by the owning article document.

Key Columns

Common Use Cases and Queries

Typical applications include auditing which global variables are defined across contract documents, validating value assignments, and diagnosing UI behavior driven by global variables. To retrieve all variables matching a description pattern:

  • SELECT variable_name, variable_description, variable_code, global_value FROM apps.okc_terms_global_var_v WHERE UPPER(variable_description) LIKE '%AMOUNT%';
  • SELECT document_type, document_id, variable_code, global_value FROM apps.okc_terms_global_var_v WHERE document_id = :doc_id;

These queries support reporting on contract term variable assignments; however, any write operations must be performed through standard ETRM application APIs rather than directly against this view or its base objects.