Previous  Next          Contents  Index  Glossary  Library

Integrating Oracle Workflow Directory Services with a Unified Oracle Applications Environment

If you are using the version of Oracle Workflow embedded in Oracle Applications, your Oracle Workflow directory service views are automatically based on a unified Oracle Applications environment. The unified environment includes joins to tables in Oracle Human Resources, Oracle Application Object Library, and various other Oracle Applications, as well as to the WF_LOCAL tables.

Oracle Workflow provides a sql script that defines the WF_USERS, WF_ROLES, and WF_USER_ROLES views to map to this unified environment. When you install Oracle Applications, you automatically install this script to create the unified environment. However, if you should need to edit and rerun this script for whatever reason, the script is called wfdirhrv.sql and is located on your server in the sql subdirectory under $FND_TOP.

Aside from the users and roles stored in WF_LOCAL_USERS and WF_LOCAL_ROLES, the default notification preference for all workflow users and roles in the unified environment is set to 'MAILHTML'.

See Also

Setting Up an Oracle Workflow Directory Service

         Previous  Next          Contents  Index  Glossary  Library