Skip to Content
0
Former Member
Mar 23, 2009 at 02:57 PM

Reg:Date issue

24 Views

Hi...

I am having problem with the date.

I need to update the values based on the key field.

The structure is like...

<?xml version="1.0" encoding="UTF-8" ?>

- http://test.com/payment/DD_CC">

- <Statement>

- <AXIS_TABLE action="UPDATE">

<table>AXIS_TRANSACTION_DETAILS</table>

- <access>

<CHEQUE_NUMBER>20202730</CHEQUE_NUMBER>

<REVERSE_FEED_FLAG>Failure</REVERSE_FEED_FLAG>

<TEXT_DESCRIPTION4>FAILURE</TEXT_DESCRIPTION4>

<STATUS_DATE>03/03/2009</STATUS_DATE>

</access>

- <key>

<TRANSACTION_ID>68</TRANSACTION_ID>

</key>

</AXIS_TABLE>

</Statement>

</ns0:MTI_ReverseFeed_DB>

While executing, in the receiver side i am getting the below error.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'AXIS_TRANSACTION_DETAILS' (structure 'Statement'): java.sql.SQLException: ORA-01843: not a valid month .

Can you please tell how to solve this issue...?

Thanks & Regards,

Leela