on 2009 Aug 04 1:21 PM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, you are it right,
in R3 debug, the format is 20091212, in sxmb_moni, payload, the value is 2009-12-12 why?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.