Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can we have WHEN-NEW-FORM-INSTANCE trigger in block level ?

Arun ThomasMay 27 2017 — edited May 27 2017

Hi Experts,

There is a WHEN-NEW-FORM-INSTANCE trigger in block level, - (This FMB file is taken from 11i instance and we are migrating to R12.2.6)

its defaulting date column if the date column is NULL.

but this is not working in R12, this trigger is not getting triggered, I tested with message('Test trigger');

so i placed the same code which was in there , in the Form level WHEN-NEW-FORM-INSTANCE trigger. it worked.

Moreover when in navigate to Block-> (Block Name) -> trigger -> rightclick and check for WHEN-NEW-FORM-INSTANCE trigger  , I did not get that.

so my question is it good idea to have     WHEN-NEW-FORM-INSTANCE trigger in block level ? is it depreciated in the latest forms ?

kindly guide.

This post has been answered by Kalpataru on May 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2017
Added on May 27 2017
2 comments
2,645 views