My Oracle Support Banner

When An Item With Season Data Is Uploaded And It Has An Existing ITEM_SEASON_SEQ_NO, The Process Is Stuck In New Status (Doc ID 2404328.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


While uploading Item Season data for an item which already has a record with the same "Item Season Sequence Number", the process got stuck in "New" status.

It is expected that the process upload request to be rejected with proper error message.

Steps to reproduce:

  1. Log in to RMS
  2. Navigate to foundation data> Data Loading >Download Blank Template
  3. Select type as items and template type as Item season
  4. Click on Download
  5. Start updating the .ODS file.
  6. Select ACTION as Create
  7. Provide valid item id, season and phase.
  8. Enter ITEM_SEASON_SEQ_NO as a number, already existing in RMS for that Item. save the file.
  9. Navigate back to items > Upload items from file.
  10. Select template as Item Season and choose file from the local folder.
  11. Click on Upload.




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.