Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 28, 2012 10:38 AM by
Query to find out which workflow(s) use a particular message ? wf_messages
Nov 28, 2012 5:51 AM
Hoping someone can help.
I've a list of particular notfication messages, which are stored in the WF_MESSAGES_TL and WF_MESSAGES table, and I need to find out which workflows use them.
Can anyone tell me what table I can query to find this out ?
There's no referential integrity which I can use to find this out, and google has turned up nothing so far.
Any ideas ?
Thanks a lot
This content has been marked as final.
Show 1 reply
Re: Query to find out which workflow(s) use a particular message ? wf_messages
Nov 28, 2012 10:38 AM
in response to
You can use this and tweak it around:
select p.process_item_type, p.process_name, p.activity_name, a.message
from wf_process_activities p, wf_activities a
where p.process_item_type=a.item_type and
a.end_date is null;-- means the active/current activity