Projects - EBS (MOSC)

MOSC Banner

Date format issue in BI Excel Output

edited Oct 16, 2015 10:04AM in Projects - EBS (MOSC) 1 commentAnswered

Hi Team,

I am working on BI publisher with excel output for PA to OTL Reconciliation.

For this report II have to provide 2 input parameter Start_date, End_date.

I am taking above values from PA_PERIODS_ALL (start_date, end_date) through value set.

Both the dates should be print in excel output also.

From the LOV I am selecting Start_Date as 01-JAN-2004 but in report output I am getting as like this '2004-01-01T00:00:00.000+00:00', same way for end_date too.


Please help me how to achieve to print the date as 01-JAN-2004.


Report output:


Thanks,

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