Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
HDL to Update Assignment Status Type ID
Summary:
Update Assignment Status from "Inactive - Payroll Eligible" to "Inactive - No Payroll" where Job = "CONVERSION"
From per_all_assignments_m need to update ASSIGNMENT_STATUS_TYPE_ID = 4:
ASSIGNMENT_ID | PERSON_ID | ASSIGNMENT_TYPE | ASSIGNMENT_NUMBER | ASSIGNMENT_STATUS_TYPE_ID | ACTION_CODE | ASSIGNMENT_NAME | ASSIGNMENT_STATUS_TYPE | PERSON_TYPE_ID | SYSTEM_PERSON_TYPE | PERIOD_OF_SERVICE_ID | ACTION_OCCURRENCE_ID | EFFECTIVE_START_DATE | EFFECTIVE_END_DATE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
300000009461075 | 1000000058XXXXX | C | C141424 | 2 | HIRE | Conversion | ACTIVE | 300000009184746 | CWK | 100000005847844 | 300000009461053 | 2021/08/30 | 2022/01/22 |
300000009461075 | 1000000058XXXXX | C | C141424 | 3 | BHC_CW_TERM | Conversion | INACTIVE | 300000009184746 | CWK | 100000005847844 | 300000023907686 | 2022/01/23 | 4712/12/31 |
300000009461061 | 1000000058XXXXX | CT | CT141424 | 2 | HIRE | CT141424 | ACTIVE | 300000009184746 | CWK | 100000005847844 | 300000009461053 | 2021/08/30 | 2022/01/22 |
300000009461061 | 1000000058XXXXX | CT | CT141424 | 3 | BHC_CW_TERM | CT141424 | INACTIVE | 300000009184746 | CWK | 100000005847844 | 300000023907686 | 2022/01/23 | 4712/12/31 |
I've tried various versions of the following HDL without success.