Difference between Commit,COMMIT_FORM and Do_Key('Commit_Form')

COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.

DO_KEY('commit_form') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn't exist it does the same as COMMIT_FORM.

Oracle Application Developer Guide says:

Replace COMMIT with do_key('commit_form'), This routine raises the exception FORM_TRIGGER_FAILURE if there is an invalid record.

Sequence of Trigger Fire while Committing

•  KEY-Commit
•  Pre-Commit
•  Pre/On/Post Delete
•  Pre/On/Post Update
•  Pre/On/Post Insert
•  On-Commit
•  Post Database Commit