Bulk Update Oracle ERP Cloud Passwords using REST Service
In this Article, I will outline the steps to perform bulk update of ERP cloud user passwords.This will be handy after the instance refresh and you wanted to bulk reset the passwords of a development instance. Please be mindful while using this API in Prod Instance.
API End point:
This Must hit with a POST Operation.
Please note that the below red coloured values are
A99ssdsf06231E2sfsvsf050520A1C805CCC- This can obtained from per_users guid column
clientBulkId1", -- This a unique builk id you want to give it to the batch.
NewPassword" - Your New Password.
Sample Payload:
{
"Operations":[
{
"method":"PATCH",
"path":"/Users/A99ssdsf06231E2sfsvsf050520A1C805CCC",
"bulkId":"clientBulkId1",
"data":{
"schemas":[
"urn:scim:schemas:core:2.0:User"
],
"password":"NewPassword"
}
},
{
"method":"PATCH",
"path":"/Users/Asfggdgdstg5hh50520A1C805C68",
"bulkId":"clientBulkId1",
"data":{
"schemas":[
"urn:scim:schemas:core:2.0:User"
],
"password":"NewPassword"
}
}
]
}
Response Payload :
{
"schemas": [
"urn:scim:schemas:core:2.0:Bulk"
],
"Operations": [
{
"location": "https://POD/hcmRestApi/scim/Users/A99ssdsf06231E2sfsvsf050520A1C805CCC",
"method": "PATCH",
"bulkId": "clientBulkId1",
"status": {
"code": "200"
}
},
{
"location": "POD/hcmRestApi/scim/Users/AAsfggdgdstg5hh50520A1C805C68,
"method": "PATCH",
"bulkId": "clientBulkId1",
"status": {
"code": "200"
}
}
]
}
With the New password , Please go and login to the ERP cloud Application.
you can use the below API to reset the password for a individual user :
End Point:
Sample Payload:- PATCH
{
"schemas":[
"urn:scim:schemas:core:2.0:User"
],
"password":"Password228"
}
Response Payload: in the response payload you get lots of information about the user.
{
"meta": {
"location": "https://POD/hcmRestApi/scim/Users/99dhdhwjdhd782278929801E2DF0A1C805CCC",
"resourceType": "User",
"created": "2020-08-03 19:45:02.407",
"lastModified": "2021-01-31 18:06:01.019"
},
"schemas": [
"urn:scim:schemas:core:2.0:User",
"urn:scim:schemas:extension:fa:2.0:faUser"
],
"userName": "986578,
"name": {
"familyName": "Satyavolu,
"givenName": "Sandeep"
},
"displayName": "Satyavolu Sandeep",
"preferredLanguage": "en",
"emails": [
{
"value": "samdepp99@fusiongoeasy.com",
"type": "W",
"primary": true
}
],
"roles": [
{
"id": "76FCBA97B75E4A85A92BAC883F694615",
"value": "EMPLOYEE_ABSTRACT",
"displayName": "Employee",
"description": "Identifies the person as an employee."
}
],
"urn:scim:schemas:extension:fa:2.0:faUser": {
"userCategory": "DEFAULT",
"accountType": "Person",
"workerInformation": {
"personNumber": "366789",
"manager": "Hara Gollamudi,
"job": "Systems architect",
"businessUnit": "Fusion Go easy LLC",
"department": "DDC Sunnyvale"
}
},
"active": true
}
Hope this helps!
Happy Learning.
