Business Events Are Being Fired Multiple Times For A Single Transaction in Service Request Task Tab (Doc ID 1493267.1)

Last updated on AUGUST 21, 2024

Applies to:

Symptoms

On : 12.1.2 version, Business Events

Autual Behaviour
Upon saving an update (change any field) to a single task record from the tasks tab of the Service Request form, two oracle.apps.jtf.cac.task.updateTask business events are being raised.
  

Expected Behaviour

Expect that the event should fire only once.

Steps to Replicate

The issue can be reproduced at will with the following steps:
Step 1 : Created a Function which only inserts a line in a test table once.
Step 2 : Created a Subscription for the Business Event oracle.apps.jtf.cac.task.updateTask and attached the function in the subscription.
Step 3 : Changed a value of a field on the Task on the Service Request so that the business event gets fired and the function gets called.
Step 4 : Check the WF_DEFERRED table, two rows were inserted in the table , which implied that the function was called twice -> which further implies that the business event was fired twice because of which the function in the subscription got called twice.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.