Creating Referenced RMA’s using OE_ORDER_PUB

Creating referenced RMA’s using OE_ORDER_PUB:

Tables Effected: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL.

Creating RMA is very similar to creating an Order. We need to make sure we are passing the correct order_type, line_type which will be setup as ‘RETURN’ (or ‘MIXED’) category in transaction type definition.

For the API to automatically create a reference on your RMA lines to the original Order lines, we need to pass the following :

Sample code to create Referenced RMA’s:

Result:
Once the RMA gets created, query the order and navigate to Lines>Returns tab. We can see the original order number and line number.

Leave a Reply