OIC HCM - How to extract data from Oracle Cloud HCM using OIC | FlowActionsService | Calling SOAP service to run an HCM Extract

Usecase: 

Here, we will extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service

To know how to create HCM extract based on user entity, follow my below blogs:

https://soalicious.blogspot.com/2024/05/oic-hcm-configure-hcm-extract-bulk-data.html

Required WSDLs:

Extract data:

https://hostname:443/hcmService/FlowActionsService?WSDL

Upload or download From UCM:

https://hostname:443/idcws/GenericSoapPort?WSDL

Implementation steps:

1. Create a HCM extract based on employee user entity.
2. FlowActionsService - Extract data from HCM which will be uploaded to UCM using below operation
1. SubmitFlow
1. Flow name
2. Parameter values like param: Effective Date
3. FlowInstanceName
4. Legislative Data group name
5. Schedule Date
6. Recurring Flag : false
3. Take a while loop and continue till getFlowTaskInstanceStatus = COMPLETED
1. Add wait 5 mins
2. FlowActionsService - getFlowTaskInstanceStatus
1. Flow Instance Name
2. Flow Task Instance Name
3. Legislative data group Name
3. Take am assign and update the getFlowTaskInstanceStatus
4. FlowActionsService - getIntegrationContentId
1. Flow Instance name
2. Flow task instance name
3. Legislative data group name
4. Integration name
5. Take an assign and create query text value using content id as concat("dDocName <substring> `",upper-case(ContentId),"`")
6. GenericSoapService - get dID from content id
1. wbKey="CS"
2. IdService="GET_SEARCH_RESULTS"
3. Document field name="QueryText"
4. Value = $varQueryTextValue (step5)
7. GenericSoapService - get File from UCM from dID
1. webKey = "CS"
2. IdService ="GET_FILE"
3. Document Field name="dID"
4. Value =dID fetched from step6
8. Decode the data : decodeBase64(Contents)

Notes:

1. Flow name : hcm Extract name
2. Integration name : the integration name what we provided during extract creation
3. Flow instance name = should be unique like flow name + guid
4. Flow task instance name = hcm extract name

Detailed screenshots:

Create soap connections:

FlowActionsService:

Generic SOAP service for UCM upload / download:

Integration flow:

Assign required data to variables:

Submit Flow

While loop

Wait 5 mins

GetFlowTaskInstanceStatus

Update flowTaskInstanceStatus

GetIntegrationContentID

Assign content id

Get dID from content id

Get file from UCM using dID

Decode the data

Test and Monitoring:

OIC activity stream payloads

UCM 

Check data from HCM Extract:

Reference:

https://tangenz.com/exporting-data-from-oracle-hcm-cloud-using-oic-tangenz-corporation/

https://myoraclejourney.com/2023/01/06/calling-soap-service-to-run-an-hcm-extract/