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 JULY 12, 2017

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

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