Difficulty Loading Data Into DFF Field (H2H Status) Via HDL (Doc ID 3052045.1)

Last updated on OCTOBER 20, 2024

Applies to:

Goal

We have created a DFF field in the Person Biographical Data section, based on the client's requirements.


The issue arises when the worker has two records in the PER_ALL_PEOPLE_F table. Below are the different scenarios we’ve tested and the issues encountered:

1. Loaded the record with the most recent effective start date and effective end date via HDL.
2. Loaded the record with the earliest effective start date and effective end date via HDL.
3. Loaded both records in HDL.

Unfortunately, none of these attempts have been successful in updating the DFF field. Could you please help identify the cause and suggest a resolution?
 

Solution

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