Gretings,
I am setting a scenario JDBC (Access) -> XI -> Idoc ->R3.
First I set up the scenarion File ->XI ->IDOC. Everything worked fine, and the I tried to use JDBC adapter instead of the File Adapter. The JDBC adapter is able to retrieve the data from the Access Database but I got a mapping problem only the Idoc control record was filled, the data segment are empty.
This mapping was working fine in the case of a File adapter !!!
Here is the XML File in a case of File Adapter :
<?xml version="1.0" encoding="UTF-8" ?>
- http://aramco.com/XI/POS_OIL">
<DATE>11/17/2004</DATE>
<TIME>08:25:03</TIME>
<TRANS_CODE>01</TRANS_CODE>
<CUSTOMER>1235</CUSTOMER>
<AMOUNT>105</AMOUNT>
<POS_ID>1000</POS_ID>
</ns:POS_TRANSACTION>
And then The XML file in a case of JDBC adapter :
<?xml version="1.0" encoding="utf-8" ?>
- http://aramco.com/XI/POS_OIL">
- <row>
<DATE>11/17/2004</DATE>
<TIME>00:00:07</TIME>
<TRANS_CODE>01</TRANS_CODE>
<CUSTOMER>23456</CUSTOMER>
<AMOUNT>1456</AMOUNT>
<POS_ID>1000</POS_ID>
</row>
</ns:POS_TRANSACTION>
what is really strange is SAP XI mapping process should be adapter independent ! why am I having this problem ?
Any help is more than welcome.
Regards,
Mustapha