PurgeTemporaryUINDetailJob Fails with Error: 'Error querying stored procedure'

(Doc ID 2111452.1)

Last updated on FEBRUARY 09, 2018

Applies to:

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


The article described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available. 

The PurgeTemporaryUINDetailJob batch fails with the following error:

Steps to Recreate:

  1. Create an Inventory Adjustment for an item that requires a serial number type UIN.
  2. Navigate: Main Menu > Inventory Mgmt > Inventory Adjustment. The Inventory Adjustment List window opens.
  3. Click Create. The Inventory Adjustment Detail window opens with a blank line displayed.
  4. Select Reason = ‘Stock In’.
  5. Click Add Item button to include specific items; enter the item ‘XXXXX’.
  6. Double-click the UIN Qty field. The UIN popup opens.  Enter ‘1234567’ in the Serial Number column.
  7. Click ‘Apply’ button on the UIN pop-up.
  8. Click ‘Save’ button to complete the Adjustment creation.
  9. Observe the data in ITEM_UIN - the system generates the STATUS = 99.
  10. Run "PurgeTemporaryUINDetail.sh" batch.  Note that the batch aborts with error: Message: Error querying stored procedure.



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms