Duplicate Element entry validation triggering while editing the element entry
Summary:
Hi!
We are trying to implement an element entry validation Fast Formula for the employees to not to have duplicate element entries, same element with same effective date. This is working as expected. we were able to acheive it using a value set.
1=1
and papf.person_id = :{PARAMETER.P_PERSON_ID}
--and papf.person_id = 100057429092228
and papf.person_id = peef.person_id
and (petf.BASE_ELEMENT_NAME = :{PARAMETER.P_ELEMENT1} or petf.BASE_ELEMENT_NAME = :{PARAMETER.P_ELEMENT2})
and peef.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
and peevf.ELEMENT_ENTRY_ID = peef.ELEMENT_ENTRY_ID
--and TRUNC(peevf.EFFECTIVE_START_DATE) = TO_DATE('2025/10/09', 'YYYY/MM/DD')
Tagged:
0