HDL is generating an autocomplete error; however, when executing the same transaction through the UI

Summary:

We have implemented autocomplete functionality on the worker assignment object for transfer and change assignment scenarios, and this support is also required for HDL/HSDL. However, an exception in the autocomplete rule is being triggered in HDL for the Change Manager scenario, whereas no error occurs when performing the transaction through the UI

Usecase- 1040

Org- J P Morgan Chase

Content (please ensure you mask any confidential information):

HDL File:

SET PURGE_FUTURE_CHANGES ORA_N
METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveStartDate|EffectiveLatestChange|EffectiveSequence|EffectiveEndDate|ActionCode|PersonNumber
METADATA|Assignment|ActionCode|EffectiveStartDate|EffectiveEndDate|AssignmentId|WorkTermsAssignmentId|PeriodOfServiceId|AssignmentNumber|EffectiveSequence|EffectiveLatestChange
METADATA|AssignmentSupervisor|AssignmentSupervisorId|AssignmentId|ActionCode|AssignmentNumber|ManagerAssignmentId|ManagerId|ManagerAssignmentNumber|ManagerPersonNumber|ManagerType|EffectiveStartDate|EffectiveEndDate|ReplaceLastEffectiveEndDate|NewManagerType|NewManagerPersonNumber|NewManagerAssignmentNumber