Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hello oracle experts,
I am developing new custom form in Oracle EBS R12 and i want to store WHO columns values like :
CREATION DATE,
CREATED BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
please guide me how to do this ?
thanks in advance.
Hello Beter,
To set who columns in a new custom form in oracle apps you have to follow this two basic steps:
1- you have to have the who columns which is (CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE and LAST_UPDATE_LOGIN) first created on the table whose your database block is based on.
2- Call fnd_standard.set_who; on (pre-insert & pre-update) triggers on block level.
That’s it.