Provisioning issue with oracle ebs

CRashmitha
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 the response is helpful, please click Accept As Solution and kudos it.