APEX

Hi
I am in the progress of learning about apex and try to migrate our Oracle forms (10g and 6i) and reports to APEX. I have some confusions between database users and apex users. Our environment for APEX is using database 11g with plsql gateway.

Every table in our database is configured with trigger to update "Date of Changed" and "Changed By" to use "sysdate" and "user". When I use APEX to develop a simple form to do update --> submit. The "Changed By" become "Anonymous," not the login "user". "user" is the database user. I use database account to authenticate the application. I have made worked is to use 'APP_USER' not 'user'. I have to change the trigger in the table to use 'APP_USER'. It is not good for our environment.

Our environment is also using three methods to update our database: Oracle forms/reports (6i), Oracle Application Server (10g R2), Apex (is developing) . "user" works for AS and Oracle forms/reports (6i), but not in APEX. The trigger locates in database. Why does not use "user" in Apex? What is the alternative I can back to use "user" and not "APP_USER". I really don't want to change all our triggers in the database into "APP_USER."

Greatly appreciate any advise. Have a nice holiday to everyone.

Candice