erpSchools

Tag: workflow

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

  • Get Version number for Oracle apps, Database, Workflow, XML, OS

    — Oracle Database version along with hostname and instance name SELECT instance_name, host_name, version, status, database_status FROM v$instance; — Database version along with operating system platform SELECT name, DB_UNIQUE_NAME, platform_name FROM v$database; — Oracle Apps version SELECT release_name, applications_system_name, aru_release_name FROM FND_PRODUCT_GROUPS; — Database Version, PLSQL Version, TNS Version SELECT * FROM v$version; — Oracle…

  • Run / start workflow from Workflow Administrator Responsibility

    First of all why do we need to run a workflow from workflow administrator responsibility? Second, Who will run it? Third, When can we run it? Fourth, How can we run it? Finally, Is it recommended approach? 1) Normally we don’t run or kickoff workflow’s from workflow administrator responsibility. All seeded workflow’s are tied to…

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