Category Archives: Apps Technical

Cancel open Notifications and Abort Workflow

Cancel open Notifications and Abort Workflow

Below script is used to cancel all open workflow notifications and abort the workflow by passing Workflow Item Type and also Message type. Continue reading

Related posts:

Workflow Tables

Important Oracle Work Flow Related tables:

Workflow Tables:

–Workflow Users/Roles
SELECT * FROM WF_USERS where name = ‘XXUSER’;
SELECT * FROM WF_ROLES where name = ‘XXUSER’;
SELECT * FROM WF_USER_ROLES where user_name = ‘XXUSER’;
SELECT * FROM WF_USER_ROLE_ASSIGNMENTS where user_name = ‘XXUSER’;

–Workflow Item Name and Attributes
SELECT * FROM WF_ITEM_TYPES where name = ‘OKCAUKAP’; –PO Approval (POAPPRV) ; PO Requisition Approval (REQAPPRV);
–OM Order Header (OEOH); OM Order Line (OEOL)
SELECT * FROM WF_ITEM_TYPES_VL where name = ‘OKCAUKAP’;
SELECT * FROM WF_ITEM_TYPES_VL where display_name like ‘%Approval’;
SELECT * FROM WF_ITEM_TYPES_VL where description like ‘%Order%’;
SELECT * FROM WF_ITEM_ATTRIBUTES where item_type = ‘OKCAUKAP’;
SELECT * FROM WF_ITEM_ATTRIBUTES_TL;

–Workflow Functions
SELECT * FROM WF_ACTIVITIES where item_type = ‘OKCAUKAP’ and version = 1;
SELECT * FROM WF_ACTIVITIES_TL where item_type = ‘OKCAUKAP’;
SELECT * FROM WF_ACTIVITY_ATTRIBUTES where activity_name = ‘CREATE_SOA’;
SELECT * FROM WF_ACTIVITY_ATTRIBUTES_TL;
SELECT * FROM WF_ACTIVITY_TRANSITIONS;

–Workflow Lookups
SELECT * FROM WF_LOOKUPS_TL where lookup_type = ‘OKC_DB_RETRY’;

–Workflow Messages
SELECT * FROM WF_MESSAGES where type = ‘OKCAUKAP’ and name = ‘APPROVE_CONTRACT’;
SELECT * FROM WF_MESSAGES_TL where type = ‘OKCAUKAP’ and name = ‘APPROVE_CONTRACT’;
SELECT * FROM WF_MESSAGE_ATTRIBUTES where message_type = ‘OKCAUKAP’ and message_name = ‘APPROVE_CONTRACT’;
SELECT * FROM WF_MESSAGE_ATTRIBUTES_TL where message_type = ‘OKCAUKAP’ and message_name = ‘APPROVE_CONTRACT’;

–Workflow Particular item run and values
SELECT * FROM WF_ITEMS where item_type = ‘OKCAUKAP’ order by begin_date desc;
–USER_KEY/ITEM_KEY => select * from okc_k_headers_b where contract_number = ‘20683312’;
SELECT * FROM WF_ITEM_ATTRIBUTE_VALUES where item_type = ‘OKCAUKAP’ and item_key=’20683312′;
SELECT * FROM WF_PROCESS_ACTIVITIES where process_item_type = ‘OKCAUKAP’ and process_version = 1;

SELECT * FROM WF_NOTIFICATIONS WHERE MESSAGE_TYPE = ‘OKCAUKAP’ AND MESSAGE_NAME = ‘APPROVE_CONTRACT’;
SELECT * FROM WF_NOTIFICATION_ATTRIBUTES where notification_id = ;

SELECT * FROM WF_DEFERRED;


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 * FROM wf_activity_attributes
SELECT * FROM wf_activity_attributes_tl
SELECT * FROM wf_activity_transitions
SELECT * FROM wf_deferred–wf_control

SELECT * FROM WF_ACTIVITY_ATTR_VALUES
WHERE NAME LIKE ‘%MAST%’
AND PROCESS_ACTIVITY_ID
IN(
SELECT *– PROCESS_ACTIVITY
FROM WF_ITEM_ACTIVITY_STATUSES
WHERE ITEM_TYPE = ‘OEOH’
AND ITEM_KEY =’62348′
)

SELECT * FROM WF_ITEM_TYPES
SELECT * FROM WF_LOOKUPS_TL
SELECT * FROM WF_NOTIFICATIONS
WHERE MESSAGE_TYPE =’TEST’
ORDER BY BEGIN_DATE DESC

SELECT * FROM WF_NOTIFICATION_ATTRIBUTES
SELECT * FROM WF_MESSAGES
SELECT * FROM WF_MESSAGES_TL
SELECT * FROM WF_MESSAGE_ATTRIBUTES
SELECT * FROM WF_MESSAGE_ATTRIBUTES_TL
SELECT * FROM WF_ETS
SELECT * FROM WF_PROCESS_ACTIVITIES

Related posts:

eBiz Tax Query with ZX Tables

eBiz Tax Query with all ZX tables:

 

 Thanks Rajanikanth Yeturi for Providing the Query.


 

Related posts:

XML Bursting from RDF

XML Bursting from RDF

Log on to Oracle EBS using user having System Administrator responsibility to register the Oracle Report.

Creating Executable:

XMLBursting012

Create concurrent program for the executable:

XMLBursting013

Add the parameters for the Program:

XMLBursting014

Add the Concurrent Program to OM Concurrent Programs Request Set:

XMLBursting015

Go to Order Management Responsibility and run the request:

XMLBursting016

Change the output of the concurrent program to create the xml template file .rtf layout in ms word. Create data definition with Code same as the Concurrent Program Short Name:

XMLBursting017

Create Template for the Data definition and attached Template:

XMLBursting018

Run the Concurrent Program and Go to report builder open your existing report, go to report triggers open after report add the below code for bursting code:

Compile the code the save the report.

Design XML Bursting control file, Below are the format of bursting control file:

Goto XML Publisher Responsibility —> data definition —>¬† Search for the data definition with data definition code or data definition and Attach your bursting control file at Bursting Control File Option.

XMLBursting019

XMLBursting020

XMLBursting021

Once done Run the program to get email with an attachment of the XML Template with splitting based on the Sales Order.

AllOracleAppsXMLBursting

Thanks to Madhav Kumar for Providing the Files on XML Bursting.

Related posts: