HDL Fast Formula generating duplicate Potential Life Event records when Employee and Spouse records
Summary:
Content (please ensure you mask any confidential information):
Hi Everyone
I am working on loading Benefits Potential Life Event (PLE) using HDL with a Fast Formula. In my inbound file, I receive two types of rows:
• Employee details
• Spouse (dependent) details
If the file contains only the Employee row → HDL + Fast Formula works fine. If the file contains only the Spouse row → it also works fine.
But if both Employee and Spouse rows exist in the same file, the Fast Formula ends up generating duplicate HDL PLE records for the same employee, b
I noticed that HDL processes these two rows in different threads, and even though I use WSA_SET in the Fast Formula to track whether the PLE was already generated for that employee, the multi-threaded execution causes each record to run in a separate working storage area. As a result, both rows think they need to generate the PLE, and HDL errors out.