My Oracle Support Banner

Business Events in TCA Not Fired When Person with a Relationship is Updated a Second Time in Oracle Customers Online (Doc ID 1510452.1)

Last updated on MARCH 26, 2019

Applies to:

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

Symptoms

The TCA Business Object Event is not fired when a Person Name is updated (any filed related to person profile) in Oracel Customers Online (OCO) for a second time. 

The TCA Business Event is fired when the person is created and when the person name is updated for the first time.  It is not firing when a person is updated more than once.

Steps to Reproduce:
Responsibility:  Oracle Customers Online Superuser
Navigation:  Customers

1. Create a person with relationship
Run the 'TCA Business Object Events: Raise Events Program'
Run the following script:
    select * from hz_bus_obj_tracking
    order by creation_date desc ;
NOTE:  The event_id column is populated with a value.

2.  Update the person name created above
Run the 'TCA Business Object Events: Raise Events Program'
Run the following script:
    select * from hz_bus_obj_tracking
    order by creation_date desc ;
NOTE:  The event_id column is populated with a value.
 
3.  Update the person name created above
Run the 'TCA Business Object Events: Raise Events Program'
Run the following script:
    select * from hz_bus_obj_tracking
    where event-id = null
    order by creation_date desc ;
NOTE:  The event_id column is NULL

4.  Update the person name created above
Run the 'TCA Business Object Events: Raise Events Program'
Run the following script:
    select * from hz_bus_obj_tracking
    where event-id = null
    order by creation_date desc ;
NOTE:  The event_id column is not populated with a value, it is null.  No event is fired.

When a person party was updated then four records were created hz_bus_obj_tracking table.
When 'TCA Business Object Events: Raise Events Program' updated event_id for only two records and other two records have event_id as NULL.

If the same party is updated again then HZ_POPULATE_BOT_PKG.pop_hz_person_profiles is checking for the records with event_id is NULL and stops populating the party changes to hz_bus_obj_tracking.

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
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.