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

(Doc ID 2121444.1)

Last updated on MARCH 29, 2016

Applies to:

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

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.


The batch SITMAIN gives the following error on different threads:


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.

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