Search Results sr_attribute_value




Overview
Explore in AI Chat

Overview

APPS.CUG_INCIDNT_ATTR_VALS_VL is a multi-lingual (translated) view in the Oracle E-Business Suite Citizen Interaction Center (CUG) product family. It is the runtime attribute capture form view, presenting the attribute values that are collected against a service request or incident at the moment the interaction is processed. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema with a status of VALID and is documented as the view "for the run time attribute capture form," joining the base table CUG_INCIDNT_ATTR_VALS_B with its translation table CUG_INCIDNT_ATTR_VALS_TL.

Because the view appends a "_VL" suffix and filters the translation table by the session language, it exposes the base (language-independent) attribute value rows alongside the language-specific SR_ATTRIBUTE_VALUE text, providing the correct translated value for the current user environment. This makes it suitable for reporting, OAF/Forms runtime display, and integration extracts where attribute values must be returned in the caller's language rather than in a fixed language.

Underlying Base Objects

The view is defined over two documented base objects, referenced through APPS synonyms:

  • CUG_INCIDNT_ATTR_VALS_B (SYNONYM) — the base table holding language-independent incident/attribute-value rows. It contributes identity, auditing, ownership, DFF, and the SR_ATTRIBUTE_CODE and OVERRIDE_ADDR_VALID_FLAG columns.
  • CUG_INCIDNT_ATTR_VALS_TL (SYNONYM) — the translation table holding the language-specific SR_ATTRIBUTE_VALUE. It is joined to the base on INCIDNT_ATTR_VAL_ID and restricted by T.LANGUAGE = USERENV('LANG'), so exactly one translation row per value is returned for the session language.

The join predicate is B.INCIDNT_ATTR_VAL_ID = T.INCIDNT_ATTR_VAL_ID. No other join or filter conditions are present in the documented view text; the language predicate is the only restriction that shapes the result set. The view also exposes B.ROWID as ROW_ID, which permits the view to be used in contexts requiring a pseudo-row identifier (for example, certain DML or updatable-view scenarios). This is a standard EBS _VL pattern combining a _B table and a _TL table.

Key Columns

  • ROW_ID — pseudo-column from the base table ROWID (B.ROWID).
  • INCIDNT_ATTR_VAL_ID — primary key of the attribute value row; the join key between the base and translation tables.
  • OBJECT_VERSION_NUMBER — optimistic locking/version column used by the OAF framework.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard EBS who-columns describing row creation and last modification.
  • INCIDENT_ID — the parent incident/interaction to which the captured attribute value belongs.
  • SR_ATTRIBUTE_CODE — code identifying the service-request attribute being captured. This is the column most commonly associated with the search term "sr_attribute_value."
  • OVERRIDE_ADDR_VALID_FLAG — flag indicating that address validation is overridden for the captured value.
  • ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield (DFF) context and segment columns providing extensible, customer-defined attributes.
  • SR_ATTRIBUTE_VALUE — the language-specific, translated value of the captured attribute, sourced from CUG_INCIDNT_ATTR_VALS_TL and returned for the session language.

Common Use Cases and Queries

Typical uses include reporting captured attribute values for incidents in the user's language, feeding downstream integrations, and building UI/LOV queries where the SR attribute code and value are both required. Because language filtering is automatic, callers never need to reference the _TL table directly.

Listing all attribute values for an incident:

  • SELECT incident_id, sr_attribute_code, sr_attribute_value FROM apps.cug_incidnt_attr_vals_vl WHERE incident_id = :p_incident_id;

Filtering by attribute code (the "sr_attribute_value" search):

  • SELECT incidnt_attr_val_id, incident_id, sr_attribute_code, sr_attribute_value FROM apps.cug_incidnt_attr_vals_vl WHERE sr_attribute_code = :p_code AND attribute_category = :p_category;

Extracting code/value pairs for integration, including DFF context:

  • SELECT incident_id, sr_attribute_code, sr_attribute_value, attribute_category, attribute1, attribute2 FROM apps.cug_incidnt_attr_vals_vl WHERE incident_id IN (:p_incident_ids);

Standard constraints apply: queries should be granted SELECT on APPS objects, use bind variables to avoid literal SQL, and rely on INCIDENT_ID or SR_ATTRIBUTE_CODE for selective predicates where possible. The view is read-oriented and primarily supports reporting and runtime capture rather than direct update.

  • View: CUG_INCIDNT_ATTR_VALS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_INCIDNT_ATTR_VALS_VL,  object_name:CUG_INCIDNT_ATTR_VALS_VL,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This is the multi-lingual view for the run time attribute capture form. Joins the tables CUG_INCIDNT_ATTR_VALS_B and CUG_INCIDNT_ATTR_VALS_TL. ,  implementation_dba_data: APPS.CUG_INCIDNT_ATTR_VALS_VL , 

  • View: CUG_TSK_TYP_ATTR_DEPS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_TSK_TYP_ATTR_DEPS_VL,  object_name:CUG_TSK_TYP_ATTR_DEPS_VL,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This is the multi-lingual view used for the configuration of the Service Reqiest Type- Task Type Attribute capture form. Joins the tables CUG_TSK_TYP_ATTR_DEPS_B and CUG_TSK_TYP_ATTR_DEPS_B . ,  implementation_dba_data: APPS.CUG_TSK_TYP_ATTR_DEPS_VL , 

  • View: CUG_INCIDNT_ATTR_VALS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_INCIDNT_ATTR_VALS_VL,  object_name:CUG_INCIDNT_ATTR_VALS_VL,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This is the multi-lingual view for the run time attribute capture form. Joins the tables CUG_INCIDNT_ATTR_VALS_B and CUG_INCIDNT_ATTR_VALS_TL. ,  implementation_dba_data: APPS.CUG_INCIDNT_ATTR_VALS_VL , 

  • View: CUG_TSK_TYP_ATTR_DEPS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_TSK_TYP_ATTR_DEPS_VL,  object_name:CUG_TSK_TYP_ATTR_DEPS_VL,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This is the multi-lingual view used for the configuration of the Service Reqiest Type- Task Type Attribute capture form. Joins the tables CUG_TSK_TYP_ATTR_DEPS_B and CUG_TSK_TYP_ATTR_DEPS_B . ,  implementation_dba_data: APPS.CUG_TSK_TYP_ATTR_DEPS_VL , 

  • View: CUG_INCIDNT_ATTR_VALS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_INCIDNT_ATTR_VALS_V,  object_name:CUG_INCIDNT_ATTR_VALS_V,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This view is used by the Run time form to capture the details of a Service Request specific to CIC application. The details include Incident Address, Over ride Address Validation Flag and the SR attributes. ,  implementation_dba_data: APPS.CUG_INCIDNT_ATTR_VALS_V , 

  • View: CUG_INCIDNT_ATTR_VALS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CUG.CUG_INCIDNT_ATTR_VALS_V,  object_name:CUG_INCIDNT_ATTR_VALS_V,  status:VALID,  product: CUG - Citizen Interaction Center ,  description: This view is used by the Run time form to capture the details of a Service Request specific to CIC application. The details include Incident Address, Over ride Address Validation Flag and the SR attributes. ,  implementation_dba_data: APPS.CUG_INCIDNT_ATTR_VALS_V ,