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.

1 comment:

  1. Thanks for all the information, it was very helpful I really like that you are providing information.
    Oracle Financials Training

    ReplyDelete