cancel
Showing results for 
Search instead for 
Did you mean: 

Data Load Error - 'Ambiguous values found for non-root attributes'

Former Member
0 Kudos

Hi,

We are trying to load Product master data through HCI into IBP 4.0 FP1. Few records keep getting rejected with the following details:

REJECTION_CODE_NAME --> No unique master data found

REJECTION_DESCRIPTION --> Ambiguous values found for non-root attributes S2PRDGROUP

Has anyone encountered this error before?

We're not able to find anything obvious.

Thanks,

Chendur

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Yes, this is telling you that your attributes don't resolve to a unique root attribute.

Example:

ProdID,ProdAttr1,ProdAttr2

A,Group 1,Red

B,Group 1,Blue

C,Group 2,Green

D,Group 2,Green

If you mark ProdAttr1 as a root of a planning level and carry ProdAttr2 in that planning level, then all ProdAttr2 values must resolve to one distinct value.

The 'Group 1' records fail because they don't have common ProdAttr2 values. If transactional data were to load to Group 1 with this master data set, the system wouldn't know which ProdAttr2 value to assign. To fix this issue you have two options.

  • Correct the master data, so that all ProdAttr2 values only have one ProdAttr1 value.
  • Mark both ProdAttr1 and ProdAttr2 as roots of your desired planning level so that the combination of the two make the record unique.

The 'Group 2' records pass because they have one distinct ProdAttr2 value (Green).

Answers (0)