Author Archives: All Oracle Apps

Creating Referenced and NON Referenced RMA’s

To create an RMA order that references an existing order:

Tables Effected: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL.

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:

 Result:

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

Script to verify the Data:

 

Related posts:

Unreserve a line from Sales Order

Unreserve a line from Sales Order using Oe_order_pub:

Tables Effected: MTL_DEMAND, MTL_RESERVATIONS (Data will be removed from this tables).

Sample Script to un-reserve the Sales Order line:

 Result:

Line Id: 388459
Process Order Success

Script to verify the output:

 

Related posts:

Reserve an Item in Sales Order

Reserve an Item in Sales Order from Back end(Soft reservation) :

Tables Effected : MTL_RESERVATIONS, MTL_DEMAND.

Sample API to Reserve Sales Order Quantity from OE_ORDER_PUB:

 Result:

Line Id: 388459
Process Order Success

Script to Check the result:

 

Related posts:

Updating Existing Order Line

Update an Existing Sales Order line Using OE_ORDER_PUB API:

Tables Effected: OE_ORDER_LINES_ALL

Sample Script to update Sales Order Line using OE_ORDER_PUB.PROCESS_ORDER API:

 Result:

Line Id: 388459
Line Quantity Update Sucessful

Script to Verify the API:

 

Related posts: