The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM Export Excel : Format issue

Highlighted
Mikia
Super Collector

PPM Export Excel : Format issue

Dear all,

 

we have an issue regarding the export in an Excel file using the Oracle spool method (we generate a Report).

 

In our DB we have the same data format (we format the data before the extraction in a complex view), but after the Oracle spool we have two different format for the same field. 

 

Attached you can find two queries and the Report result which explains the issue (I hope).

 

The queries  (sheet "queries") show how the field is formatted in our DB, and in the sheet "rep_45074" how the field is formatted in Excel file.

 

Could you help us?

 

Thans in advance for your help!

 

mara

 

1 REPLY
Vineet Shiva Ku
Super Collector

Re: PPM Export Excel : Format issue

Have you tried altering the NLS parameter for the Oracle session in the report SQL script..?

 

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD hh24:MI:SS';

 

----------------------------------------------------------------

++ Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

----------------------------------------------------------------
++ Remember to give Kudos to answers..! (click the KUDOS star)

//Add this to "OnDomLoad" event