SITMAIN.PC Batch Fails with ORA-01405 Error when Ranging an Item List to a Store (Doc ID 2098950.1)

Last updated on MAY 01, 2017

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.


Steps to Recreate
The issue can be reproduced at will with the following steps:

  1. Login to RMS
  2. Create an item List
  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