Search Results ibc_content_types_b




Overview
Explore in AI Chat

Overview

The IBC_CONTENT_TYPES_B table is a core repository table within the Oracle E-Business Suite Content Manager (IBC) module. It functions as the master definition table for content types, which are abstract classifications used to group similar content items. Every content item managed within the system must be associated with a defined content type. This table stores the fundamental, non-translatable attributes of these types, establishing the structural framework for content categorization, attribute management, and presentation logic across the application.

Key Information Stored

The primary column in this table is CONTENT_TYPE_CODE, which serves as the unique identifier (primary key) for a content type. This code is a mandatory, internal key referenced throughout the content management schema. While the provided ETRM metadata does not list all columns, typical columns in such a base table include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and likely columns controlling the type's behavior, such as status flags or configuration options. The human-readable name and description for each content type are stored not in this base table, but in the corresponding translation table, IBC_CONTENT_TYPES_TL, linked via the CONTENT_TYPE_CODE.

Common Use Cases and Queries

This table is central to administrative setup and reporting on the content repository. Common operational scenarios include querying all defined content types to understand the content taxonomy or validating a content type code before creating new items. A typical query would join the base table with its translation table to retrieve a user-friendly list. For example:

  • SELECT b.content_type_code, tl.name, tl.description FROM ibc_content_types_b b, ibc_content_types_tl tl WHERE b.content_type_code = tl.content_type_code AND tl.language = USERENV('LANG');

This table is also critical for data integrity when performing data migrations or integrations, ensuring that any incoming content data references a valid, pre-defined CONTENT_TYPE_CODE.

Related Objects

IBC_CONTENT_TYPES_B is a pivotal parent table with several key foreign key relationships, as documented in the ETRM. The CONTENT_TYPE_CODE column is referenced by:

  • IBC_CONTENT_ITEMS (via CONTENT_TYPE_CODE): This is the primary relationship, linking the type definition to the actual content instances.
  • IBC_ATTRIBUTE_TYPES_B (via CONTENT_TYPE_CODE): Associates specific metadata attributes (custom fields) with a content type.
  • IBC_STYLESHEETS (via CONTENT_TYPE_CODE): Defines presentation stylesheets applicable to a content type.
  • IBC_CONTENT_TYPES_TL (via CONTENT_TYPE_CODE): The translation table holding the multilingual names and descriptions.

These relationships enforce that all content items, their attributes, and their presentation rules are governed by a valid master content type definition.