Skip to Content
0
Former Member
Feb 17, 2009 at 08:17 AM

Problem with date format from Oracle DB

347 Views

Hi,

I am facing a problem with date fields from Oracle DB sources. The date format of the field in DB table is 'Date base type is DATE and DDIC type is DATS'.

I mapped the date fields to Date characters in BI. Now the data that comes to PSA is in weird format. It shows like -0.PR.09-A

I have changing the field settings in DataSource to internal and external and also i have tried mapping these date fields to text fields with out luck. All delivers the same format.

I have also tried using conversion routines like, CONVERSION_EXIT_IDATE_INPUT to change format. It also delivers me the same old result.

If anybody of you have any suggestions or if anybody have you experienced such probelms, Please share your experience with me.

Thanks in advance.

Regards

Varada