My Oracle Support Banner

Bracket Cost Change Induction Does Not Work (Doc ID 2576199.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Symptoms

In RMS 16.0.2, Bracket cost change induction does not work.


Steps to reproduce:
------------------------

  1. Download blank template for cost change. Note that the downloaded template does not include any bracket cost information.
  2. But the bracket cost information is available in S9T_TMPL_COLS_DEF table, but the same is not getting downloaded to the template.
  3. Create an item having Bracket cost information.
  4. Create a cost change via the excel upload. Include the bracket cost information in the excel file. Make sure the bracket costing fields are set to 'Y' in S9T_TMPL_COLS_DEF table.
  5. Upload the cost change template to the staging area.
  6. Upload the data from the staging area to the main tables.
  7. Note that the upload fails with "Record already exists" error.
  8. Though the upload has failed, cost change has been created. Also the cost is repeated for all the brackets.

 

Cause

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
Symptoms
Cause
Solution
References


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