Hello,
We are in the process of onboarding Oracle PLM (Fusion application). We have been able to establish the connection and run the job. However, we are able to only import 25 accounts, where as there are 5k+ accounts in the target application.
Below ImportAccountEntJSON:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"statusConfig": {
"active": "true",
"inactive": "false"
},
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": [
"N"
],
"deleteLinks": true,
"accountThresholdValue": 10,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"http": {
"url": "https://***/hcmRestApi/resources/11.13.18.05/userAccountsLOV",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "UserId~#~char",
"displayName": "displayName~#~char",
"name": "Username~#~char",
"status": "active~#~char",
"customproperty1": "id~#~char",
"customproperty2": "Suspended~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
}
},
"entitlementParams": {},
"acctEntParams": {}
}
STATUS_THRESHOLD_CONFIG:
{ "statusAndThresholdConfig": { "accountThresholdValue": 1000, "inactivateAccountsNotInFile": false, "deleteLinks": "true", "includeExistingInActiveAccounts": "true" } }
Job Details:
JOB ATTRIBUTE NAME JOB ATTRIBUTE VALUE
| Job Name | Application Data Import (Single Threaded) |
| Job Type | full |
| Import Type | accounts |
| Warning invalid record | Invalid record not processed. Error Message - null |
| Total invalid records skipped | 25 |
| Accounts Activated | 0 |
| Accounts Inactivated | 0 |
| Accounts Terminated | 0 |
| Account Entitlement Mapping Deleted | 0 |
| Account Ent Priv Mapping Deleted | 0 |
| User Account Mapping Deleted | 0 |
Attached logs for reference.
Have added the below pagination details but that also did not help:
1. "pagination": { "page": { "pageSizeParam": "limit", "pageSize": 600, "pageRecordCount": "600", "pageNumberParam": "page", "totalCountPath": "headers.x-Total-Count", "firstPageNumber": 0 } } } } } }
2. "pagination": { "offset": { "offsetParam": "offset", "batchParam": "max", "batchSize": 500, "totalCountPath": "headers.x-Total-Count" } } } } } }
3. "pagination": { "nextUrl": { "nextUrlPath": "${response?.objectList?.size()>0?'https://***/hcmRestApi/resources/11.13.18.05/userAccountsLOV?startIndex='+Math.addExact(response.completeResponseMap.itemsPerPage,response.completeResponseMap.startIndex)+'&count='+response.completeResponseMap.itemsPerPage:null}" } } } } } }, }
Regards,
Vidhi.
