Technology Stack - EBS (MOSC)

MOSC Banner

Is there some logic/criteria when date fields will be displayed in server timezone on form

edited Aug 20, 2021 11:02AM in Technology Stack - EBS (MOSC) Question

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center