Rejected records during run package

[Former Member]

Dear Experts,

I am facing the Issue with transaction data....

I am uploading the transaction data from BW Infocube to BPC Model, while validating the transformation file it is successfully validating, but after running the package it is giving WARNING, I am uploading 528 records but out of 528 records,

Submit count: 454 Records

Reject count: 74 Records

I can not understand why it is rejecting 74 records and I am not getting the solution for this Issue, kindly any one could solve the Issue ASAP......

Thanks in advance

Praveen Gajula

[Former Member]

Hi Praveen,

You need to share your reject list. that can give you the better idea. where it went wrong.

Thanks

Varun

[Former Member]

Hi Varun, thanks for your  reply.

Kindly find the list of rejected records below

1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_006	WM_07	UOM_007	12235.67
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_014	WM_07	UOM_007	88608.19
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_012	WM_07	UOM_007	161169.7
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_059	WM_07	UOM_007	262013.6
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_004	WM_07	UOM_007	262013.5600000-
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_016	WM_07	UOM_007	7340043
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_019	WM_07	UOM_007	7340043
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_016	WM_07	UOM_007	3071949
1	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_II	WM_019	WM_07	UOM_007	3071949
2	Input	Actual	ABC (Entity)	LC	2013.08	NAS	WM_003	WM_07	UOM_007	1152
2	Input	Actual	ABC (Entity)	LC	2013.08	NAS	WM_062	WM_07	UOM_007	156917
2	Input	Actual	ABC (Entity)	LC	2013.08	NAS	WM_004	WM_07	UOM_007	156917
2	Input	Actual	ABC (Entity)	LC	2013.08	NAS	WM_005	WM_07	UOM_007	136.213
7	Input	Actual	ABC (Entity)	LC	2013.03	NAS	WM_006	WM_07	UOM_007	296720
7	Input	Actual	ABC (Entity)	LC	2013.03	NAS	WM_059	WM_07	UOM_007	296720
7	Input	Actual	ABC (Entity)	LC	2013.03	NAS	WM_004	WM_07	UOM_007	296720.0000000-
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_006	WM_07	UOM_007	12105
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_014	WM_07	UOM_007	96755.84
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_012	WM_07	UOM_007	207296.8
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_059	WM_07	UOM_007	316157.7
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_004	WM_07	UOM_007	316157.6600000-
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_016	WM_07	UOM_007	8000025
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_019	WM_07	UOM_007	8000025
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_016	WM_07	UOM_007	1993955
10	Input	Actual	ABC (Entity)	LC	2013.03	CH_PH_I	WM_019	WM_07	UOM_007	1993955
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_006	WM_07	UOM_007	21404
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_014	WM_07	UOM_007	62569.77
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_059	WM_07	UOM_007	83973.77
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_004	WM_07	UOM_007	83973.7700000-
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_016	WM_07	UOM_007	3358900
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_019	WM_07	UOM_007	3358900
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_016	WM_07	UOM_007	9138137
11	Input	Actual	ABC (Entity)	LC	2013.03	TMN	WM_019	WM_07	UOM_007	9138137
12	Input	Actual	ABC (Entity)	LC	2013.08	RAJ	WM_003	WM_07	UOM_007	2304
12	Input	Actual	ABC (Entity)	LC	2013.08	RAJ	WM_062	WM_07	UOM_007	266373
12	Input	Actual	ABC (Entity)	LC	2013.08	RAJ	WM_004	WM_07	UOM_007	266373
12	Input	Actual	ABC (Entity)	LC	2013.08	RAJ	WM_005	WM_07	UOM_007	115.613
13	Input	Actual	ABC (Entity)	LC	2013.03	CV_PH_II	WM_006	WM_07	UOM_007	29857.6
13	Input	Actual	ABC (Entity)	LC	2013.03	CV_PH_II	WM_059	WM_07	UOM_007	29857.6
13	Input	Actual	ABC (Entity)	LC	2013.03	CV_PH_II	WM_004	WM_07	UOM_007	29857.6000000-
16	Input	Actual	ABC (Entity)	LC	2013.04	CH_PH_I	WM_016	WM_07	UOM_007	211572
16	Input	Actual	ABC (Entity)	LC	2013.04	CH_PH_I	WM_019	WM_07	UOM_007	211572
16	Input	Actual	ABC (Entity)	LC	2013.04	CH_PH_I	WM_016	WM_07	UOM_007	7066.01
16	Input	Actual	ABC (Entity)	LC	2013.04	CH_PH_I	WM_019	WM_07	UOM_007	7066.01
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_003	WM_07	UOM_007	1728
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_062	WM_07	UOM_007	326319
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_006	WM_07	UOM_007	200
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_014	WM_07	UOM_007	400
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_012	WM_07	UOM_007	300
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_059	WM_07	UOM_007	900
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_004	WM_07	UOM_007	325419
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_016	WM_07	UOM_007	402000
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_019	WM_07	UOM_007	402000
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_005	WM_07	UOM_007	188.842
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_016	WM_07	UOM_007	110862.5
19	Input	Actual	ABC (Entity)	LC	2013.08	CH_PH_I	WM_019	WM_07	UOM_007	110862.5
20	Input	Actual	ABC (Entity)	LC	2013.08	CHL_II	WM_003	WM_07	UOM_007	1728
20	Input	Actual	ABC (Entity)	LC	2013.08	CHL_II	WM_062	WM_07	UOM_007	372045
20	Input	Actual	ABC (Entity)	LC	2013.08	CHL_II	WM_004	WM_07	UOM_007	372045
20	Input	Actual	ABC (Entity)	LC	2013.08	CHL_II	WM_005	WM_07	UOM_007	215.304
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_006	WM_07	UOM_007	500
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_014	WM_07	UOM_007	700
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_012	WM_07	UOM_007	600
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_059	WM_07	UOM_007	1800
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_004	WM_07	UOM_007	1800.0000000-
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_016	WM_07	UOM_007	50000
21	Input	Actual	ABC (Entity)	LC	2013.07	TMN	WM_019	WM_07	UOM_007	50000
22	Input	Actual	ABC (Entity)	LC	2013.03	RAJ_2	WM_006	WM_07	UOM_007	796.16
22	Input	Actual	ABC (Entity)	LC	2013.03	RAJ_2	WM_059	WM_07	UOM_007	796.16
22	Input	Actual	ABC (Entity)	LC	2013.03	RAJ_2	WM_004	WM_07	UOM_007	796.1600000-
23	Input	Actual	ABC (Entity)	LC	2013.06	CH_PH_II	WM_016	WM_07	UOM_007	1000000
23	Input	Actual	ABC (Entity)	LC	2013.06	CH_PH_II	WM_019	WM_07	UOM_007	1000000
23	Input	Actual	ABC (Entity)	LC	2013.06	CH_PH_II	WM_016	WM_07	UOM_007	280000
23	Input	Actual	ABC (Entity)	LC	2013.06	CH_PH_II	WM_019	WM_07	UOM_007	280000

Please find the transformation file as below

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

AUDITTRAIL=*NEWCOL(Input)

CATEGORY=*NEWCOL(Actual)

P_ENTITY=*NEWCOL(ABC)

RPTCURRENCY=*NEWCOL(LC)

TIME_SIL=0FISCPER

WD_EXT_MAT_GRP=0EXTMATLGRP

WM_ACCOUNT=*MVAL(ZTOTL_KWH|*NEWCOL(WM_003)||ZGEN_APWR|*NEWCOL(WM_062)||ZLNE_LOSS|*NEWCOL(WM_006)||ZTRSM_LOS|*NEWCOL(WM_014)||ZWHEL_LOS|*NEWCOL(WM_012)||ZTOT_LOS|*NEWCOL(WM_059)||ZGROS_GEN|*NEWCOL(WM_004)||ZEXPRT|*NEWCOL(WM_016)||ZREACT|*NEWCOL(WM_019)||ZPRO_LOS|*NEWCOL(WM_057)||ZMAC_AVAL|*NEWCOL(WM_052)||ZGRD_AVAL|*NEWCOL(WM_053)||ZPLNT_LF|*NEWCOL(WM_005)||ZLIN_LOS|*NEWCOL(WM_006)||ZTRM_LOS|*NEWCOL(WM_014)||ZWHEG_LOS|*NEWCOL(WM_012)||ZTOTL_LOS|*NEWCOL(WM_059)||ZCAP_WMMW|*NEWCOL(WM_001)||ZTOTL_CAP|*NEWCOL(WM_003)||ZNO_WM|*NEWCOL(WM_002)||ZEXPRT_RS|*NEWCOL(WM_016)||ZREACT_RS|*NEWCOL(WM_019))

WM_UD_2=*NEWCOL(WM_07)

WM_UOM_02=ZUNIT_1

*CONVERSION

TIME_SIL=TIME_WM.XLS

WD_EXT_MAT_GRP=EXTMATL_WM.XLS

WM_UOM_02=UOM_WM.XLS

[Former Member]

Hi Praveen, thanks for sharing details. But could you please share the reject list. Reject list the third option after you click on view status above the Reject Record option. The information you have shared with me is Reject Record. From this, I am not able to analyse the issue.

Thanks

Varun

[former_member212277]

Hi Praveen,

  Rejected records will be duplicate. SAP BPC not allows to upload duplicate records, Make file without duplication records then upload it.

Thanks

Sathish V