Error while creating PeopleSoft account

[Nova25]

We have onboarded the PeopleSoft application and are using a database connection for account import and provisioning. We also tried using the PeopleSoft connection for provisioning, but both attempts are failing. When provisioning through the database, we encounter the following error: 'Exception occurred in Create Account Query - ORA-01400: cannot insert NULL into ("PSACCID"."PSOPRALIAS"."SETID").'

We are using the following JSON in the database connection to create the account:

{
"CreateAccountQry": [
"INSERT INTO PSOPRALIAS (OPRID, OPRALIASTYPE, OPRALIASVALUE, SETID, EMPLID, CUST_ID, VENDOR_ID, APPLID, CONTACT_ID, PERSON_ID, EXT_ORG_ID, BIDDER_ID, EOTP_PARTNERID) VALUES (upper('${task.accountName}'),'EMP',upper('${task.accountName}'),'',upper('${task.accountName}'),'','','','','','','',0)"
]
}

For the PeopleSoft connection we are using this JSON:

{
"UserID": "${user.employeeid}",
"Description": "Saviynt_Created",
"InteractiveMode": "true",
"GetHistoryItem": "true",
"EditHistoryItem": "true",
"UserIDAlias": "${user.employeeid}",
"LanguageCode": "ENG",
"Opertype": "0",
"SymbolicID": "",
"LanguageEnabled": "0",
"FailedLogins": "0",
"ExpertEntry": "0",
"AllowSwitchUser": "0",
"IDType": "EMP",
"EmplId": "${user.employeeid}",
"ppl": "ALLPAGES",
"RowSecurityPermissionList": "ALLPAGES",
"ProcessProfilePermissionList": "ALLPAGES",
"NavigatorHomePermissionList": "ALLPAGES",
"EmailType": "BUS",
"EmailAddress": "${user.email}",
"PrimaryEmail": "Y",
"SetID": "COMMN"
}

and we are getting this error:

Thank you

[rushikeshvartak]

• Does insert query works in database?
• share logs in text file

[Nova25]

Hi Rushikesh,

Please find the attached logs.

[rushikeshvartak]

esponseText:{"error":{"message":"User Not Authorized","detail":"Failed API level ACL Validation"},"status":"failure"}

• Your service account does not have required access for user creation

[Nova25]

The service account we are using has full access, please see the attached screenshot:

 

[rushikeshvartak]

Are you able to create from postman/UI/database ?

[Nova25]

We have not tested using Postman. Is there any documentation or guidelines we can use to create accounts through Postman?

Thank you

[rushikeshvartak]

This is outside saviynt you can check with app team or google search 

https://www.youtube.com/watch?v=i1g7VAncRoE&ab_channel=PeopleSoftChannel

[stalluri]

@Nova25 
https://docs.saviyntcloud.com/bundle/PeopleSoft-v24x/page/Content/Managing-Users.htm

Based on the log provided it says unable to connect to application server.
Can you share full logs in TEXT file.

                    Refer: https://forums.saviynt.com/t5/help/faqpage/title/WhenNotifyAboutPII

❗🚫⚠️❗Do not upload any attachments or data that contain sensitive information, such as PII, IP Addresses, URLs, Company/Employee Names, Email Addresses, etc. ❗⚠️ 🚫❗

[Nova25 · Accepted solution]

This issue has been resolved. The root cause was that PeopleSoft uses different handlers, each associated with a different port number. We were using port 9300, which was busy and not accepting our requests. As a result, it attempted to use the next available ports (in our case, 9301 through 9307). However, those ports were blocked. Once we opened these ports, the requests went through successfully, and the account was created.