Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/30/2024 05:11 AM - edited 07/30/2024 07:45 AM
Hello,
Our HCM import process takes around 4 hours to complete. The import has just finished, but we encountered an issue where the user update rule did not trigger correctly. We've fixed the issue and now need to know if it's possible to trigger the user update rule for the current users without running the entire import again.
Is it feasible to achieve this by creating an enhanced query job or through any other method?
fro example: in the enhanced job query:
SELECT
userkey AS USERS__USERKEY,
username,
createdate,
updatedate
FROM
users
WHERE
DATE(createdate) = '2024-07-29'
OR DATE(updatedate) = '2024-07-29';
the following query i have for the join user update rule: (already tested and it is working)
it is basically to create accounts using the technical rule
a.customproperty5 = 'A'
AND a.statuskey = 1
AND (##a.customproperty5 is updated##)
AND (##a.statuskey is updated##)
and for the technical rule: (already tested and it is working)
a.statuskey = 1
AND a.startdate = CURDATE()
Thank you!
07/30/2024 09:49 AM
@Roua users table we can't update via enhanced query , it restricted. try using inline preproccer
07/30/2024 08:10 PM