ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
Cause : The related dimension of the destination relation has the wrong data type.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Redefine the destination relation or choose another relation whose related dimension is of type NUMBER.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.