My Oracle Support Banner

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

Last updated on AUGUST 16, 2022

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

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.