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!

HFM Data loads Issue with invalid cells

samacntOct 30 2014 — edited Oct 30 2014

Hello all,

We have an issue with HFM Data load. We get an error for invalid Cell for Period dimensions. We tried opening the mentioned members but we got same errors..

Below is the error log:

Load data started: 10/30/2014 09:36:15.

Line: 2, Error: Invalid cell for Period Oct.

ACTUAL; 2014; Oct; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 11979

>>>>>>

Line: 3, Error: Invalid cell for Period Nov.

ACTUAL; 2014; Nov; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 23544

>>>>>>

Line: 4, Error: Invalid cell for Period Dec.

ACTUAL; 2014; Dec; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 58709

>>>>>>

Line: 5, Error: Invalid cell for Period Jan.

ACTUAL; 2014; Jan; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 69968

>>>>>>

Line: 6, Error: Invalid cell for Period Feb.

ACTUAL; 2014; Feb; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 85648

>>>>>>

Line: 7, Error: Invalid cell for Period Mar.

ACTUAL; 2014; Mar; YTD; E_2100; USD; 89920000; [ICP None]; CORP; [None]; [None]; FARM21000; 104333

>>>>>>

Line: 8, Error: Invalid cell for Period Oct.

ACTUAL; 2014; Oct; YTD; E_2100; USD; 28050000; E_6000_20; [None]; [None]; [None]; FARM21000; -11979

>>>>>>

Line: 9, Error: Invalid cell for Period Nov.

ACTUAL; 2014; Nov; YTD; E_2100; USD; 28050000; E_6000_20; [None]; [None]; [None]; FARM21000; -11565

>>>>>>

Line: 10, Error: Invalid cell for Period Jan.

ACTUAL; 2014; Jan; YTD; E_2100; USD; 28050000; E_6000_20; [None]; [None]; [None]; FARM21000; -15040

>>>>>>

Line: 11, Error: Invalid cell for Period Feb.

ACTUAL; 2014; Feb; YTD; E_2100; USD; 28050000; E_6000_20; [None]; [None]; [None]; FARM21000; -15680

>>>>>>

Line: 12, Error: Invalid cell for Period Mar.

ACTUAL; 2014; Mar; YTD; E_2100; USD; 28050000; E_6000_20; [None]; [None]; [None]; FARM21000; -18685

>>>>>

Thanks

ARP

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2014

Added on Oct 30 2014

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

2 comments

1,429 views