Skip to Content
0
Former Member
Oct 25, 2005 at 10:54 AM

Multiple Sales Order

69 Views

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>

satyajitroshan.com

<SAP_MAT_CODE>1000000081</SAP_MAT_CODE>

</row>

</resultset>

Help is appreciated.

Preeti