Effective Dated Row is Inserted for Marital Status and Addresses Despite the Data Being the Same in PDL/CTM (Doc ID 2179091.1)

Last updated on DECEMBER 14, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------
The Data Update Rules are acting differently after applying Bundle #41 and Patch 23543701 : PDL/CTM NOT ADHERING TO DATA UPDATE RULES SET AND PUBLISHING MESSAGES TO HR.

A new effective dated row is inserted despite the data being the same. If record does not contain marital status, a new row will have the marital status of 'U' (set up as default value in File Parser to load into staging). This could cause issues when the messages are published to HCM and there is a value other than 'U' in the marital status field. The new row would not reflect the marital status value.

EXPECTED BEHAVIOR
-----------------------
If the entity data has an effective date, then the system inserts a new effective-dated row if the incoming data differs from the current effective-dated row.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to an environment which is on bundle #41, patch 23254407 and fix 23543701 applied.
2. In Data Update Rule, the update action for entity field "Gender" in Person Data Effdt is set to "Add If Blank". Entity for addresses is set to "Update/Insert".
3. Load applicant data for an existing ID using file parser.
4. Go to Application Transaction Management and post the transaction data to production tables.
5. Go to Add/Update a Person.  A new effective dated row will be added in biographical history and in the addresses despite the data being the same.

Changes

Cause

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