Fcexec Batch Fails With Error: 'ORA-32638: Non Unique Addressing in MODEL Dimensions' (Doc ID 2072434.1)

Last updated on APRIL 21, 2017

Applies to:

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

Symptoms

In Oracle Retail Merchandising System (RMS), the FCEXEC batch is failing with the below error:


Steps to Reproduce:

  1. Create a Deal for a regular item.
  2. Create a reclassification for the same item.
  3. Run fcthreadexec, pre fcexec and fcexec.  Notice the error:  @0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tables@@2FUTURE_COST_ROLLFWD_SQL.HELP_ROLL_DEAL_2

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