My Oracle Support Banner

Incorrect Lot List of RMA When Created With OE_order_pub.process_order API (Doc ID 3063419.1)

Last updated on DECEMBER 13, 2024

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms


Using OE_order_pub.process_order API to create an RMA

The user is having an outbound sales order line with two quantity and lot numbers for example as follows 122 & 123. When trying to create a partial RMA, meaning 1 quantity and deliberately returning a specific lot say 122, but the system is giving 123 in addition to the expected 122.

So in summary the user would like to create a partial RMA (for lot 122 only) but system also defaults lots 123 which was also present on original outbound Sales Order.


Expected Behavior

The RMA Should return only lot 122 and not both lot 122 and 123


Steps



1. prepare OE_order_pvt.process_order API or OE_order_pub.process_order API scripts by providing data for three collections variables:
p_x_header_rec
p_x_header_rec
p_x_lot_serial_tbl

2. Run the script

3. Notice the user should only see lots and quantities provided in p_x_lot_serial_tbl variable  In this example lot 122 and lot 123

The creation of the partial RMA fails (it should return lot 122 only) but the system also returns lots 123 which was also present on original outbound Sales Order .

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.