Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error With Import Data CSV File in FDMEE

Moatasem SheblJan 31 2016 — edited Feb 1 2016

Data Input;JOD;No Detail;No Product;Actual;ERP;Sep;2012;-40476487.79

[BLANK] 01;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Sep;2013;-9670984.005

[BLANK] 01;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Sep;2014;-43065295.14

[BLANK] 01;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Sep;2015;-37741827.48

[BLANK] 08;71111;411101;26001;Data Input;JOD;No Detail;No Product;Actual;ERP;Feb;2011;-2186.535

[BLANK] 08;71111;411101;26001;Data Input;JOD;No Detail;No Product;Actual;ERP;Jan;2011;2186.535

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Apr;2010;-1107458.244

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Dec;2010;-969379.839

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Dec;2010;5664971.523

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Dec;2011;539642.297

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Feb;2010;-161439.3

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Feb;2011;-265875

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Jan;2011;-273767.297

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Jul;2010;-487855.76

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Jun;2010;-1322401.382

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;Mar;2010;-1339217.998

[BLANK] 08;71111;411101;26101;Data Input;JOD;No Detail;No Product;Actual;ERP;May;2010;-277219

Rows Loaded: 0

Rows Rejected: 438

2016-01-31 07:57:46,479 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

2016-01-31 07:57:46,479 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:

2016-01-31 07:57:46,480 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 20120140831.csv

2016-01-31 07:57:46,482 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: Data load7.csv

2016-01-31 07:57:46,482 INFO [AIF]: EPMFDM-140274:Message - File not deleted: /u03/inbox/Data load7.csv

2016-01-31 07:57:46,493 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End

2016-01-31 07:57:46,493 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 76

2016-01-31 07:57:46,597 INFO [AIF]:

Import Data from Source for Period 'Aug-2014'

2016-01-31 07:57:46,604 INFO [AIF]: Generic Data Rows Imported from Source: 0

2016-01-31 07:57:46,605 INFO [AIF]: Total Data Rows Imported from Source: 0

2016-01-31 07:57:47,927 INFO [AIF]:

Map Data for Period 'Aug-2014'

2016-01-31 07:57:47,931 WARN [AIF]: Warning: No records exist for Period 'Aug-2014'

2016-01-31 07:57:47,941 INFO [AIF]:

Stage Data for Period 'Aug-2014'

2016-01-31 07:57:47,942 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 0

2016-01-31 07:57:47,944 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 0

2016-01-31 07:57:47,945 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 0

2016-01-31 07:57:47,946 INFO [AIF]: Number of Rows deleted from TDATASEG: 0

2016-01-31 07:57:47,948 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

2016-01-31 07:57:47,949 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

2016-01-31 07:57:47,951 INFO [AIF]: Number of Rows inserted into TDATASEG: 0

2016-01-31 07:57:47,952 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 0

2016-01-31 07:57:47,982 INFO [AIF]: -------END IMPORT STEP-------

2016-01-31 07:57:48,007 INFO [AIF]: -------START VALIDATE STEP-------

2016-01-31 07:57:48,037 WARN [AIF]: Warning: The Import step has not been completed for period Aug-2014

2016-01-31 07:57:48,039 WARN [AIF]: Warning: The Import step has not been completed for period Aug-2014

2016-01-31 07:57:48,064 INFO [AIF]: -------END VALIDATE STEP-------

2016-01-31 07:57:48,261 INFO [AIF]: FDMEE Process End, Process ID: 201

The period mapping i create is right

pastedImage_1.png

This post has been answered by AlexLiu on Jan 31 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 29 2016
Added on Jan 31 2016
2 comments
1,553 views