It is best practice if you keep history of record in any application. Oracle implemented the feature of tracking data. The tracking of data stored WHO columns.
Below are the WHO columns exists in almost all tables of Oracle Apps.
• created_by – Keeps track of user who inserted/created the record.
• creation_date – Stores the record insertion/creation date.
• last_update_by – Keeps track of last user who updated the record.
• last_update_date – Stores the record changed/updated date.
• last_update_login – Login Session ID of the user.
Column Name How data is populated?
created_by TO_NUMBER(FND_PROFILE.VALUE(‘USER_ID’))
creation_date SYSDATE
last_updated_by TO_NUMBER(FND_PROFILE.VALUE(‘USER_ID’))
last_update_date SYSDATE
last_update_login TO_NUMBER(FND_PROFILE.VALUE(‘LOGIN_ID’))
Below are the WHO columns exists in almost all tables of Oracle Apps.
• created_by – Keeps track of user who inserted/created the record.
• creation_date – Stores the record insertion/creation date.
• last_update_by – Keeps track of last user who updated the record.
• last_update_date – Stores the record changed/updated date.
• last_update_login – Login Session ID of the user.
Column Name How data is populated?
created_by TO_NUMBER(FND_PROFILE.VALUE(‘USER_ID’))
creation_date SYSDATE
last_updated_by TO_NUMBER(FND_PROFILE.VALUE(‘USER_ID’))
last_update_date SYSDATE
last_update_login TO_NUMBER(FND_PROFILE.VALUE(‘LOGIN_ID’))
I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Cloud Applications .Actually I was looking for the same information on internet for Oracle Cloud Applications Consultant and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDelete