Looking for advice / recommendations for a use case similar to Oracle EBS Provisioning
The organization is using the Oracle ERP connector to provision Oracle User Records, Roles, and Data Security Contexts using access profiles and access requests + approvals. The ERP connector works fine, however, the organization requires that the Oracle Worker / Employee record be created when the User record is created.
The Employee / Worker record is not created automatically when a user record is created. Conversely, a user record is created whenever a Worker record is created.
We need to ensure that when the User Record is created, the Worker record is created as well, and ideally the worker record is created first. There is an API available to create the worker record. We have thought about using a workflow. Any recommendations?
@margocbain
In your usecase, you will be assigning some birthright EBS responsibility to trigger FND User creation post person record creation?
If so, then I think you can even leverage roles.
In this case it is not birthright, just based on access request
For those who may encounter the same thing, we applied the following approach:
- Got Oracle team to disable the setting that auto-creates a user account when a worker record is created
- Created a workflow with the ‘provisioning completed trigger’, filtered down to just the Oracle ERP source
- Created a worker record using the following API:
/hcmRestApi/resources/11.13.18.05/workers and a body appropriate for your org requirements
- Get the workerId from step 3, and then update the worker record with a PATCH to
/hcmRestApi/resources/11.13.18.05/workers/{{$.defineVariable3.workerId}} to add in some additional information (like PersonNumber)
- Patched the User record (getting the account ID from the trigger) at
/hcmRestApi/resources/11.13.18.05/userAccounts/{{$.trigger.accountRequests[?(@.provisioningTarget=="appName")].accountId}}
We had to dig around the Oracle APIs a fair bit to get the right calls. See Create a Worker