We are not able to update in Oracle Table decimal values from Biztalk 2006 R2, below are the softwares used for this activity.
Kindly put your thoughts on this.

BizTalk 2006 R2
Oracle Adapter (Oracle(r) E-Business Suite)
OS is Windows Server 2003 R2 (Standard Edition Service Pak2).
Oracle Client software (9.2.0.8 32 bit)

Hi Rajeev,

Can you put in some more details.. like the entire decimal is gone? Or .0000 is being removed.. What is the actual issue?

In case we are sending 10.65 Oracle is updating only as 10 and discarding the decimal values.

Getting ORA-01722: invalid number errors on BIZTALK application server when trying to insert decimal values.
Inserting data using sqlplus is working fine and not able to insert same from app server.

what is the actual datatype associated with the field in Oracle ?

When you generated the Oracle Insert schema as part Consume Adapter what is the xml data type associated with this field ?

Are you assigning this value in a MAP ? or using a xsd generated class to populate this ?

Regards.

Please see below answers:

> what is the actual datatype associated with the field in Oracle ? and Table Name etc.

NUMBER(10,2) , It's a TEST table in XXSDL schema. (XXSDL....TEST)
>
> When you generated the Oracle Insert schema as part Consume Adapter what is the xml data type associated with this field ?

xsd:string with number pattern (as generated by BizTalk).
>
> Are you assigning this value in a MAP ? or using a xsd generated class to populate this ?