Intermittent Errors When Parallel Pick Confirm REST API Service is Submitted by Multiple Users "inv_pick_wave_pick_confirm_pub and method pick_confirm with error." (Doc ID 2731993.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

Pick confirm REST API call by third party WMS system occasionally throws the following error
when multiple threads of pick confirm (multiple pick confirm lines) are processed at same time.
The REST API call once again for re-processing is successful.

ERROR
-----------------------
The receiving transaction cannot be processed because an error occurred for module
inv_pick_wave_pick_confirm_pub and method pick_confirm with error.
ORA-0000: normal, successful completion


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call Pick Confirm REST API from third party WMS System.
{
  "pickLines": [
  {
  "PickSlip": 405068,
  "PickSlipLine": 98,
  "Locator": null,
  "PickedQuantity": "1",
  "SubinventoryCode": "DRY-WMS",
  "lotItemLots": [
  {
  "Lot": "WMS_LOT",
  "Quantity": "1"
  }
  ]
  },
......
  {
  "PickSlip": 405068,
  "PickSlipLine": 1,
  "Locator": null,
  "PickedQuantity": "1",
  "SubinventoryCode": "DRY-WMS",
  "lotItemLots": [
  {
  "Lot": "WMS_LOT",
  "Quantity": "1"
  }
  ]
  }
  ]
}
2. Response from above REST api call results in the following.
{
  "TransactionHeaderId": 3355595,
  "ReturnStatus": "Error",
  "ErrorCode": null,
  "ErrorExplanation": "The receiving transaction cannot be processed because an error occurred for module inv_pick_wave_pick_confirm_pub and method pick_confirm with error .ORA-0000: normal, successful completion",
  "PickSlip": 405068,
  "PickSlipLine": 95
}
3. Retry with be below failed payload and it successful.
{
  "pickLines": [
  {
  "PickSlip": 405068,
  "PickSlipLine": 95,
  "Locator": null,
  "PickedQuantity": "1",
  "SubinventoryCode": "DRY-WMS",
  "lotItemLots": [
  {
  "Lot": "WMS_LOT",
  "Quantity": "1"
  }
  ]
  }
  ]
}

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users have intermittent failures to perform pick
confirm through third party WMS and require to reprocess them.

Cause

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