erpSchools

Category: Workflow

  • Oracle Business Events

    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…

  • Oracle workflow ad hoc roles

    — Script to Create oracle workflow ad hoc roles DECLARE lv_role varchar2(100) := ‘ERPSCHOOLS_DEMO_ROLE’; lv_role_desc varchar2(100) := ‘ ERPSCHOOLS_DEMO_ROLE’; BEGIN wf_directory.CreateAdHocRole(lv_role, lv_role_desc, NULL, NULL, ‘Role Demo for erpschool users’, ‘MAILHTML’, ‘NAME1 NAME2’, –USER NAME SHOULD BE IN UPPER CASE NULL, NULL, ‘ACTIVE’, NULL); commit; dbms_output.put_line(‘Created Role’ ||’ ‘||lv_role); End; / — Script to Add user…

  • Workflow migration: WFLOAD | Workflow Definitions Loader

    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…

  • Workflow Override email address

    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…

  • AME Role / Responsibility assignment to a user

    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…

  • Workflow Tables and Queries

    This articles contains all the table information related to Oracle Workflows and queries joining these tables. WORKFLOW TABLES SELECT * FROM WF_USER_ROLE_ASSIGNMENTS SELECT * FROM WF_USER_ROLES SELECT * FROM WF_ROLES SELECT * FROM WF_ITEMS SELECT * FROM WF_ITEM_ATTRIBUTES SELECT * FROM WF_ITEM_ATTRIBUTE_VALUES SELECT * FROM WF_ITEM_ATTRIBUTES_TL SELECT * FROM WF_ACTIVITIES SELECT * FROM WF_ACTIVITIES_TL SELECT…

  • Workflow tutorial

    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,…