How to identify if the record was modified from web form or standard oracle form in R12
We are implementing Oracle HR Self Service in R12 and we also have some core HR users who use the standard Oracle Forms to access the data.
Say for example if an employee updates his records from HR Self Service, the corresponding tables will have him as the last_updated_by...and if the same record is modified by someone from the core HR team, it will show them as the last_updated_by.
Now we have a scenario where we want to send an email to the person who updates his own record from Self Service page and not send email when the core HR group updates the record.