SITMAIN.PC Batch Fails with ORA-01405 Error when Ranging an Item List to a Store

(Doc ID 2098950.1)

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:

  1. Login to RMS.
  2. Create an item List (or, skulist).
  3. Pick a location which does not have items ranged from the skulist.
  4. Perform a mass item maintenance and assign the location to the skulist.
  5. 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