Incremental Workflow Directory Synchronization

Oracle Workflow (WF) automatically performs an initial synchronization of the user and role information in all the related originating systems during installation. Subsequently, you must continue synchronizing the user and role information from the source modules with the Workflow local tables.

For Oracle Trading Community Architecture (TCA), a patch automatically synchronizes that information with the information in the Workflow local tables on an incremental basis, using the Workflow local synchronization APIs. For more information on APIs, see: Directory Service APIs, Oracle Workflow API Reference.

Oracle Workflow references user and role information through three views based on the database tables that make up the Workflow Directory repository.

These views are based on local tables that are initially loaded by the WF directory's Synchronize WF LOCAL Tables concurrent program. WF_USERS is a view on top of WF_ROLES, which only returns roles that have the User flag set to Y. Users participate in their own roles, so an entry is created as a User Role for each user.

For more information, see: Synchronizing Workflow User and Role Information, in Setting Up an Oracle Workflow Directory Service.