My Oracle Support Banner

HZ_LOCATION_V2PUB.update_locatin Causes Event oracle.apps.ar.hz.Location.update Fires 2 Times (Doc ID 2805918.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Customers Module

ACTUAL BEHAVIOR
---------------
Event oracle.apps.ar.hz.Location.update fires 2 times when running TCA API hz_location_v2pub.update_location to update a location information

The custom subscription is created with phase 101

If updating the location via UI, Event oracle.apps.ar.hz.Location.update only fires once

EXPECTED BEHAVIOR
-----------------------
Event oracle.apps.ar.hz.Location.update should only fires once when running TCA API hz_location_v2pub.update_location to update an existing location information

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a custom subscription which inserting data into a custom table
2. Run TCA API hz_location_v2pub.update_location to update a location information
3. See Event oracle.apps.ar.hz.Location.update fires 2 times

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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