Skip to Main Content
Forums

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!

Validation error for multiperiod file

User_3JG8TFeb 1 2017 — edited Feb 1 2017

Hi everyone,

I am using MULTIPERIOD flat file(.csv) to import data. The FDMEE environment is 11.1.2.4.210

Anyone has seen some error like this before.

During validation there is an error that says:

2017-02-01 11:07:08,477 DEBUG [AIF]: Member:[Jan-2017, Feb-2017]

2017-02-01 11:07:08,477 DEBUG [AIF]: Column:[9, 10]

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT9:ImpFieldText=Column=9,10;:StartPos=9:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT10:ImpFieldText=Column=9,10;:StartPos=10:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=4:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=3:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=5:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=6:SourceClName=null

2017-02-01 11:07:11,290 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=7:SourceClName=null

2017-02-01 11:07:11,291 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=8:SourceClName=null

2017-02-01 11:07:11,291 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2017-02-01 11:07:11,291 INFO [AIF]: EPMFDM-140274:Message - File Name ImportFormatTemplate12.csv

although my source column is not null:

pastedImage_0.png

Data load mapping is quite simple , everything is LIKE mapping with * to *

Thanks.
This post has been answered by JohnGoodwin on Feb 1 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2017
Added on Feb 1 2017
#business-intelligence-applications, #financial-data-management, #performance-management-applications
8 comments
1,022 views