Skip to Content
0
Former Member
Nov 07, 2012 at 02:42 AM

Many to One Mapping returns Duplicate Record error when Importing Data

43 Views

Dear Experts,

I've been using conversion files for quite a while but this is the first time I encounter this error/warning. I have a mapping in the conversion file wherein I have 5 external Account IDs mapped to a single Account ID in BPC. What happens is that when I try to Import the data, it returns a warning saying Duplicate Record. What I expect is BPC will do the aggregation of those 5 Accounts to the single Account it is mapped to during the Import.

Data Set:

ENTITY ACCOUNT TIME SIGNEDDATA 4110 9302 2012.JUN 4.41 4110 9801 2012.JUN (100.88) 4110 9802 2012.JUN (40.80) 4110 9901 2012.JUN 1,355,323.27 4110 2211 2012.JUN 1,314,654.35

Account Conversion File:

EXTERNAL INTERNAL 9302 140101 9801 140101 9802 140101 9901 140101 2211 140101

Import Status Returns that these are Duplicate Records:

ENTITY ACCOUNT TIME SIGNEDDATA 4110 140101 2012.JUN 4.41 4110 140101 2012.JUN (100.88) 4110 140101 2012.JUN (40.80) 4110 140101 2012.JUN 1,355,323.27 4110 140101 2012.JUN 1,314,654.35

Have a missed any config to make these aggregate? Have done this a lot of times in the MS version but I do not encounter this error/warning. Our BPC version is SAP BPC 7.5 NW SP11.

Thanks in Advance,

Marvin