ORA-31514: change set string disabled due to capture error
Cause : This change set has encountered a capture error and was disabled.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Contact the change set's publisher to request that the capture error be resolved. Subscriptions using this change set cannot be activated or have their subscription windows extended or purged until the capture error is resolved.
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.