WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed.
        1) Created by
        2) Creation date
        3) Last _updated_by
        4) last_update_date
        5) last_update_login

  • Use fnd_profile.VALUE (‘USER_ID’) for retrieving the user_id which will be used by created_by column.
  • Creation date and last_update_date will be normally SYSDATE.
  • last_updated_by is same as created_by.
  • Use USERENV (‘SESSIONID’) for getting the last_update_login id.
  • 0 replies

    Leave a Reply

    Want to join the discussion?
    Feel free to contribute!

    Leave a Reply