Category Archives: API’s/Interfaces

Importing Sales Orders or Returns


     Order Import is an open interface owned by Oracle Order Management. Order Import consists of interface tables and a set of APIs. You can import new, change and completed sales orders or returns from legacy applications, EDI Transactions processed through the Gateway, or internal orders created from Oracle Purchasing’s internal requisitions, or returns. In addition, Order Import provides forms that allow you to query orders from the interface tables, make corrections or changes to the date, and re-initiate the import process. Messages are provided to give you the details why the order did not import.
Continue reading

Related posts:

Delete an Order or an Order Line

Delete an Order Using OE_ORDER_PUB:

DELETE Operation

In order to delete the entity record, its necessary to pass the operation like OE_GLOBALS.G_OPR_DELETE. The only attribute which needs to be passed is either the header id or the line id depending on the whether deletion is done for the order or the line. Deletes are cascaded down to the child entities. For example to delete a header record all the child entities i.e. lines, header sales credits, header adjustments are deleted.
Deleting the lines results in the deletion of line adjustments, line sales credits and line lot serial numbers as well.
Deletes would also result in the deletion of any holds and attachments associated with the deleted entity and its child entities. The workflow status information for this entity is also purged.

Delete Order:
–This is to delete an order
l_header_rec.header_id := &Order Header ID;
— Indicate to process order that the order is to be deleted
l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Delete Line:
— This is to delete an order line
l_line_tbl_index := 1;
–This is to delete an existing order line.
l_line_tbl(l_line_tbl_index) := OE_ORDER_PUB.G_MISS_LINE_REC;
l_line_tbl(l_line_tbl_index).header_id :=&Order Header ID;
l_line_tbl(l_line_tbl_index).line_id := &Order Line ID;
l_line_tbl(l_line_tbl_index).operation := OE_GLOBALS.G_OPR_DELETE;

Script to delete an existing sales order:

 Script to Delete an existing Sales Order Line:


Related posts:

Cancel Order or Order Line

 Cancel an existing Order using OE_ORDER_PUB:


Sample Script to Cancel Order:

  Cancel an existing Order Line using OE_ORDER_PUB:

Tables Effected: OE_ORDER_LINES

Sample Script to Cancel the Order Lines:


Related posts:

Creating Referenced and NON Referenced RMA’s

To create an RMA order that references an existing order:


General Tips for importing Referenced RMAs:

  • A non Referenced RMA can be created using existing OE_ORDER_PUB.PROCESS_ORDER by changing the Order Type.
  • Set the value of order_source_id in all tables to another order_source_id if required.
  • Set the value of orig_sys_document_ref in all tables to a unique value for each order.

Sample Script below to insert the header and lines by populating the order import interface:

 Now run the Order Import Concurrent program:

– Navigate to Orders, Returns -> Import Orders -> Order Import Request
– Select your Order Source from the LOV in the parameters form.
– Submit the concurrent request.

Related posts:

Split a Line to an Existing Sales Order

Split an Existing Line Using OE_ORDER_PUB

Tables Effected: OE_ORDER_LINES_ALL, (If Sales Order is Booked then MTL_DEMAND, MTL_RESERVATIONS)

Sample Code for splitting an existing line:


1 St Line Id: 388459
2 Nd Line Id: 388479
Process Order Success

Script to verify the Data:


Related posts: