My Oracle Support Banner

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 13, 2019

Applies to:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

NOTE:
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

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
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.