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.

3 comments:

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

    ReplyDelete
  2. 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. 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