I was wondering if a trigger can be placed on the APPLSYS.FND_USERS table within an Oracle HR system, as I want to synchronize user information with another system, and need to connect to a staging table.
If no triggers are possible, what could I do to extract the data into a staging table when an event (add/delete/modify) takes place>
Also, can I write a view on this table? I am suspecting I can.
Can you? Sure. Should you? Mmm, the jury is still out on that one. How often do you really add new users and does your other application really need to know immediately that a user was added? My guess is probably no. You might think of using a materialized view.