How does one run order import with multiple rows in OE_ACTIONS_IFACE_ALL for 2 different value of OPERATION_CODE?
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.
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_ALLFor example, to book and put order on hold, populate the interface table with:
#1. To book the order:
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.