Results for “ibc_content_types_b”

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

Overview

IBC_CONTENT_TYPES_B is a core table in the Oracle E-Business Suite Content Manager module (product code IBC). It stores abstract information about a group of similar content items, effectively acting as the master definition layer for content categories used throughout the content management framework. Each row defines a named content type that groups content items sharing common structural and behavioral characteristics, such as attributes, styling, and security constraints.

In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the IBC schema and holds a status of VALID. It participates in the Multilingual Support (MLS) architecture common to many EBS reference tables, working in conjunction with its translation table IBC_CONTENT_TYPES_TL. Under the 12.2.2 documented schema, the table contains 17 physical columns with a single-column surrogate primary key and a composite unique business-key candidate that incorporates the edition column used by the online patching (ZD_EDITION_NAME) framework.

From a data modeling perspective, the heuristic Data Vault classification of this table is hub-leaning. It is best regarded as a hub that holds the durable identity of each content type, referenced by multiple surrounding tables through the CONTENT_TYPE_CODE value.

Key Information Stored

The most significant columns of IBC_CONTENT_TYPES_B are:

• CONTENT_TYPE_CODE — The surrogate primary key and the central identifier referenced by all dependent tables. It is also the leading column of the unique index IBC_CONTENT_TYPES_B_U1, along with ZD_EDITION_NAME, making it the documented business-key candidate.
• CONTENT_TYPE_STATUS — Indicates the lifecycle or availability state of the content type definition, such as active or inactive.
• APPLICATION_ID — Identifies the owning Oracle application, linking the content type to a specific product or functional area.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling which security group owns the row and governing visibility across organizations.
• OWNER_FND_USER_ID — The FND user who owns the content type definition.
• ENCRYPT_FLAG — Indicates whether data associated with this content type is subject to encryption.
• OBJECT_VERSION_NUMBER — Supports optimistic locking during concurrent DML operations.
• ZD_EDITION_NAME — Edition discriminator supporting the Online Patching editioning model in 12.2.x.

The standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — provide audit tracking, while REQUEST_ID, PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, and PROGRAM_ID capture concurrent program context for programmatic inserts and updates.

Common Use Cases and Queries

Typical usage centers on enumerating available content types, joining them to their translated names, and reporting on content item distribution. A common query pattern retrieves content types with their descriptions:

SELECT ct.CONTENT_TYPE_CODE, ct.CONTENT_TYPE_STATUS, ctt.CONTENT_TYPE_NAME
FROM IBC_CONTENT_TYPES_B ct, IBC_CONTENT_TYPES_TL ctt
WHERE ct.CONTENT_TYPE_CODE = ctt.CONTENT_TYPE_CODE
AND ctt.LANGUAGE = USERENV('LANG');

Reporting the number of content items belonging to each type is another frequent scenario, joining to IBC_CONTENT_ITEMS on CONTENT_TYPE_CODE. Administrators also query this table to audit ownership (OWNER_FND_USER_ID) or to verify encryption policy (ENCRYPT_FLAG) across content categories.

Related Objects

• IBC_CONTENT_TYPES_TL — The translated (MLS) counterpart, joined on CONTENT_TYPE_CODE, supplying language-specific names and descriptions.
• IBC_CONTENT_ITEMS — Stores the actual content items, joined on CONTENT_TYPE_CODE, where each item belongs to a defined type.
• IBC_ATTRIBUTE_TYPES_B — Defines the attribute schema for each content type, referenced via CONTENT_TYPE_CODE.
• IBC_STYLESHEETS — Associates stylesheets with content types through CONTENT_TYPE_CODE.
• FND_SECURITY_GROUPS — The referenced parent of SECURITY_GROUP_ID, governing row-level security.