Hi,
I am pulling sales from Oracle (JDBC) and pushing it into R3 (RFC) . I have written my own RFC which is successful in pulling ONE sales order and creating the same in R3 with multiple line items.
My problem is that I am unable to push multiple sales orders in R3 though sales order header in RFC is 0..unbounded. When I create multiple sales order in message mapping testing, it creates on RFC side also. But at run time it does not create a separate header as a result no sales orders are created. It has also occurred that the payload structure for the inbound message can not be changed, no matter I change the data type. At run time header and items are at same level in case of inbound messages.
<?xml version="1.0" encoding="utf-8" ?>
- <resultset>
- <row>
<ORDER_NO>821217</ORDER_NO>
<ORDER_DATE>2004-05-31 11:41:27.0</ORDER_DATE>
<SUBORDER_NO>1</SUBORDER_NO>
<PAY_METHOD>cd</PAY_METHOD>
<USER_ID>wowowo</USER_ID>
<ORDER_STATUS>Order Under Process</ORDER_STATUS>
<QUANTITY>1</QUANTITY>
<TOTAL>375</TOTAL>
<SAP_MAT_CODE>1000000081</SAP_MAT_CODE>
</row>
</resultset>
Help is appreciated.
Preeti