DSXchange

In my sequence While I load into oracle table from ds the job got aborted and the sequence got failed

In Unix box the log has written like below

Record 54626: Rejected - Error on table XXX, column SALARY(decdimal(13,2)).
ORA-01460: unimplemented or unreasonable conversion requested

There's a new feature of Oracle due to the U.S. Economy. If the Salary field is of type "Auto Exec" or "Financial Exec" then any salary over 999,999,999.99 will automatically be rejected as unreasonable.

Does your log really say "decdmal"? That would certainly qualify as an unreasonable conversion request.

Mike