Showing posts with label
WorkFlow
.
Show all posts
Showing posts with label
WorkFlow
.
Show all posts
Oracle Workflow Run Backend in PL/SQL
›
--PLSQL Code to Run Workflow Backend --Create sequence XXJG_WF_S ; DECLARE p_x_item_type VARCHAR2(100); P_X_PROC_INT_NAME VARCHAR2(100...
Oracle R12 Workflow Notification Event Messages Tracking Script
›
--- Query Notification mail status is MAIL or INVALID SELECT status, mail_status FROM wf_notifications WHERE notification_i...
Oracle R12 Find the Workflow Events
›
--Oracle Workflow Events Query SELECT a.*, a.msg_state, a.user_data.event_name, TRUNC (a.user_data.send_date) ...
Oracle Work Flow Related tables
›
–Workflow Users/Roles SELECT * FROM WF_USERS where name = 'XXTEST'; SELECT * FROM WF_ROLES where name = 'XXTEST'; SELEC...
Run the Workflow backend or PL/SQL Code
›
The below script to run workflow from PL/SQL code- DECLARE v_itemtype VARCHAR2 (50); v_itemkey VARCHAR2 (50); v_proce...
Workflow :- Hiding Workflow Buttons
›
1. Identify the .wft file that contains the definition of the process for which the email notification needs to be changed. 2. Connect to d...
How to find Workflow User, Item Name, Function Message and Lookups
›
--Workflow Users/Roles SELECT * FROM WF_USERS where name = 'XXUSER'; SELECT * FROM W...
›
Home
View web version
