Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Benefits HDL

user-f1rfbOct 27 2023 — edited Oct 31 2023

I am unable to load benefits for Canada Employee while loading the file getting error as “The message is Unable to find a started life event” . I have tried to load with enrolled plan as mention in the system. As of now I have loded 1st hdl file for potential life event this one loaded successfully after that I done the evaluation from person benefits life event then loaded participant enrollment but I am getting above error message.

PotentialLifeEvents HDL file contains below details:-

METADATA|PotentialLifeEvents|PersonNumber|LegalEmployer|BenefitRelationName|LifeEventName|LifeEventStatusCode|LifeEventOccuredDate|UnprocessedDate|NotificationDate|SourceSystemId|SourceSystemOwner
MERGE|PotentialLifeEvents|6099469|Adecco Employment Services Limited|DFLT|Administrative Entry|UNPROCD|2023/01/01|2023/01/01|2023/01/01|6099469_LifeEvent_2023/01/01|GS

ParticipantEnrollment HDL file contains below details:-

METADATA|ParticipantEnrollment|PersonNumber|ParticipantLastName|ParticipantFirstName|BenefitRelationship|LifeEvent|LifeEventOccuredDate|EffectiveDate
MERGE|ParticipantEnrollment|6099469|||DFLT|Administrative entry|2023/01/01|2023/01/01

METADATA|CompensationObject|PersonNumber|LineNumber|Program|Plan|Option|OriginalEnrollmentDate|DenrollPlan|DenrollOption|DenrollProgram
MERGE|CompensationObject|6099469|1|Canadian Adecco Benefit Program|Ontario Health Coverage|Employee Only|2023/01/01|Waive Health Coverage||Canadian Adecco Benefit Program

Comments
Post Details
Added on Oct 27 2023
3 comments
516 views