Results for “wms_db_objects_parents_u1”

6 results




Overview
Explore in AI Chat

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

Overview

The WMS.WMS_DB_OBJECTS_PARENTS table is a Warehouse Management System (WMS) reference table that stores parent-child relationships between database objects registered within the WMS schema. It belongs to the WMS - Warehouse Management product family and resides in the WMS schema. The table is classified as VALID in the EBS data dictionary and is part of the standard Oracle E-Business Suite 12.1.1 and 12.2.2 installation.

Within the Oracle EBS data model, this object functions as a junction table that maps individual WMS database objects (referenced through DB_OBJECT_ID) to their hierarchical parents. This supports dependency resolution and metadata organization for WMS-internal database objects such as tables, views, indexes, and PL/SQL units. Based on heuristic Data Vault classification mined from the foreign key structure, WMS_DB_OBJECTS_PARENTS is satellite-leaning — that is, it primarily carries descriptive attributes and hierarchical context surrounding a parent entity (WMS_DB_OBJECTS) rather than serving as a pure hub or link. This classification is a modeling suggestion, not a prescriptive constraint.

Key Information Stored

The table contains 25 documented columns. The most significant ones, from a functional and modeling standpoint, include:

  • DB_OBJECT_ID — Foreign key to WMS_DB_OBJECTS. Identifies the child database object whose lineage is being recorded.
  • TYPE_CODE — Categorizes the object or relationship type. Together with DB_OBJECT_ID it forms the primary key.
  • PARENT_DB_OBJECT_ID — References the parent database object. This is the column that enables hierarchical traversal across the WMS object tree.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns tracking audit lineage.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The DFF (Descriptive Flexfield) segment columns, supporting customer extensions without schema alteration.
  • ZD_EDITION_NAME — The editioning column introduced in EBS 12.2.2 as part of the Online Patching (ADOP) architecture for edition-based redefinition.

Two key constraints govern uniqueness. The primary key, WMS_DB_OBJECTS_PARENT_PK, is defined on (DB_OBJECT_ID, TYPE_CODE). A unique index, WMS_DB_OBJECTS_PARENTS_U1, is defined on (DB_OBJECT_ID, TYPE_CODE, ZD_EDITION_NAME), which serves as the business-key candidate once the edition dimension is included. This second index is essential in 12.2.2 environments because unique constraints must incorporate ZD_EDITION_NAME to permit multiple editions during patch cycles.

Common Use Cases and Queries

The most common uses involve resolving object dependency chains and reporting on WMS database object hierarchies. A typical parent lookup joins the table to itself or to WMS_DB_OBJECTS:

  • Direct parent resolution: SELECT p.db_object_id, p.parent_db_object_id FROM wms.wms_db_objects_parents p WHERE p.db_object_id = :object_id;
  • Hierarchy traversal via self-join: joining PARENT_DB_OBJECT_ID back to DB_OBJECT_ID to walk multiple levels.
  • Object-type filtering: constraining on TYPE_CODE to isolate, for example, only table-to-view parent links.
  • Audit lineage reports: using the WHO columns to determine when relationships were created or modified.
  • DFF extraction: querying ATTRIBUTE_CATEGORY and ATTRIBUTE1-15 for customer-defined metadata captured against object relationships.

Because this is a metadata/registry table rather than a transactional one, it is usually accessed read-only by diagnostics, dependency-check utilities, and customization audits rather than in day-to-day WMS transaction flows.

Related Objects

  • WMS.WMS_DB_OBJECTS — Referenced through WMS_DB_OBJECTS_PARENTS.DB_OBJECT_ID. This is the primary foreign key target and the hub entity of this relationship.
  • WMS_DB_OBJECTS_PARENTS (self) — Logical self-reference implied by PARENT_DB_OBJECT_ID → DB_OBJECT_ID for hierarchy traversal.
  • WMS_DB_OBJECTS_PARENTS_PK — The primary key constraint on (DB_OBJECT_ID, TYPE_CODE).
  • WMS_DB_OBJECTS_PARENTS_U1 — The unique index on (DB_OBJECT_ID, TYPE_CODE, ZD_EDITION_NAME), required for 12.2.2 editioning.
  • AD_ZD_* dictionary views — Online Patching views that surface edition-aware object metadata congruent with ZD_EDITION_NAME.

Collectively, these objects form the WMS metadata registry used for object dependency resolution within Oracle Warehouse Management.