Is there some logic/criteria when date fields will be displayed in server timezone on form
Hi,
We are on R12.1.3.
DB storing time in GMT and server time is CST
Oracle forms are converting date/time from DB fields and displaying in CST (Forms like Sales order, Inv Cycle counting -> Approve counts forms)
One of inventory form is not (INVADCYC.fmb)
Navigation: Inventory -> Counting -> Cycle Counting -> Cycle counts
Here query any cycle count and then click on Items button, it opens another form. In this form 'Last schedule Date' is displaying date as in DB.
In DB(MTL_CYCLE_COUNT_ITEMS.ITEM_LAST_SCHEDULE_DATE) its been stored as date with 00:00:00 time stamp, considering this as in GMT as all other DB fields if we convert it to CST (GMT -5) then it should display a day before. Eg if DB has 12-JUN-2017 00:00:00, Form is displaying as 12-JUN-2017 where as expecting it to show as 11-JUN-2017.