SQL & PL/SQL

Hi,

I am currently integrating Salesforce with ERPLN data via Informatica Cloud ETL.
The client is on ERPLN 6.1, Fp3, and Oracle 10 database and AIX OS. Both the LN Application and Oracle database are on the same Timezone GMT +1.00.

We observed that for Sales/Service Order dates, on Application front and on actual oracle database the date shown are different. There is a difference of either 1 hour or 2 hours, based on the day light savings in Europe.
Because of this difference, there is invariable changes in dates as well. For eg. Service Order date shown on ERPLN Application is 01-Jan-2013 00.12.25, but for the same service order the date stored in oracle database is 31-Dec-2012 23.12.25. Difference of 1 hour results in change of date as well. The difference doesnt remain the same over period, since there is day light savings as well.

So when we pull this data via ODBC connectivity in to Staging Database through Informatica cloud, the date shown is that of Oracle Database. When we push this date in to Salesforce, we want the dates shown same as that of ERPLN application.

Has anyone encountered such problems before, if yes, than what is the resolution for the same? I understand we change the TimeZone of the ODBC user, but that isnt possible or it doesnt help.

Appreciate your quick reply. Thanks much.

Warm Regards,

Raviraj Raikar