Oracle workflow objects can be saved into database or into a file. So We can treat Oracle workflow objects as both file system objects and database objects. We save workflow object into file when working on local system either for development / enhancement or debugging. When you execute the workflow from server it will always […]
Oracle Business events are like Triggers. So we have event (Business event) based on which an action can be performed. There are two kinds of business events 1)Oracle provided business events / Seeded Business Events 2) Custom Business Events, which we create as per our business needs.
In most of the cases we just need to create an action for a seeded business event. Oracle Corp knows most of the business requirements and they have provided us with many seeded business events which are ready to use.
— Script to Create oracle workflow ad hoc roles — Script to Add user to already existing Adhoc Role — Script to Remove user from existing Adhoc Role — workflow ad hoc Role Tables Incase of any issues with Roles try running the below concurrent programs. 1. Workflow Directory Services user/Role Validation 2. Synchronize WF […]
It is very common requirement to stop workflow notifications going out of the system, particularly from Development instances and Test instances. Oracle have given a functionality “workflow override email address” to achieve this requirement. In Many companies this task is done by Database Administrators (DBA) but incase you need to do it yourself you follow […]
Functional Setup For setting up standard attributes, users need to have AME responsibilities. Below are steps to do the same. I) From System Administrator 1. Login as System Administrator user 2. Select the responsibility “User Management”. 3. Select “Users” menu option 4. Search for the user to whom you wish to grant AME roles […]
This articles contains all the table information related to Oracle Workflows and queries joining these tables. WORKFLOW TABLES LIST OF ACTIVITIES FOR AN ITEMTYPE Accepts Workflow itemtype / shortname as input parameter and will all the activities involved along with the status and user name to whom the current activity is assigned. TO FIND FROM […]
Overview: This workflow tutorial will illustrate how to create or define a new workflow from scratch including attributes, notifications, messages, roles or users, functions, processes and last but not the least, how to launch a workflow from PL/SQL. The workflow concepts are better explained using an example. Business Requirement: When an item is created in inventory, […]