4 Replies Latest reply on Sep 13, 2013 6:01 AM by S.Ananth

    Database adapter - timezone value not being picked up


      We are using Oracle SOA suite v, along with database adapter to connect to different Oracle database - D1 and D2. All 3 system - SOA suite, D1 and D2 are set to different timezones. Within the SOA composite, we are using Database adapter to

      1. query data from Oracle database
      2. execute pl/sql stored procedure in Oracle database.


      In all cases we noticed that the date time data seen in the SOA EM console is same as in the respective database system, but surprisingly the timezone value in the data field is constant and it does matches with that of SOA suite.



      Ideally the timezone value should match with that of respective database, from where the date value is being picked up. Did we miss any set up or this a known issue ?