SITMAIN.PC Batch Fails with ORA-01405 Error when Ranging an Item List to a Store
Last updated on JANUARY 03, 2018
Applies to:Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.
When attempting to run SITMAIN.PC (Scheduled Item Maintenance Main) batch to range an item list to a store, the following error occurs.
Error: sitmain_1~ ... ~update_insert~~- ... ~ORA-01405: fetched column value is NULL~STORED FUNCTION CALL FAILED: function = NEW_ITEM_LOC, item =<item-number>, loc = <location>, status = A
Steps to Recreate:
- Login to RMS.
- Create an item List (or, skulist).
- Pick a location which does not have items ranged from the skulist.
- Perform a mass item maintenance and assign the location to the skulist.
- Run the SITMAIN.PC batch and it throws an error.
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