Search Results ibc_directory_nodes_b




Overview
Explore in AI Chat

Overview

The IBC_DIRECTORY_NODES_B table is a core data object within the Oracle E-Business Suite Content Manager module (IBC). It serves as the master repository for defining all directory nodes, which are the fundamental structural elements of the content management system's folder hierarchy. These nodes function as containers or logical groupings for organizing content items, enabling a structured, navigable, and secure repository for digital assets and documents. Its role is critical for establishing the taxonomy and parent-child relationships that govern how content is stored, categorized, and accessed across the E-Business Suite.

Key Information Stored

As a base table, IBC_DIRECTORY_NODES_B primarily stores the system-generated identifiers and essential attributes for each node. The primary key, DIRECTORY_NODE_ID, is the unique numeric identifier for every directory node in the system. While the provided ETRM metadata does not list all columns, standard practice for Oracle EBS base tables indicates it likely contains core columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and OBJECT_VERSION_NUMBER for data auditing and concurrency control. The table's structure is designed to hold the invariant, non-translatable data for a directory node, with translatable attributes like the node name stored in the associated IBC_DIRECTORY_NODES_TL table.

Common Use Cases and Queries

This table is central to operations involving content directory navigation, security, and reporting. Common use cases include generating a complete directory tree for user interfaces, applying access control policies at the folder level, and locating all content within a specific branch of the hierarchy. A fundamental query retrieves the hierarchical relationship between nodes, often joining to IBC_DIRECTORY_NODE_RELS. For example, to find all child nodes of a specific parent, one might use a query such as: SELECT child.DIRECTORY_NODE_ID FROM IBC_DIRECTORY_NODES_B parent, IBC_DIRECTORY_NODE_RELS rel, IBC_DIRECTORY_NODES_B child WHERE parent.DIRECTORY_NODE_ID = :p_parent_node_id AND parent.DIRECTORY_NODE_ID = rel.PARENT_DIR_NODE_ID AND rel.CHILD_DIR_NODE_ID = child.DIRECTORY_NODE_ID;. Reporting on directory structure or validating data integrity also frequently involves this table.

Related Objects

The IBC_DIRECTORY_NODES_B table has integral relationships with several other key Content Manager tables, as documented by its foreign key constraints. The primary key (DIRECTORY_NODE_ID) is referenced by:

  • IBC_CONTENT_ITEM_NODES via DIRECTORY_NODE_ID: Links content items to their assigned directory nodes.
  • IBC_CONTENT_ITEMS via DIRECTORY_NODE_ID: Associates content items with a primary directory node.
  • IBC_DIRECTORY_NODES_TL via DIRECTORY_NODE_ID: Stores the translated names and descriptions for each directory node.
  • IBC_DIRECTORY_NODE_RELS via PARENT_DIR_NODE_ID and CHILD_DIR_NODE_ID: Defines the hierarchical parent-child relationships between directory nodes themselves.
These relationships underscore the table's position as the central hub for the content directory structure.