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
Governance, Risk & Compliance (GRC) Archived Forums
GRC General Discussion
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 2, 2010 4:39 AM by
PCG 7: Flow Rules help
Oct 25, 2010 2:41 PM
E-Bus 11i Flow Rules Help
Hi I need to create a flow rule that will notify an employee's supervisor when a user updates their own employee record.
So I need to link the LAST_UPDATED_BY of the currently updated record to employee_id from FND_USER
where the FND_USER.USER_ID = <current>.LAST_UPDATED_BY
I'm looking at my Flow Rule Launch Criteria, but I cannot see how I can say....
VALUE= <result of my SQL> <==========
It looks like I can only put specific hardcoded values in here ??
Any ideas, or examples for this type of thing?
Is my requirement clear?
This content has been marked as final.
Show 1 reply
Re: PCG 7: Flow Rules help
Nov 2, 2010 4:39 AM
in response to
In the launch criteria you can specify under the table name FND_USER, Relationship keys would be (USER_NAME, USER_ID)
please check the check box "UPdate" uncheck "Insert"
coming to the columns enter value "LAST_UPDATE_BY" and condition "IS Update"
the value part cannot be updated.
The launch criteria created specifies that when ever the colum Last_update_by of FND_USER is updated the flow rule will get fired.
Please try and let me know if u face any issues