EBS Customizations (MOSC)

MOSC Banner

Inserting Oracle Applications user from custom form to table

edited Nov 26, 2009 3:00AM in EBS Customizations (MOSC) 4 commentsAnswered ✓
 Hi,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center