field dateExpiry format date

[Former Member]

hello,

i've a interface RFC - JDBC (oracle).

i've a field dateExpiry, in R3 is date type. In oracle the same field is also date type. The mapping is directly, however the follow error occurs:

ORA-01861: literal does not match format string

why?

thanks very much

[Former Member]

Silvia ,

Solution is simple :

First check the date format in oracle .

Default is DD-MM-YYYY .

For verifying use :select sysdate from dual;

With the functions to_char and to_date, a date format can be used.

Example: select to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual;

will return something like: 05/08/2009 14:36:43

Now use date transformation @mapping time to change the date format as per the oracle's date format before passing it to JDBC adapter .

that's it..

Regards,

[Former Member]

Hi,

In oracle default date format is "DD-MON-YY". example "12-Aug-09".

So using DateTransformation standard function to change ur needs in mapping level.

SourceFormat : "yyyy-MM-dd"

TargetFormat : "dd-MMM-yy"

I hope it's helpful.

Regards

Vijay

[Former Member]

yes, you are it right,

in R3 debug, the format is 20091212, in sxmb_moni, payload, the value is 2009-12-12 why?

[santhosh_kumarv]

check the mapping.....

~SaNv...

[former_member187339]

Hi Silvia,

The R3 format of date is different from oracle format. Use the DateTrans standard function in message mapping and you will get th desired output

Regards

Suraj

[GabrielSagaya]

I think you have use UDF to convert to correct format.

This thread will help you!!

[santhosh_kumarv]

this could be because of the difference in the date format in R/3 and DB.... R/3 generally follows data format as YYYYMMDD however DB might folly timestamp format.... check this....

~SaNv...