Unable To Transact Splitted Move Order Lines Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API (Doc ID 2499128.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

Unable To Transact Splitted Move Order Lines Using INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm API

STEPS
-----------------------
Example:Original move order data with 1 line:

  Primary quantity: 2
  Primary UOM code: kg
  Secondary quantity: 1.88679
  Secondary UOM code: l

 The allocate detail qty and allocate secondary qty were modified using the APIs in the following sequence:

  Split one from line 1:
  Primary Quantity: 1
  Secondary quantity: .9434

  Sequence of steps:
  1.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success (To allocate only Qty 1)
  2.- INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB (Success (MTL_MATERIAL_TRANSACTIONS_TEMP) )
  3.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success (MTL_TXN_REQUEST_LINES))
  4.- INV_TRX_UTIL_PUB.DELETE_LOT_SER_TRX (Success, (To choose another lot))
  5.- INV_TRX_UTIL_PUB.INSERT_LOT_TRX (Success Qty 1, Sec Qty: .9434, new first Lot 'SES181018')
  6.- INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM (Success, transaction was made)

  Split two from line 1:
  Primary quantity: 1
  Secondary quantity: .9434

  Sequence of steps:
  1.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success Qty: 1)
  2.- INV_REPLENISH_DETAIL_PUB.LINE_DETAILS_PUB (Success Qty: 1)
  3.- INV_MOVE_ORDER_PUB.PROCESS_MOVE_ORDER_LINE (Success Qty: 1)
  4.- INV_TRX_UTIL_PUB.DELETE_LOT_SER_TRX (Success)
  5.- INV_TRX_UTIL_PUB.INSERT_LOT_TRX (Success Qty 1, Sec Qty: .9434, new second Lot 'SES18101801')
  6.- INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM (API Return S. Success, but the transaction WAS NOT MADE and appears on transact move order form).

Now See the Delivered quantity and detailed quantity are the same on MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_TXN_REQUEST_LINES.


EXPECTED BEHAVIOR
-----------------------
Second move order line should get transacted successfully

Cause

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