You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!