Search Results wf_directory_partitions




Overview
Explore in AI Chat

Overview

WF_DIRECTORY_PARTITIONS is a reference (lookup) table owned by the APPLSYS schema within the FND — Application Object Library product of Oracle E-Business Suite. Its documented purpose is to serve as a lookup table for origin systems (ORIG_SYSTEM) associated with partitioned tables in the Oracle Workflow directory architecture. In both EBS 12.1.1 and 12.2.2, the Oracle Workflow directory services rely on partitioning to scale the resolution of users, roles, and security groups across large installations, and this table provides the mapping layer that identifies which originating system each directory partition belongs to.

The table is classified as VALID in the ETRM metadata, and its heuristic Data Vault classification is standalone. From a dimensional modeling perspective, this suggests the table behaves as an independent reference or lookup entity rather than participating in a classic hub-and-link hub-and-satellite structure. Where a Data Vault hub would normally anchor a business key, WF_DIRECTORY_PARTITIONS functions instead as a narrow reference table keyed on ORIG_SYSTEM, with no downstream dependent satellites identified in the mined relationship data.

Key Information Stored

The table contains 10 documented columns. The surrogate primary key is defined by the constraint WF_DIRECTORY_PARTITIONS_PK on the ORIG_SYSTEM column. A separate unique index, WF_DIRECTORY_PARTITIONS_U1, is defined on the composite of (ORIG_SYSTEM, ZD_EDITION_NAME), making it the documented business-key candidate and reflecting the Online Patching (adop) editioning model introduced in EBS 12.2.

  • ORIG_SYSTEM — The origin system identifier; serves as the primary key and is the central lookup value.
  • PARTITION_ID — References the partition definition in JTF_FM_PARTITION_X_REQUEST, linking the origin system to its partitioned request scope.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, associating the partition with a security group for access control.
  • ZD_EDITION_NAME — The editioning column used by Online Patching; participates in the unique business key.
  • LAST_UPDATE_DATE — Standard EBS audit column recording the last modification timestamp.
  • ROLE_VIEW, USER_ROLE_VIEW, ROLE_TL_VIEW — View definitions that govern how role, user-role, and translated role data are exposed for the origin system.
  • BULKSYNC_DATE — Timestamp of the last bulk synchronization operation for the partition.
  • SUMMARY_DATE — Timestamp associated with summary or aggregation processing for the origin system.

Common Use Cases and Queries

Typical usage centers on diagnosing Workflow directory synchronization and partition resolution. A common pattern joins the table to security groups and partition requests:

  • Identifying all origin systems for a given security group, useful during access troubleshooting.
  • Auditing which partitions have not been bulk-synchronized recently by filtering on BULKSYNC_DATE.
  • Confirming editioning behavior by querying ZD_EDITION_NAME in a 12.2 environment.

A representative query follows:

SELECT wd.ORIG_SYSTEM, wd.PARTITION_ID, wd.SECURITY_GROUP_ID, wd.BULKSYNC_DATE FROM APPLSYS.WF_DIRECTORY_PARTITIONS wd WHERE wd.SECURITY_GROUP_ID = :p_security_group_id;

Reporting use cases include monitoring synchronization lag and validating that each origin system is correctly mapped to its partition request.

Related Objects

  • JTF_FM_PARTITION_X_REQUEST — Referenced by WF_DIRECTORY_PARTITIONS.PARTITION_ID; supplies partition request definitions.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; defines security group membership.
  • WF_DIRECTORY_PARTITIONS_PK — Primary key constraint on ORIG_SYSTEM.
  • WF_DIRECTORY_PARTITIONS_U1 — Unique index on (ORIG_SYSTEM, ZD_EDITION_NAME).
  • Associated Workflow directory views exposing ROLE_VIEW, USER_ROLE_VIEW, and ROLE_TL_VIEW.