May 22, 2008

Standard WHO Columns

In this article, I will show you how to update the Standard WHO columns through Procedures.

The following are the Standard WHO Columns in most of the Oracle tables:
  1. created_by
  2. creation_date
  3. last_update_date
  4. last_updated_by
  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.
Posted by
Labels:

3 comments:

  1. Sairam NimmagaddaJanuary 23, 2009 at 10:23 PM

    could you explain what and how we can acheive this, i am looking to get these in my custom table
    thanks,

    ReplyDelete
  2. JithendraJanuary 24, 2009 at 1:41 PM

    Hi Sairam,

    These are the standard packages which are used to retrieve the user and session information. You can use these packages to insert the data in to your custom tables.

    Hint: Get these data on to a variable and then insert these records accordingly.

    Regards,
    Jithendra

    ReplyDelete
  3. ShellyJanuary 11, 2012 at 6:38 PM

    PLEASE LET ME KNOW HOW CAN I JOIN RA_CUSTOMER_TRX_ALL TABLE WITH FND_USER TABLE,
    BOTH THE TABLES HAVE 'WHO columns'....

    ReplyDelete

Comments or feed backs please

Subscribe to: Post Comments (Atom)