My Oracle Support Banner

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 DECEMBER 04, 2020

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

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

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.