ORA-27419: unable to determine valid execution date from repeat interval
Cause : The specified repeat interval contained conflicting clauses that made it impossible to ever find a matching date, e.g., 'FREQ=YEARLY;BYMONTH=FEB;BYMONTHDAY=31'. Alternatively, the scheduler reached its maximum number of attempts to try to find a valid execution date. This occurs when theoretically there is a valid execution date far in the future, but the scheduler took too many attempts to determine this date.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Remove the conflicting clauses, or simplify the repeat interval so that it is easier to determine the next execution date.
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.