Triggers on FND_USERS for Oracle HR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Triggers on FND_USERS for Oracle HR

Hybrid View

  1. #1
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41

    Triggers on FND_USERS for Oracle HR

    Hello all,

    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.

    Thanks, Keith

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41
    Thanks for the reply,

    Yes, the other application needs to know about the add/delete/modify immediately since I am using Oracle HR as the authoritative source for an Identity Management project.

    The users are synchronzied within 1 minute of HR events to another 6 applications, so we would need immediate notification.

    So are Triggers on the FND_USERS a no-no, and does Oracle prevent Triggers being written on this table? If need be, I can use a view.

    Thanks, Keith

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width