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

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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