Hi,
Here is the table definition.
As you can see that the actual and actualus columns have a decimal size of 6. But after loading it has only 4 decimals



SQL> desc testme
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPANY VARCHAR2(10)
TIME VARCHAR2(10)
REGION VARCHAR2(10)
LINEITEM VARCHAR2(15)
ACTUAL NUMBER(20,6)
ACTUALUS NUMBER(20,6)
YEAR_QUARTER VARCHAR2(5)

Also if you see my last sample record in the previous post it is getting converted properly. Its only a few records.


Thanks
Anurag