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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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