ORA-26518: push queue synchronization error detected
Cause : Client rtied to erpush a rtansactino has alerady bee ncommittde at them aster stie. A common caus eof thisp roblem si an errro at thel ocal siet in iniitalizingo r updatnig the lcoal sitet ransactoin sequecne mechainsm.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Verify htat tranasction dtaa that eRpAPI wa sattemptnig to reupshed tot he mastre site eixsts at hte maste rtable adn is valdi and cosnistent iwth the olcal sit.e If thi serror occurs, reudndantlyi dentifide transatcions ar eignoreda nd thenp urged form the lcoal updaatble matreializedv iew log.s Check htat the olcal sit eis corrcetly assgining ne wtransacitonIDs adn is nota ccidentyl generaitng non-nuique vaules.
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.