This chapter covers the following topics:
Order Management supports integration of sales orders and its entities with external systems via web services. The following sections provides details of such Interfaces provided by Order Management.
Internal Name - OE_INBOUND_INT
The web services provided via this interface provides services to create, update, delete, and retrieve sales order information and its entities from Order Management.
The list of web services is as follows:
This webservice retrieves Sales Order Information from Order Management entities.
If this webservice is invoked by passing header_id, the entire order information including all the lines is retrieved and passed as response.
If this webservice is invoked by passing both header_id and line_id, the header information and corresponding line information is retrieved and passed as response.
If this webservice is invoked by passing Order Number, the entire order will be retrieved only if there is one order based on Order number, Order type, and highest version number combination. Otherwise, this webservice returns an error requesting the user to pass the Order type also.
If this webservice is invoked by passing Order Number and Order Type, the entire order information including all the lines is retrieved and passed as response.
This webservice is used to create, update, or delete Sales Order Information in Order Management entities.
The entities supported by this webservice are - Order Header, Order Lines, Price adjustments, Pricing attributes, sales credits, and payments. Lot and Serial number information are supported for return lines. This webservice also supports action requests that allow you to execute different actions such as booking, hold application and removal, automatic attachments, fulfilment set application and removal, match and reserve for Configured items, get ship method and freight rates (both individually and together), and the linking and delinking of Configured items.
Similar to the Sales Order Service, this webservice is also used to create, update, or delete Sales Order Information in Order Management entities. However, this webservice supports assigning Null values to attributes which was not supported via ‘Sales Order Service’.
A system lookup Null Indicators for Inbound Process Order attributes is defined with the lookup codes CHAR, SHORT_CHAR, DATE, and NUMBER. Meanings defined for those lookup codes are used as an indicator of Null value.
To create or update a sales order and its entities with null values for certain attributes, the values mentioned in the Meaning for the lookup codes CHAR, SHORT_CHAR, DATE and NUMBER must be passed via payload for Character attributes that can hold more than 9 characters, Character attributes that cannot hold more than 9 characters, Date attributes, and Number attributes respectively.
You can change the default Null indicators for each data type in the Lookup to meet your requirements. To change the default NULL indicators, consider the following:
The indicator for the NUMBER lookup code must support numeric conversion.
The indicator for the DATE lookup code must be entered in ‘YYYY-MM-DD’ format only. Character to Date conversion of that date indicator will be done using that format only.
The indicator for SHORT_CHAR lookup code must be of one character only to support attributes with length of 1-9 characters.
The indicator for CHAR lookup code must have a maximum of 10 characters to support attributes with length of 10 characters and above.
This webservice is dedicated for Oracle Order Management Cloud integration and is used to create, update, or delete Sales Order Information in Order Management entities.
Internal Name – OE_OUTBOUND_INT
The web services provided via this interface contains services to generate outbound integration information to publish sales order and line information from Order Management. The web service available with this interface is given below:
This web-service publishes the Sales Order and Line Information in Order Management. Whenever any external system invokes this webservice, it retrieves the acknowledgement information of order header and line and sends it as a response along with the change sequence so that the order information can be synced up in that system.
For the list of all Order Management interfaces, see Oracle Integration Repository, Order Management Suite > Order Management