My Oracle Support Banner

PurgeTemporaryUINDetailJob Fails with Error: 'Error querying stored procedure' (Doc ID 2111452.1)

Last updated on AUGUST 16, 2022

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 "" batch.  Note that the batch aborts with error: Message: Error querying stored procedure.





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

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