Hello,
We are in the process of onboarding Oracle PLM (Fusion application). We have been able to establish the connection and run the job. But no accounts are getting imported after successfully running the job.
Connection JSON:
{
"authentications": {
"acctAuth": {
"authType": "Basic",
"url": "***
"httpMethod": "POST",
"httpParams": {},
"httpHeaders": {},
"httpContentType": "text/html",
"properties": {
"userName":"***",
"password":"***"
},
"expiryError": "ExpiredAuthenticationToken",
"authError": [
"InvalidAuthenticationToken",
"AuthenticationFailed"
],
"timeOutError": "Read timed out",
"errorPath": "error.code",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"tokenType": "Basic",
"accessToken": "Basic abcd",
"apiRateLimitConfig": {"retryAfterCalls": 100,"retryWaitSeconds": 60}
}
}
}
ImportAccountEnt JSON:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"statusConfig": {
"active": "true",
"inactive": "false"
},
"statusAndThresholdConfig": {
"inactivateAccountsNotInFile": false,
"deleteLinks": "true",
"includeExistingInActiveAccounts": "true"
},
"http": {
"url": "***",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "Resources",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"displayName": "displayName~#~char",
"name": "userName~#~char",
"status": "active~#~char",
"customproperty1": "id~#~char",
"customproperty2": "#CONST#${String r1 = response.'urn:scim:schemas:extension:fa:2.0:faUser'.workerInformation.personNumber; return r1}~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
},
"acctEntMappings": {
"Job Role": {
"listPath": "roles",
"idPath": "value",
"keyField": "entitlement_value"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Job Role": {
"entTypeOrder": 0
}
}
},
"acctEntParams": {
"entTypes": {
"Job Role": {
"call": {
"call1": {
"processingType": "acctToEntMapping"
}
}
}
}
}
}
Job details:
2023-11-15T20:52:34+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-71-ffbnn-DEBUG-qry = SELECT il.IMPORTLOGID as IMPORTLOGID,il.logDataAsXML as logDataAsXML,ecmimp.jobid as jobID,ecmimp.jobname as JOBNAME,ecmimp.jobStartDate as JOBSTARTDATE,ecmimp.coments as COMMENTS,ecmimp.jobEndDate as JOBENDDATE,il.filename as FILENAME,ecmimp.SAVRESPONSE as SAVRESPONSE,ecmimp.systemName as SYSTEMNAME,ecmimp.externalconnection as EXTERNALCONNECTION,ecmimp.updateUser as UPDATEUSER,ecmimp.triggername as TRIGGERNAME,ecmimp.jobgroup as JOBGROUP,ecmimp.triggerType as TRIGGERTYPE FROM EcmImportJob ecmimp left join ImportLog il on(ecmimp.jobid=il.jobid) where 1=1 AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_OraclePLM_FLK_Account' AND ecmimp.jobgroup = 'DATA' ORDER BY ecmimp.jobid DESC limit 0,15
2023-11-15T20:52:34+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-71-ffbnn-DEBUG-extraQry = AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_OraclePLM_FLK_Account' AND ecmimp.jobgroup = 'DATA'
2023-11-15T20:51:56+05:30-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-3-w5l99-DEBUG-Only one instance is running.. Trigger Name : I_OraclePLM_FLK_Account
2023-11-15T20:51:56+05:30-ecm-worker-integration.ExternalConnectionCallService-quartzScheduler_Worker-3-w5l99-DEBUG-Key=jobtriggername Value=I_OraclePLM_FLK_Account
2023-11-15T20:51:47+05:30-ecm-domain.FlatViewJobcontrolController-http-nio-8080-exec-112-ffbnn-DEBUG-Inside fireJobAction params = [triggername:I_OraclePLM_FLK_Account, triggergroup:GRAILS_JOBS, jobname:SapImportJob, jobgroup:DATA, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]
2023-11-15T20:50:36+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-113-ffbnn-DEBUG-qry = SELECT il.IMPORTLOGID as IMPORTLOGID,il.logDataAsXML as logDataAsXML,ecmimp.jobid as jobID,ecmimp.jobname as JOBNAME,ecmimp.jobStartDate as JOBSTARTDATE,ecmimp.coments as COMMENTS,ecmimp.jobEndDate as JOBENDDATE,il.filename as FILENAME,ecmimp.SAVRESPONSE as SAVRESPONSE,ecmimp.systemName as SYSTEMNAME,ecmimp.externalconnection as EXTERNALCONNECTION,ecmimp.updateUser as UPDATEUSER,ecmimp.triggername as TRIGGERNAME,ecmimp.jobgroup as JOBGROUP,ecmimp.triggerType as TRIGGERTYPE FROM EcmImportJob ecmimp left join ImportLog il on(ecmimp.jobid=il.jobid) where 1=1 AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_OraclePLM_FLK_Account' AND ecmimp.jobgroup = 'DATA' ORDER BY ecmimp.jobid DESC limit 0,15
2023-11-15T20:50:36+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-113-ffbnn-DEBUG-extraQry = AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_OraclePLM_FLK_Account' AND ecmimp.jobgroup = 'DATA'
Kindly guide on the next steps.
Regards,
Vidhi.
Hello @sudeshjaiswal,
Below is the Postman response:
<html>
<head>
<base target="_self">
</head>
<body onLoad="document.myForm.submit()"><noscript>
<p>JavaScript is required. Please enable JavaScript.</p>
</noscript><!-- DO NOT REMOVE -->
<!-- loginform renderBrowserView -->
<!-- Required for SmartView Integration -->
<form
method="post" name="myForm">
<input type="hidden" name="enc_post_data" value="encquery=SNnkEOOst4oNelQWs+gZXREEDlpibIA97J85HTLFxutWSdmQaHeDXY+TJszoBDQJHaq6vDw1S/dZ6G2OKUrvJU9roK1siNmovGQ6F6ZkzhczSvbIexslSFFxE8NGozqyExiA92qKQOWlcu7q7lT0IxYjYj2wxliTX3K9GxHGur3lVvX5xjPTCbakjRx2eLQlyxBDfDg+rw3qUDhEUpw+AeH2e4jdK8cO5K2pYIbD9YZNZxw1riC/novReY1z8LT3DqOWH9+xG8E9GR+adOTgHftZB7Ns7pavutPz/fUj9hWtgiqtpko9uzTGfKXbiyo/y1259U2/RVP0ObCDEAPRi6jEx4qZy397nUM9/HX2kG+DsjE/91+g5NdrsLwhiAAFVDPtVP21xzQZSRDiyaUAe3mLobzHmIQK2h8rikloXwEzegg0+K2qPyD8SO5P4sFkwSMv/szeXhkE28mXylpwRcpgEXull3zMwB4yKTwD8f+aKdZkbOLeNhPTR1jsY+e86PjlMwo1BtbzF/bJkVWJFS/jQRxppsppgN/Lt6S7kk2vl7DH4hyKfCKN9CRBdDV/lah5yuk0fMFX2v7db9HeeYBx0e/WD0ieP3DpNdTYQxrC52qW/EyVvVpWbw0+17cs+8+YhRCsKd/M9rekfzRqUTWh07b/MSItob6f50B0B1dUsAm2mzacbFfJd9EhNX3W5XT9fzv4VVB2DmqZrDueJJpjgYbP9QFevcU9DzxX2/Rj95lxdcnCW5mFnqeR90A+h10PM5p1OB7HeXhinoMMnZ3BT8v3/jpFirwFBlR4CaYewIY7JwAwummSpsrBqMydv/gA5p9WkrvQiMIgP6LGBOkgiFMUTLOHu3Al51yWmOYN1iOMZa+Ha8t+gOkHi27tDBDs6+8QJBDrQgqIg419FT3h1fwVtIFyKz9fKwmturlLgZTTr+AJPIHkJi59eqLetadJphuNastEIfMz+//M930Bru7XUEOboeO1FWSOGisCdOdZBqXmHf6u7ioUrbYwLVnv7oO+mpSgkRf3WZozyQP9uzOpw37x+EWJIJg+6CtIWYmEkubWxdb/lHGgBAvt/p4yYW5PSRKbfvF+Z9RmELtUxSQbEUYy7Z6cR87hVcldvOp+mr50ODIGTLPE+uwTnkoe+TXVrp523VJ+n6RhTD/eUYy8o6l13TOtqtOWJSczt7sdwlabZ4zAIIemkus3hKKU0DnsaAhxz/J7yT9PCeK6LisAF/ByOPqOsFIvsq/VGzm+JwzWmKmmGtM7L4SMVESy+6GrswdjjaJNQRmrGcTBRj2HWoztCJg/4uscFSlmalWnZKidCRPMILbzgIWsA/gpfeTlLXzc2GUwAsRRqAjxM55LXInh3vryuXK4FXue6tT2gdRwDxyNUI4hqNXjZJjAVtwm5+qrFwNwTOBnD4+I2gwX4nY4MV+6CubJxD57NKP7tmj7Mofc8VzEgEr+Gqfezu3almsiWbCQ8XPH//cdXKZitp4cSueqrhZafqoa6Qpb48Os6YH5mXDNFcSGgD1UcwssSsxBYMFJgMW8IDuVEn/xSZFb9P28DiemlzRviSJYcISEP69gd7fyixmWzPUeMqY3eCCdyZC/F3Jea7OgbPUwu34vWwA2rlOZ6DZQjpJxbCPfWSfhpeDfUKoUUcjB/r6O7dBAaR9nqkrCaijka5cpPYUXh0WIhI6md0rMsun6pnqZq65fepTxMcmXjeMoSw87zcJgx6j4LetQq7SuZwo3ev/1COHsMMex7kb3V+2TuN2vDAByl/CTJwBv agentid=OraFusionApp_11AG ver=1 crmethod=2&cksum=117d56a2ca4423816e4047d1db7d96faf5f9df3d"></form>
</body>
</html>
@Vidhimehta,
Can you please pass the application/json in the postman and share the snippet,
PFA for ref.
Thanks.
Hello @sudeshjaiswal
Response:
<html>
<head>
<base target="_self">
</head>
<body onLoad="document.myForm.submit()"><noscript>
<p>JavaScript is required. Please enable JavaScript.</p>
</noscript><!-- DO NOT REMOVE -->
<!-- loginform renderBrowserView -->
<!-- Required for SmartView Integration -->
<form
method="post" name="myForm">
<input type="hidden" name="enc_post_data" value="encquery=T31EAEATpi2lXTDRlWij1zDux53pOSTa82dbPAdJtRVpWHQZnmQeYR2+z2aDJXY1vHupLLdWYyfUnXuaYLZLDjX/cgkBPOhADqgPHOWaC/EqdedVR3dtLN0D81X84IgKlkcfbWKet8W/SfhfofK3RvMetow1dLLqEfREPtDltIXnzptGmNxg1+iCXxXjCuQyA7BvnnZ+UX7FjsarPGsNIARc1UwWBOPVC89AjL96gIgPDSPwRpqigQyqTp0JJ5DrUNGHiBedEFWqLdcpzqD3GzBTzE9p+K6MAmv5Vnwzzb5QO1ejinNXksKN4oloftX6tVp31YaUDcyNYe9zbqP07R77R/eR9YAx19iEZzEFxG84ohTfDC6Ll3xf+f2bwF2a5htCN1zdN7RNgpFRHpKIhRCexD9IaywFJfFyGPKYdTelmPPcm+uapxmOuo/pWhSAGfLuFtaAUno4+uXKPjkHIxMTZCdiE9BRWgyauE8NF6uDJqQJi+u5xdJ61li4BjKFUsTBC5bGneu0tB37INiA23ebIp+qOemVopndqj0hthQ3+okivLr1PYH4OtirmLxhAQ5I4KOpWYpHO/Odw3XoNlvF5qDflVP4sOTq8YQwwcPSJLhvibwnkNuIeVGLZCnnxMz664bkHsnnIJVlZhS6L8z593wHvB8TypLoYLmtWrZStH8puykXPYAr0G5nInl1TAMVGiDJB2pf0xzb90ubXYpy380isYU/mFkzWgExWP9HC7fDjVDlYuwhpgvrU5CKC8q7rqxTIEb3KpJsxcIdQFSflnk3EGihpCWZjgIyrPuqVszdgR1KWxyZYxZHQbbmSdaF4S5ciNqJht43VyYRRRGfeQm2ft3GLHIrImH6TnrrtVuzgHfeDgPEtagD+JKux4303Fx3h318mkwxftx4OiLPyZlobPK8f2jKUVzRhwo+XnjD2GBEYAo5CRuuGBWzPw2pCjtK8KWFyECwYXC5zHflju3LzoQgwEbRBUazAcpTAQ7kz1X8RkUhkxjib5tKWTm4S0v+l3ZnQN31w8cjvp1XCwN3kwSkkIe8HbZ46gzuaDIOa4EELZcvLVsE0xtnvKA/7vUK98xfv55vQWVilfwni4dqlbRg7ASrsF/gX/wt6oxH2VBjuSOi9wocGjYEhCVTYZqDxR44Lha+nAyP16jyVpgHYmy+Ztmo1LRHyRhsEfYiMS1qkYcNhpQXinXuu/ovf7AP0M7tGQZ0aVSgLx6u5E4PzzeyRwrW8rKrDBYKWyHITiC/TQNkF86wHbL0k2kszPFbwNr/ETZNMu7iBYX1pEd7kS4VOTu4o2KWeXkIFMiB367DhHuk+OQ+LlSFO+9HEhImMywKV7zWdc4k0SzK5F1DtH3PigkclS0FQ4u88pI3yK7Q5FL5N7qmOuh86AHTxt5APKIJcHq7ar/CxlxcNqJc74R2FeUcp3k0G7TteA5z0WJPCrRTrLW9ZJ1X8IvfK8511DrPRX1JkqJEtHBlDyJxCxF/Tc3TiZCo0GA0kM26LxM1z44t9HsYA38XPVwEZ4xyZuReFDl/zfCVu5Gn3yBaoO7sMcgA/DBNFRBp6Nhi/w0kVuaM3pnuh9M9NM7AN9HHCsH1CoEwHK+tIOjXnPr4UfvLPoxgcKv/pK6fUrUw6BNdTT2d5n9N5vWgsmXpQRjGkhrGsMPpDiY2DDVUKWgugRc0Ei4sd/vPRtj9EUMUzV6w4qcG4mAe9MMeuk7Q7E4twdLbxekagQeIydnHAssiW0ZUKK9kEQDi0aJGgOco3Z7vB2p4ENGHiE4/R5xGUEtzafxZ4Iyiq0fJ0xqMVvPwnOgBCR2e3S3kPrOIzaWADi43/T98orVeloM/kPUN8GxWvlbuPnowS9f/pYyBbCOKzvqzo6IceNHnFlitMIH+qojulxuXDbkdP6Z/JBF7iTaxydo5U/voTTIWLFFZyIBDfCyWamV+NMaInAAWkGht4pUXJTmBXCCBGduw06s/iPFPeXwRkU33qZiC12ztP6B0cb6yz57DUsn5rd4= agentid=OraFusionApp_11AG ver=1 crmethod=2&cksum=cb66832a30b3d09ed581ab24ce8d5befede24cb6"></form>
</body>
</html>
Hello @Vidhimehta,
In this way we wont be able to track down the path and response, we need the response in this way
PFA for reference
Thanks
Hello @sudeshjaiswal,
Below details if it helps:
Let me know what you are looking for I can search accordingly and share the details.
Regards,
Vidhi.
Hello @sudeshjaiswal,
Below is the account import JSON. It is throwing an error now.
JSON:
{
"CONNECTION1": "netsuite",
"REQUESTXML1": "${String timestamp=new Date().getTime().toLong().toString().substring(0, 10); String nonce=java.util.UUID.randomUUID().toString().replace('-', '').substring(0, 20); String signature=org.apache.commons.codec.digest.HmacUtils.hmacSha256( (CONSUMER_SECRET+'&'+TOKEN_SECRET).getBytes() , (ACCOUNT+'&'+CONSUMER_KEY+'&'+TOKEN_ID+'&'+nonce+'&'+timestamp).getBytes() ).encodeAsBase64(); return '<soapenv:Envelope xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"> <soapenv:Header> <tokenPassport> <account>'+ACCOUNT+'</account> <consumerKey>'+CONSUMER_KEY+'</consumerKey> <token>'+TOKEN_ID+'</token> <nonce>'+nonce+'</nonce> <timestamp>'+timestamp+'</timestamp> <signature algorithm=\"HMAC_SHA256\">'+signature+'</signature> </tokenPassport> </soapenv:Header> <soapenv:Body>' + (nsId != null && nsId != '' ? '<ns3:searchMoreWithId xmlns=\"urn:customization_2020_1.setup.webservices.netsuite.com\" xmlns:ns2=\"urn:core_2020_1.platform.webservices.netsuite.com\" xmlns:ns3=\"urn:messages_2020_1.platform.webservices.netsuite.com\"> <ns3:searchId>'+nsId+'</ns3:searchId> <ns3:pageIndex>'+PAGE_NUMBER+'</ns3:pageIndex> </ns3:searchMoreWithId>' : '<platformMsg:search xmlns:platformMsg=\"urn:messages_2020_1.platform.webservices.netsuite.com\"> <platformMsg:searchRecord xsi:type=\"ns2:EmployeeSearchAdvanced\" savedSearchId=\"18732\" xmlns:ns2=\"urn:employees_2020_1.lists.webservices.netsuite.com\"> </platformMsg:searchRecord> </platformMsg:search>' ) + '</soapenv:Body> </soapenv:Envelope>';}",
"REQUESTPARAMS1": {
"Content-Type": "text/xml",
"SOAPAction": "${nsId != null && nsId != '' ? 'searchMoreWithId' : 'search'}"
},
"RESPONSEDATAPATH1": "${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.searchRowList.searchRow' : 'Body.searchResponse.searchResult.searchRowList.searchRow'}",
"RESPONSETOTALRESULTS1": "${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.totalRecords' : 'Body.searchResponse.searchResult.totalRecords'}",
"RESPONSEPAGERESULTS1": "${nsId != null && nsId != '' ? 'Body.searchMoreWithIdResponse.searchResult.pageSize' : 'Body.searchResponse.searchResult.pageSize'}",
"ACCOUNTMAPPING1": "name:basic.entityId.searchValue,customproperty1:basic.email.searchValue,accountid:basic.externalId.searchValue.@externalId,customproperty2:basic.giveAccess.searchValue",
"ENTITLEMENTMAPPING1": {
"Role": "basic.role.searchValue.@internalId"
},
"RESPONSEMAPPING1": {
"nsId": "Body.searchResponse.searchResult.searchId"
}
}
Error:
Regards,
Vidhi.
Hello @sudeshjaiswal,
Apologies, shared the wrong JSON.
Kindly find the correct JSON below:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"statusConfig": {
"active": "true",
"inactive": "false"
},
"statusAndThresholdConfig": {
"inactivateAccountsNotInFile": false,
"deleteLinks": "true",
"includeExistingInActiveAccounts": "true"
},
"http": {
"url": "***",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "Resources",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"displayName": "displayName~#~char",
"name": "userName~#~char",
"status": "active~#~char",
"customproperty1": "id~#~char",
"customproperty2": "#CONST#${String r1 = response.'urn:scim:schemas:extension:fa:2.0:faUser'.workerInformation.personNumber; return r1}~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
},
"acctEntMappings": {
"Job Role": {
"listPath": "roles",
"idPath": "value",
"keyField": "entitlement_value"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Job Role": {
"entTypeOrder": 0
}
}
},
"acctEntParams": {
"entTypes": {
"Job Role": {
"call": {
"call1": {
"processingType": "acctToEntMapping"
}
}
}
}
}
}
Job details:
The job ran successfully but no accounts have been imported.
Log viewer:
Kindly note it is an Oracle Fusion application, so if any other steps need to follow, kindly let me know.
Revards,
Vidhi.
