Rest API to Terminate a worker in Oracle Fusion

Method: Post

Header 

Content-Type : application/vnd.oracle.adf.action+json

Rest API: https://<Host>/hcmRestApi/resources/11.13.18.05/workers/{workersUniqID}/child/workRelationships/{PeriodOfServiceId}

Sample Payload 

{

"actionCode": "RESIGNATION",

"terminationDate": "2022-03-01",

"reasonCode":"RESIGN_PERSONAL",

"notificationDate":"2022-03-01",

"recommendedForRehire":"ORA_NS"

}

Response

{

    "result": "true"

}

Status

200 OK

query to get legal entity and business Unit name

SELECT

hou.name BU_NAME,

hou.SHORT_CODE ,

le.NAME Legal_ENtity,

led.NAME Ledger_Name

FROM

hr_operating_units hou,

xla_gl_ledgers led,

Xle_entity_profiles le

WHERE

hou.default_legal_context_id = le.legal_entity_id

AND led.ledger_id = hou.set_of_books_id

Query to get Legal Entity in Oracle Fusion

select 
LEGAL_ENTITY_ID,
LEGAL_ENTITY_IDENTIFIER,
NAME
from xle_entity_profiles