Date Format issue in RFC adapter

[Former Member]

Hi All,

We have a SOAP to RFC synchronous  interface.

We have a date field in BAPI request message and ECC is expecting the date format to be MM/DD/YYYY.

But when we post RFC request message with this date format its shows following error in RFC receiver channel, though we are sending the expected date format :

Transmitting the message using connection SOAP_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: com.sap.aii.adapter.rfc.afcommunication.RfcAFWException: error while processing message to remote system:com.sap.aii.adapter.rfc.core.client.RfcClientException: could not convert request from XML to RFC:com.sap.mw.jco.JCO$ConversionException: (122) JCO_ERROR_CONVERSION: Date '09/22/2014' has a wrong format at field ERDAT: Unparseable date: "09/22/2014

We have SAP PO single stack 7.31 server.

Please let me know how can we get this issue fixed.

Thanks,

Jane

[nabendu_sen · Accepted solution]

Hi Jane,

BAPI only accepts date field with Format YYYYMMDD, not anything else.

Still you can try with MMDDYYYY, but don't think that would work.

This conversion from YYYYMMDD to MMDDYYYY should be done automatically at SAP side, PI should keep YYYYMMDD.

Regards,

Nabendu.

[Former Member · Accepted solution]

Thank You Hareesh and Nabendu for the response.

I did try sending the request message with date format as YYYYMMDD, and message got processed successfully and we received the response message as well from ECC.

But the problem is in response message it shows" Error in Fetching TI entries" where as it should have sent the values available for the particular date we have sent in request message.

However i am checking with ECC team, as BAPI accepts only YYYYMMDD format.

Will keep you posted on this.

Thanks,

Jane

[former_member184720 · Accepted solution]

You can debug the RFC with the same date and see if it is extracting any details.

[Former Member · Accepted solution]

Hi Hareesh,

Checked with ECC team on date format. They agreed to receive date format as YYYYMMDD from SAP PI. And with this format and other details passed in request message we are able to get the response message back from ECC with correct details extracted in it.

Thanks

Jane

[former_member184720]

AFAIK - internal dateformat is YYYYMMDD. May be you can try with that..