Unable to Change the Item_Supp_Pack_Size While the Async Process is Processing for a NEW_ITEM_LOC (Doc ID 2134210.1)

Last updated on MAY 09, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to change the item_supp_pack_size while the async process is processing a NEW_ITEM_LOC, the following error occurs:

Error Codes
---------------------------------------------------
ORA-00054 Resource Busy and acquire with NOWAIT for function ITEM_LOC_SQL.INSERT_ITEM_COST_LOC

Steps to Reproduce
-----------------------
1. Create a NEW_ITEM_LOC with a Location List, the list must have minimal 50 Locations.
2. Edit an item and try to change the supp_pack_size (Screen Itemsuppctry).



Cause

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