Technology Stack - EBS (MOSC)

MOSC Banner

Incorrect Date displayed when exporting data to excel

in Technology Stack - EBS (MOSC) Question

Hello,

As part of business requirement  we developed  a custom OAF page  to pull  information for cycle count details from oracle inventory tables. In the custom OAF page there is a scheduled date column which displays data in Central time zone. Page also has feature to export data to excel file .

Notice when reviewing data in excel, see that scheduled date is displaying  previous day's date.

Ex: In  OAF page scheduled date column date is displayed as 27-Apr-2017 which is correct. After exporting data to excel and reviewing data, scheduled date column is displaying date as 26-Apr-2017.

Basically what we are seeing is, when data is exported to excel, scehduled date column in excel sheet is displaying one day deducted from scheduled date displayed in OAF page schedule date column.

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

EBS TechStack Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center