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
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Nov 28, 2012 4:38 PM by Alejandro Sosa-Oracle
Query to find out which workflow(s) use a particular message ? wf_messages
Nov 28, 2012 11: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
I have the same question
Show 0 Likes
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 4:38 PM
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