Saviynt Forums

Vidhimehta · ‎11/15/2023

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.

sudeshjaiswal · ‎11/15/2023

Hello @Vidhimehta,

Can you please share the postman response.

Thanks,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎11/15/2023

Hello @sudeshjaiswal,

Below is the Postman response:

<html>

<head>

</head>

<p>JavaScript is required. Please enable JavaScript.</p>

</noscript>

<form

action="https://login-euid-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/oam/server/obrareq.cgi?ECID-Context=1..."

method="post" name="myForm">

</body>

</html>

sudeshjaiswal · ‎11/15/2023

@Vidhimehta,

Can you please pass the application/json in the postman and share the snippet,
PFA for ref.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎11/15/2023

Hello @sudeshjaiswal

Response:

<html>

<head>

</head>

<p>JavaScript is required. Please enable JavaScript.</p>

</noscript>

<form

action="https://login-euid-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/oam/server/obrareq.cgi?ECID-Context=1..."

method="post" name="myForm">

</body>

</html>

sudeshjaiswal · ‎11/15/2023

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

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎11/15/2023

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.

sudeshjaiswal · ‎11/16/2023

Hello @Vidhimehta,

Could you please let me know how gave the filter in the importaccountjson

acctEntMappings": {

"Job Role": {

"listPath": "roles",

"idPath": "value",

"keyField": "entitlement_value"

and how you are giving the details here, would like to understand, as it saying in your postman to enable the javascript.
also could you please provide the postman response from the one of the account, when you hit the url, when you get the account details in the postman.

Thanks,

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎11/21/2023

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.

Vidhimehta · ‎11/28/2023

Hello @sudeshjaiswal,

Any update here?

Regards,

Vidhi.

sudeshjaiswal · ‎11/28/2023

Hello @Vidhimehta,

Could you please confirm, if you are using Rest or Soap Connector, As initally you mentioned it as REST Connector, now you share the XML using the Soap Connector.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎11/28/2023

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.

Vidhimehta · ‎11/29/2023

Hello @sudeshjaiswal ,

Any update here?

Vidhimehta · ‎12/01/2023

Hello @sudeshjaiswal ,

Any update here?

sudeshjaiswal · ‎12/01/2023

Hello @Vidhimehta,

Sorry for the delay in the response, could you please share the compelete log.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎12/04/2023

Hello @sudeshjaiswal,

All details shared in the thread. Kindly let me know if you are looking for something specific, I can share accordingly.

Regards,

Vidhi.

Vidhimehta · ‎12/04/2023

Hello @sudeshjaiswal,

Additionally kindly find the Postman response as below:

sudeshjaiswal · ‎12/04/2023

Hello @Vidhimehta,

Thanks for sharing the postman snippet, can you please confirm if you are passing anything in the headers as well?
Please provide the snapshot from the postman.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎12/04/2023

Hello @sudeshjaiswal,

Kindly find the below details:

Kindly find the API details for the application: https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/23d/fasrp/op-useraccountslov-ge...

sudeshjaiswal · ‎12/04/2023

Hello @Vidhimehta,

Is the connection successful,

Can you try with the below sample,

ImportAccountJson
{
    "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": "***",
                    "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"
                }
            }
        }
    }
}

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎12/06/2023

Hello @sudeshjaiswal.

The connection has been successful since the start. The job is also run successfully. After updating the above JSON in the ImportAccountENT JSON. However, the accounts are still not imported.

Below Log details:

2023-12-06T16:14:17+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-6-grswr-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-12-06T16:14:17+05:30-ecm-domain.JobcontrolController-http-nio-8080-exec-6-grswr-DEBUG-extraQry = AND (ecmimp.jobname = 'SapImportJob' OR ecmimp.jobname ='SAPIMPORTJOB' ) AND ecmimp.triggername = 'I_OraclePLM_FLK_Account' AND ecmimp.jobgroup = 'DATA'

2023-12-06T16:13:59+05:30-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-1-hh2bg-DEBUG-Only one instance is running.. Trigger Name : I_OraclePLM_FLK_Account

2023-12-06T16:13:59+05:30-ecm-worker-integration.ExternalConnectionCallService-quartzScheduler_Worker-1-hh2bg-DEBUG-Key=jobtriggername Value=I_OraclePLM_FLK_Account

2023-12-06T16:13:49+05:30-ecm-domain.FlatViewJobcontrolController-http-nio-8080-exec-7-grswr-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]

Regards,

Vidhi.

sudeshjaiswal · ‎12/06/2023

Hello @Vidhimehta,

Can you please share the complete debug logs.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Vidhimehta · ‎12/08/2023

Hello @sudeshjaiswal,

Kindly let me know how to source the complete debug logs.

Kindly find the current logs:

2023-12-08T17:38:41+05:30-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-2-b2bcc-DEBUG-Only one instance is running.. Trigger Name : I_OraclePLM_FLK_Account

2023-12-08T17:38:41+05:30-ecm-worker-integration.ExternalConnectionCallService-quartzScheduler_Worker-2-b2bcc-DEBUG-Key=jobtriggername Value=I_OraclePLM_FLK_Account

2023-12-08T17:38:15+05:30-ecm-domain.FlatViewJobcontrolController-http-nio-8080-exec-5-dmxgq-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]

Kindly let me know i any additional information is needed.

Regards,

Vidhi.

sudeshjaiswal · ‎12/10/2023

Hello @Vidhimehta,

Please use the below json,

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"statusAndThresholdConfig": {
"statusColumn": "customproperty2",
"activeStatus": [
"N"
],
"deleteLinks": true,
"accountThresholdValue": 10,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"http": {
"url": "https://xxxxxx/userAccount",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "Username~#~char",
"displayName": "Username~#~char",
"name": "Username~#~char",
"status": "active~#~char",
"customproperty2": "Suspended~#~char"
}
}
}
}
}

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Saviynt Forums

Oracle PLM Onboarding