Search Results ibc_attribute_types_b




Overview
Explore in AI Chat

Overview

The IBC_ATTRIBUTE_TYPES_B table is a core data definition table within the Oracle E-Business Suite Content Manager (IBC) module. It serves as the master repository for defining the structure and permissible attributes for different content types within the system. In essence, for each content type (e.g., Document, Image, Web Page), this table stores the metadata that defines what custom attributes can be associated with content items of that type. This enables the flexible extension of content objects beyond their standard fields, allowing organizations to tailor the Content Manager to specific business data requirements. Its role is foundational to the content modeling capabilities of Oracle EBS.

Key Information Stored

The table's structure centers on the composite primary key of ATTRIBUTE_TYPE_CODE and CONTENT_TYPE_CODE, which uniquely identifies an attribute definition within a specific content type. Key columns include ATTRIBUTE_TYPE_CODE, which names the attribute; CONTENT_TYPE_CODE, which links to the parent content type in IBC_CONTENT_TYPES_B; and DATA_TYPE, which defines the format of the attribute's value (e.g., VARCHAR2, NUMBER, DATE). The FLEX_VALUE_SET_ID column is critical for validation, as it can reference a value set (FND_FLEX_VALUE_SETS) to provide a list of valid values for the attribute, enforcing data integrity. Other important columns govern behavior, such as REQUIRED_FLAG, DISPLAY_SEQUENCE for UI ordering, and ENABLED_FLAG to control active status.

Common Use Cases and Queries

A primary use case is administering the content model, such as retrieving all active attributes for a specific content type for reporting or integration purposes. Developers and administrators frequently query this table to understand the extended data model or to validate configurations. Common SQL patterns include joining to the translated table (IBC_ATTRIBUTE_TYPES_TL) for user-friendly names and to FND_FLEX_VALUE_SETS for validation details.

  • Listing all attributes for the 'DOCUMENT' content type:
    SELECT atb.attribute_type_code, tl.name, atb.data_type, atb.required_flag FROM ibc_attribute_types_b atb, ibc_attribute_types_tl tl WHERE atb.content_type_code = 'DOCUMENT' AND atb.enabled_flag = 'Y' AND atb.attribute_type_code = tl.attribute_type_code AND atb.content_type_code = tl.content_type_code AND tl.language = USERENV('LANG') ORDER BY atb.display_sequence;
  • Identifying attributes that use a specific value set for validation:
    SELECT attribute_type_code, content_type_code FROM ibc_attribute_types_b WHERE flex_value_set_id = [VALUE_SET_ID];

Related Objects

As indicated by the foreign key constraints, IBC_ATTRIBUTE_TYPES_B has integral relationships with several key objects. It is a child of IBC_CONTENT_TYPES_B, defining attributes for each type. The IBC_ATTRIBUTE_TYPES_TL table provides translated names and descriptions for the attributes. For validation, it references FND_FLEX_VALUE_SETS from the application foundation. Furthermore, it is referenced by IBC_COMPOUND_RELATIONS, which uses the attribute definition to establish relationships between different content items. In practice, content attribute data for specific items is stored in related transactional tables, not in this definitional table itself.