Turn off UTC for some dates
We have a global application with users in various countries so we have set our database server to UTC which works perfect when an order is being processed. However there are certain dates where we don't want this dates to be converted as per the timezone.
For eg: PL start Date and End Date, which is set in EBS and flows into Siebel. so if it is set to 01/01/2017 in EBS, it should be the same in Siebel 01/01/01 irrespective of timezone. Currently, this value is changing based on the user profile and causing lot of display issues.
Any help would be appreciated.