Infolinks

Monday 24 September 2012

Run Order import with multiple OPERATION_CODE in

Run Order import with multiple OPERATION_CODE in OE_ACTIONS_IFACE_ALL

How does one run order import with multiple rows in OE_ACTIONS_IFACE_ALL for 2 different value of OPERATION_CODE?

You can populate CHANGE_SEQUENCE field.

For example, to book and put order on hold, populate the interface table with:

#1. To book the order:
OE_HEADERS_IFACE_ALL
ORDER_SOURCE_ID=1
ORIG_SYS_DOCUMENT_REF=1
CHANGE_SEQUENCE=1

OE_ACTIONS_IFACE_ALL
ORDER_SOURCE_ID=1
ORIG_SYS_DOCUMENT_REF=1
CHANGE_SEQUENCE=1
OPERATION_CODE=BOOK_ORDER

#2. To put order on hold:

OE_HEADERS_IFACE_ALL
ORDER_SOURCE_ID=1
ORIG_SYS_DOCUMENT_REF=1
CHANGE_SEQUENCE=2

OE_ACTIONS_IFACE_ALL
ORDER_SOURCE_ID=1
ORIG_SYS_DOCUMENT_REF=1
CHANGE_SEQUENCE=2
OPERATION_CODE=APPLY_HOLD

Note:
When you run the order import, one of the parameter is 'Number of Instances', and you have to pass value of 1, otherwise order import will not run correctly.

No comments:

Post a Comment