Inserting Oracle Applications user from custom form to table
I am working on custom form and registering the forms with Oracle apps.
I am using PRE-INSERT trigger to insert created_by and last_updated_by columns in custom table.
Currently, I am using following logic in pre-insert trigger:
CREATED_BY:= USER;
LAST_UPDATED_BY:= USER;
This inserts the database user everytime I create a record.
I would like to insert the oracle applications username instead of database user when creating records using this form in oracle apps-how can this be achieved?