Oracle DB createAccountJson failing

[sk]

Hello team,

We are having an issue in oracle db where we need to create a new account and also insert values into a DBA table.

We are using the below CreateAccountJson

{
"createAccountqry":["CREATE USER \"${user.username}\" IDENTIFIED BY \"${password}\" PROFILE \"DBA_USER\"",
"INSERT INTO pl_users (USER_NM,LAST_NM,FIRST_NM,PHONE_NB,LOCATION_CD,USER_TYPE) values( '${user.username}','${user.lastname}','${user.firstname}','${user.phonenumber}','${user.location}','${user.employeeType}')"]
}

CREATE USER \"${user.username}\" IDENTIFIED BY \"${password}\" PROFILE \"DBA_USER\"", this is working fine after adding insert statement getting the error (Exception occured while Excecuting Query)

please let me know if I am missing here

[rushikeshvartak]

{
  "createAccountqry": [
    "CREATE USER \"${user.username}\" IDENTIFIED BY \"${randomPassword}\" PROFILE \"DBA_USER\"",
    "INSERT INTO pl_users (USER_NM,LAST_NM,FIRST_NM,PHONE_NB,LOCATION_CD,USER_TYPE) values( '${user.username}','${user.lastname}','${user.firstname}','${user.phoneNumber}','${user.location}','${user.employeeType}')"
  ]
}

[sk]

@rushikeshvartak , I have tried with above Json

getting the below error

 Exception occured in Create Account Query - ORA-28003: password verification for the specified password failed ORA-20000: password length less than 12 bytes

[rushikeshvartak]

Did you added password policy in accordingly do database.?

[sk]

@rushikeshvartak , Yes we do have added that configuration

Still getting the error 
Exception occured in Create Account Query - ORA-28003: password verification for the specified password failed ORA-20000: password length less than 12 bytes

[rushikeshvartak]

Hardcode password and try and are you able to create user directly from database?

{
  "createAccountqry": [
    "CREATE USER \"${user.username}\" IDENTIFIED BY \"RUHIKESH@Forum@2024\" PROFILE \"DBA_USER\"",
    "INSERT INTO pl_users (USER_NM,LAST_NM,FIRST_NM,PHONE_NB,LOCATION_CD,USER_TYPE) values( '${user.username}','${user.lastname}','${user.firstname}','${user.phoneNumber}','${user.location}','${user.employeeType}')"
  ]
}

[sk]

@rushikeshvartak - Yes we are able to create user directly in database.

After hardcoding the password, we are getting the below error but that user is not there in database.

 SAV - Error while creating account - xxxxxx- Exception occured in Create Account Query - ORA-01920: user name 'xxxxxx' conflicts with another user or role name

[rushikeshvartak]

User must be exists try with new user