Data format "-0.PR.20-A" in PSA by loading date from oracle to BI typ DATS

[former_member363950]

By loading oracle date data with DB connect from oracle database to SAP BI with data type DATS, i become such a date data "-0.EB.15-F" in the PSA. Can i transfer this date data in the infoprovider and get a gut date as yyyymmdd or ddmmyyyy or ...

Or this data is not usable.

1.If this date data "-0.EB.15-F" is not usable, how can i load the oracle data from type DATE (i see it from the datasource proposition date to DATS)

2. If those data are false or not usable,

2.a. how can i delete those data in the PSA without transfer it with DTP in the infoprovider,

2.b. can i then for that characteristic attribute from type DATE in oracle change the the previous data type DATS for the BI characteristic to 0DATE and have a successfully data load. Is it possible in this case to made a full load a second type with the same infopackage after deleting the data in the PSA.

Thank you for helping

Kind reagrds

Ar

Edited by: Arnaud on Jul 18, 2009 2:29 PM

Edited by: Arnaud on Jul 18, 2009 2:32 PM

[desgallagher]

Hi Arnaud,

Please refer to the bottom of the SAP note 518241, there is a section on successfully converting date and time

fields from Oracle DB. Please refer to Oracle documentation for further information.

Best Regards,

Des

[former_member363950]

In oracle documentation, it is written:

"

Oracle/PLSQL: To_Char Function

In Oracle/PLSQL, the to_char function converts a number or date to a string.

"

In the SAP Note the conversion will looking like this:

SQL> select to_char(LAST_ANALYZED,'YYYYMMDD') as dat from dba_tables

where table_name like 'RS%' and rownum < 10 ;

Is it that after the conversion as view the data would appear in the Datasource in a varchar format?

Would it be possible to use a 0date or a DATS attribute as corresponding attribute in the Datasource. Or how can i do it? to have the date in BI as DATS or 0date.

Kind regards i thank for helping

Ar.