Update Owner On Termininate v23.10

[Mukul]

Hi All, 

As part of transfering the entitlement owner to the manager when the user is made inactive from HCM, we are trying to populate Owner on Terminate. I have tried inline processing but it doesn't seem to work

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON CURRENTUSERS.USERNAME = NEWUSERDATA.USERNAME SET NEWUSERDATA.OWNERONTERMINATE= CASE WHEN (NEWUSERDATA.CP4= 'INACTIVE') THEN CURRENTUSERS.OWNERONTERMINATE ELSE CURRENTUSERS.MANAGER END"

Any suggestions?

Regards,

-Mukul

[rushikeshvartak]

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON CURRENTUSERS.USERNAME = NEWUSERDATA.USERNAME SET NEWUSERDATA.OWNERONTERMINATE= CASE WHEN (NEWUSERDATA.CUSTOMPROPERTY4= 'INACTIVE') THEN CURRENTUSERS.OWNERONTERMINATE ELSE CURRENTUSERS.MANAGER END"

[Mukul]

Hi @rushikeshvartak 

Yeah that is CUSTOMPROPERTY4 in my code. 

Exact code below

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON CURRENTUSERS.USERNAME = NEWUSERDATA.USERNAME SET NEWUSERDATA.OWNERONTERMINATE= CASE WHEN (NEWUSERDATA.CUSTOMPROPERTY4 = 'INACTIVE') THEN CURRENTUSERS.OWNERONTERMINATE ELSE CURRENTUSERS.MANAGER END"

However, it doesnt update OWNERONTERMINATE when the status is ACTIVE toCURRENTUSERS.MANAGER

[rushikeshvartak]

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON CURRENTUSERS.USERNAME = NEWUSERDATA.USERNAME SET NEWUSERDATA.OWNERONTERMINATE= CASE WHEN (NEWUSERDATA.CUSTOMPROPERTY4 = 'INACTIVE') THEN CURRENTUSERS.OWNERONTERMINATE WHEN (NEWUSERDATA.CUSTOMPROPERTY4 = 'ACTIVE') THEN CURRENTUSERS.MANAGER ELSE CURRENTUSERS.MANAGER END"

[Mukul]

Hi @rushikeshvartak ,

Sorry I didn't understand what you mean?

[rushikeshvartak]

Use updated query

[Mukul]

Thanks that works. Can I ask you one more question. We want to send the email ( configured in update rule ). what attribute value I shall use so that email is sent to the user listed in "Owner On Terminate"?

[rushikeshvartak]

${user?.ownerontermainate?.email}

[rushikeshvartak]

Please confirm if this resolved @Mukul