Monday, August 31, 2009

Use of FND_REQUEST.SET_MODE inside a DB Trigger

Syntax:
FND_REQUEST.SET_MODE(TRUE);
-------------------------------------------------------------------
Normally when a database session is setup, to submit a concurrent request to run concurrent program 'XXXXXXXXXX'.
Note that normally a COMMIT is required following the FND_REQUEST.SUBMIT_REQUEST, otherwise the request will not actually be submitted, however a COMMIT cannot be issued within a trigger. Because the Mode was set to TRUE (i.e. trigger) earlier in this trigger, a COMMIT is not needed.

1 comment: