Wrong Date In HZ_STAGED_PARTIES For Date Of Birth (Doc ID 2137438.1)

Last updated on MAY 13, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Data Quality Management

ACTUAL BEHAVIOR
---------------
"DQM Synchronization Program" adds 100 years to Date of Birth column in hz_staged_parties table

EXPECTED BEHAVIOR
-----------------------
"DQM Synchronization Program" should NOT add 100 years to Date of Birth column in hz_staged_parties table

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Using TCA API HZ_PARTY_V2PUB.update_person to update person's birth day
After running "DQM Synchronization Program", the data in hz_staged_parties table increases 100 yrs

 

It adds 100 years to the date of birth

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