Inorder to set WHO columns you need to have the following 5 columns with your custom tables.
,CREATED_BY NUMBER
,CREATION_DATE DATE
,LAST_UPDATED_BY NUMBER
,LAST_UPDATE_DATE DATE
,LAST_UPDATE_LOGIN NUMBER
With both pre-insert and pre-update Block level triggers call the below code.
begin
fnd_standard.set_who;
end;
,CREATED_BY NUMBER
,CREATION_DATE DATE
,LAST_UPDATED_BY NUMBER
,LAST_UPDATE_DATE DATE
,LAST_UPDATE_LOGIN NUMBER
With both pre-insert and pre-update Block level triggers call the below code.
begin
fnd_standard.set_who;
end;
No comments:
Post a Comment