Search Results cug_incidnt_attr_vals_b




Overview
Explore in AI Chat

Overview

The CUG_INCIDNT_ATTR_VALS_B table is a core data object within the Oracle E-Business Suite Citizen Interaction Center (CUG) module. It functions as the primary repository for storing the runtime values of configurable Service Request (SR) attributes. These attributes are defined for specific Service Request Types, allowing for the capture of extended, type-specific information beyond the standard incident fields. The table's role is critical for enabling flexible data collection and tracking within the service request management process, directly supporting the customization of the incident handling workflow in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores the linkage between a service request, a specific attribute, and its assigned value. The primary identifier for each stored attribute value is the INCIDNT_ATTR_VAL_ID. The two most significant business key columns are SR_ATTRIBUTE_CODE, which identifies the specific configurable attribute (e.g., 'PRIORITY_CODE', 'ASSET_NUMBER'), and INCIDENT_ID, which links the value to a specific service request in the CS_INCIDENTS_ALL_B table. Together, these columns form a unique constraint (INCIDNT_ATTR_VALS_B_UK1), ensuring only one value per attribute per incident is stored. The table likely contains additional columns to hold the actual attribute value (potentially in a generic format or referenced elsewhere) and standard WHO columns for auditing.

Common Use Cases and Queries

A primary use case is generating reports that include custom SR attribute data. For instance, an organization can query all service requests of a specific type to analyze values for a custom "Resolution Code" attribute. Another common scenario involves data validation or migration scripts that need to access or update these extended attributes. A sample query to retrieve attribute values for a specific incident would be:

  • SELECT sr_attribute_code, [value_column] FROM cug_incidnt_attr_vals_b WHERE incident_id = <incident_id>;

Given the user's search for "sr_attribute_code," a typical development or support task involves finding all incidents where a particular custom attribute is set: SELECT incident_id FROM cug_incidnt_attr_vals_b WHERE sr_attribute_code = '<ATTRIBUTE_CODE>';

Related Objects

The table is centrally connected to other key EBS objects through documented foreign key relationships. Its primary link to the Service Requests core table is via the INCIDENT_ID column, which references CS_INCIDENTS_ALL_B. This establishes the fundamental connection between an extended attribute value and its parent service request. For translatable attributes, the table is the source for the related Translation table, CUG_INCIDNT_ATTR_VALS_TL, which is joined using the primary key INCIDNT_ATTR_VAL_ID. This TL table stores language-specific versions of the attribute values where applicable.