This discussion is archived
1 Reply Latest reply: Nov 2, 2010 2:39 AM by 803139 RSS

PCG 7: Flow Rules help

rjfoster Guru
Currently Being Moderated
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....
COLUMN=LAST_UPDATED_BY
CONDITION=Equals
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?

Thanx
Russell Foster
  • 1. Re: PCG 7: Flow Rules help
    803139 Newbie
    Currently Being Moderated
    Hi Foster

    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

    thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points