Core Workflow - EBS (MOSC)

MOSC Banner

SQL Query for Workflow Activity Attribute Values

edited Oct 23, 2015 3:54AM in Core Workflow - EBS (MOSC) 3 commentsAnswered ✓

Hello,

I would like to have a query to retrieve Timeout values that are setup on certain Activities (these are Notifications that in the Node have a Relative Time timeout setup).  See screen shot below from the WF Builder.  From my research I know that the Activity information is in the WF_ACTIVITIES table and the Timeout value I think is in the WF_ACTIVITY_ATTR_VALUES table but I do not see how to join the column WF_ACTIVITY_ATTR_VALUES.PROCESS_ACTIVITY_ID to the actual activities table for this particular workflow / activity . Thanks in advance.  The workflow below has item type = REQAPPRV

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Workflow Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center