Search Results action_session_ctrl

Overview

CZ_ACTIONSESSIONCTRL_LKV is a read-only view owned by the APPS schema within the Oracle E-Business Suite Configurator product (CZ). Its name encodes its purpose: it is a "lookup value" (LKV) view that exposes the action session control lookup set used by the Configurator runtime. The view filters the generic lookup values table to a single lookup type identified by the list name ACTION_SESSION_CTRL, presenting the seeded and user-defined control codes that govern behavior of a Configurator action session. In Oracle EBS 12.1.1 and 12.2.2 the view is defined as VALID and is available for reporting, diagnostics, and integration wherever an application or query needs the allowable values and descriptive labels for action session control without touching the full lookup table.

Underlying Base Objects

The documented dependency is a single base object: CZ_LOOKUP_VALUES_VL, itself a view in the APPS schema. CZ_LOOKUP_VALUES_VL is the Configurator's language-aware (VL = "view language") lookup values view, which resolves lookup value rows to the correct language. CZ_ACTIONSESSIONCTRL_LKV therefore inherits its column list and row semantics from that view, appending a restrictive predicate on LIST_NAME = 'ACTION_SESSION_CTRL'. Because the base object is a view and not a table, the effective lineage ultimately reaches the underlying Configurator lookup values storage, but from a documentation and support perspective the dependency to declare and validate is APPS.CZ_LOOKUP_VALUES_VL. No other base tables or views are documented for this object in ETRM 12.2.2.

Key Columns

The view exposes eleven columns, inherited directly from CZ_LOOKUP_VALUES_VL:

• LIST_NAME — the lookup type name; for this view it is always ACTION_SESSION_CTRL.
• DATA_VALUE — the internal coded value stored in configuration and processing logic.
• NUMERIC_ID_VALUE — numeric identifier associated with the lookup value where applicable.
• VALUE_SEQ — sort sequence controlling display order of valid values.
• DATA_TYPE_ID — identifier of the data type governing the value (for example text versus number).
• NULL_VALUE_FLAG — indicates whether a null value is permitted for the lookup entry.
• VALUE_LABEL — the translatable display label presented to users.
• VALUE_DESCRIPTION — longer descriptive text for the value.
• VALUE_NOTES — additional descriptive notes.
• LANGUAGE — the language of the returned label and description text.
• SOURCE_LANG — the source language from which the row was translated.

Common Use Cases and Queries

Typical uses include validating what action session control codes are seeded in a given instance, joining those codes to their labels in reports or interfaces, and exporting lookup values between environments during migration. A simple listing ordered for display is:

SELECT DATA_VALUE, VALUE_LABEL, VALUE_DESCRIPTION, VALUE_SEQ
FROM APPS.CZ_ACTIONSESSIONCTRL_LKV
ORDER BY VALUE_SEQ;

Because the view is already filtered to one list name, the LIST_NAME predicate need not be repeated. To resolve labels only for the session language, constrain on LANGUAGE. To confirm lineage or troubleshoot translation issues, query the base object directly:

SELECT DATA_VALUE, VALUE_LABEL, LANGUAGE, SOURCE_LANG
FROM APPS.CZ_LOOKUP_VALUES_VL
WHERE LIST_NAME = 'ACTION_SESSION_CTRL';

These queries are read-only and safe for reporting schemas, but any modification of the lookup values themselves must be performed through the Configurator lookup maintenance UI or the underlying maintenance APIs, never against this view.