Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Alert composer With SQL query
Summary:
we have sql query the rerurn some employees person_id we need to use that query in alert composer
to send them a reminder
Content :
SELECT t1.Person_IDFROM PER_ALL_ASSIGNMENTS_M T1, PAY_ELEMENT_ENTRIES_F EE,PAY_ELEMENT_ENTRY_VALUES_F EEV
WHERE EE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID
AND EE.ELEMENT_TYPE_ID = 300000603183844AND EEV.INPUT_VALUE_ID = 300000604012993and T1. person_id =EE.PERSON_ID
AND EEV.SCREEN_ENTRY_VALUE NOT IN(
SELECT EEV.SCREEN_ENTRY_VALUEFROM PAY_ELEMENT_ENTRY_VALUES_F EEV,PAY_ELEMENT_ENTRIES_F EEWHERE EE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_IDAND EE.ELEMENT_TYPE_ID = 300000603187127AND EEV.INPUT_VALUE_ID = 300000603188789
0