My Oracle Support Banner

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

Last updated on AUGUST 05, 2020

Applies to:

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

Symptoms

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.

 

Changes

 

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