SITMAIN Aborts with 'ORA-01405: Fetched Column Value is NULL~STORED FUNCTION CALL FAILED' Error

(Doc ID 2121444.1)

Last updated on DECEMBER 26, 2017

Applies to:

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


The batch SITMAIN gives the following error on different threads:

sitmain_1~20160224011103~update_insert~~-1405~ORA-01405: fetched column value is NULL~STORED FUNCTION CALL FAILED: function = NEW_ITEM_LOC, item = 00116861, loc = 16010, status = A

Steps to Recreate:

  1. Log in to RMS.
  2. Create an item list.
  3. Pick two locations which do not have items ranged from the skulist and create a location list for the same.
  4. Perform a mass item maintenance and assign the location to the skulist.
  5. Run the Sitmain batch. Observe that it throws the above 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