Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Provisioning issue with oracle ebs

RCreddy
New Contributor
New Contributor

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

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Initialization of new variable is not allowed in v23.x


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.