Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/13/2023 07:49 AM
Hello Team,
We are having issues with the provisioning for the oracle EBS and getting an error "SAV - Error while creating account - Kameron.OLeary-Exception occured while Excecuting Query".
Json:
{
"CreateAccountQry": ["CALL xxads_fnd_user_pkg.createuser('${user.username}','','${randomPassword}',0,SYSDATE,'${ if (user.enddate == null) {''} else {new java.text.SimpleDateFormat('dd-MMM-yy').format(new java.text.SimpleDateFormat('yyyy-MM-dd HH:mm:ss.SSS').parse(user.enddate.toString()))}}',SYSDATE,'${user.customproperty42} ${user.customproperty43}','','','',90,'${user.customproperty26}','${ if (user.customproperty16 != null && user.customproperty16 != '') {user.customproperty16} else { if (user.email != null && user.email != ''){user.email} else {''}}}')", "CALL xxads_fnd_user_pkg.user_synch ('${accountName.toUpperCase()}')"]
}
can somone help us if we are missing anything
Regards,
Rashmitha
07/13/2023 08:21 PM
Initialization of new variable is not allowed in v23.x