Tag: forms

HOW TO ACTIVATE THE WHO COLUMNS FOR ORACLE FORMS ?

Guven Leave a comment

First, You need to create who columns on the table.
You can use this script to do following.

View Code 
1
2
3
4
5

 ALTER TABLE table_name ADD creation_date DATE;
 ALTER TABLE table_name ADD created_by NUMBER (15);
 ALTER TABLE table_name ADD last_update_date DATE;
 ALTER TABLE table_name ADD last_updated_by NUMBER (15);
 ALTER TABLE table_name ADD last_update_login NUMBER (15);

After, activate the who columns for a oracle forms you need to do following.
1) You have to call an following API in PRE_INSERT and PRE_UPDATE triggers.

View Code 
1

 fnd_standard.set_who();

2) Compile and try again.