Hi Kasinath,
I have faced to similar issues recently, If you are using mapping String to Date type(String to Date) we have service available in WMPublic folder. If you are mapping to a timestamp type try using this format: dd-MMM-yy hh.mm.ss.SSSSSS a. Oracle understands this format.
If you need more information, i will help you.
thanks & regards,
vijay