First, You need to create who columns on the table.
You can use this script to do following.
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.
1 | fnd_standard.set_who(); |
2) Compile and try again.
Recent Comments