Field Trigger Being Triggered 2 Times Because Object Trigger Also Updates The Field (Doc ID 2252525.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

How to prevent a field trigger to run 2 times in the following situation?

1) The field trigger on field fires first

2) The BeforeInsert trigger will update again the same field, due to some requirements, which causes the field trigger to run again

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms