My Oracle Support Banner

SITMAIN Aborts with 'ORA-01405: Fetched Column Value is NULL~STORED FUNCTION CALL FAILED' Error (Doc ID 2121444.1)

Last updated on APRIL 16, 2020

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.