Results for “czbv_configuration_attributes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CZBV_CONFIGURATION_ATTRIBUTES is a read-only view in the Oracle E-Business Suite Bills of Material (BOM) module. It exposes configuration attribute definitions used by Oracle Configurator and the wider Configure-to-Order (CTO) model, presenting metadata about the attributes that describe configurable items and their options. In the context of Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration surface over the underlying attribute repository, allowing developers, integrators, and report authors to resolve attribute codes into human-readable names, labels, and default values without querying the base tables directly.

The view is documented as "Retrofitted" and is not implemented in every database, meaning its presence depends on whether the relevant Configurator attribute objects have been deployed in the environment. When present, it is typically used to drive the List of Values (LOV) behaviour associated with configuration attribute entry screens, as reflected by the LOV_REGION_CODE column that the user searched for.

Underlying Base Objects

The view text is defined over three base objects:

• AK_ATTRIBUTES_TL — the translated attribute definitions, joined on ATTRIBUTE_APPLICATION_ID and ATTRIBUTE_CODE with language restricted to USERENV('LANG').
• AK_ATTRIBUTES — the base attribute master records, providing value length, label length, and default value columns.
• FND_APPLICATION_VL — the application definition table, supplying the APPLICATION_NAME for the owning application.

A hard-coded filter restricts ATTRIBUTE_APPLICATION_ID to 702, the Oracle Configurator application identifier, so only attributes belonging to that application are returned. The view is defined WITH READ ONLY, preventing DML against it. Although the metadata lists no referenced base objects explicitly, the view text confirms the three tables above.

Key Columns

• CONFIGURATION_ATTRIBUTE_ID — identifier for the configuration attribute record.
• APPLICATION_NAME — the owning application, from FND_APPLICATION_VL.
• CONFIGURATION_ATTRIBUTE_NAME — the attribute code used internally to reference the attribute.
• "_LA:DATA_TYPE" — a flexfield-style descriptive column resolving the data type through the AK_LOOKUP_CODES lookup.
• VALUE_LENGTH — maximum permitted length for the attribute value.
• "_LA:UPPERCASE_FLAG" — indicates whether values are forced to upper case, resolved via the YES_NO lookup on FND_LOOKUPS.
• LABEL / LABEL_LENGTH — the user-facing label and its length.
• DEFAULT_CHARACTER_VALUE / DEFAULT_NUMBER_VALUE — default values used when no explicit value is supplied.
• ATTRIBUTE_APPLICATION_ID — application owning the attribute (702 in this view).
• LOV_REGION_CODE — the region code that controls which List of Values is presented for the attribute, directly relevant to runtime LOV resolution.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include validating attribute definitions, resolving LOV behaviour for configurable items, and generating metadata extracts. A representative query retrieves all attributes for a specific label or LOV region:

• List all configuration attributes with their data types and labels: SELECT CONFIGURATION_ATTRIBUTE_NAME, LABEL, "_LA:DATA_TYPE" FROM CZBV_CONFIGURATION_ATTRIBUTES;
• Find attributes tied to a particular LOV region: SELECT CONFIGURATION_ATTRIBUTE_NAME, LOV_REGION_CODE, LABEL FROM CZBV_CONFIGURATION_ATTRIBUTES WHERE LOV_REGION_CODE = :region_code;
• Inspect default values and value lengths for integration mapping: SELECT CONFIGURATION_ATTRIBUTE_NAME, DEFAULT_CHARACTER_VALUE, DEFAULT_NUMBER_VALUE, VALUE_LENGTH FROM CZBV_CONFIGURATION_ATTRIBUTES;

Because the view is read-only and restricted to application 702, it is safe for reporting purposes. Where the object is not present, equivalent information must be gathered directly from AK_ATTRIBUTES and AK_ATTRIBUTES_TL. All documentation is Oracle Proprietary and Confidential Information.