Monday, October 23, 2017

Master/Detail Triggers in Oracle Forms

Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between database blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master block.

On-Check-Delete-Master:- Fires when Oracle Forms attempts to delete a record in a block that is a
master block in a Master-Detail relation.
On-Clear-Details:- Fires when Oracle Forms needs to clear records in a block that is a detail block in a Master-Detail relation because those records no longer correspond to the current record in the master block.
On-Populate-Details:- Fires when Oracle Forms needs to fetch records into a block that is the detail
block in a Master/Detail relation so that detail records are synchronized with the current record in the
master block.

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...