Friday, September 8, 2017

Who Columns in Oracle Apps Table

Standard WHO Columns

The following are the Standard WHO Columns in most of the Oracle tables:

created_by
creation_date
last_update_date
last_updated_by
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.

No comments:

Post a Comment

Oracle Standard Package for Order Totals

  Purpose: Sometimes we need to show line-wise or complete order totals (Basic / Tax / Tax+Basic) in reports. Oracle provides a standard...