FDM Import failure ORA-00942: table or view does not exist
edited Jan 16, 2014 5:07AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 8 commentsAnswered
Hi, After creating a new location and setting up mapping tables for it, a subsequent attempt at a multi-load file import results in error - "ORA-00942: table or view does not exist
SELECT CatKey AS DCount From tDataSeg0 Where (((PartitionKey) = 0) AND ((CatKey) = 18) AND (TO_CHAR(PeriodKey,N'YYYYMMDD') Between N'20140131' And N'20140131') AND ((CalcAcctType) Between -1000 and 1000) And (ROWNUM <= 1))"
SELECT CatKey AS DCount From tDataSeg0 Where (((PartitionKey) = 0) AND ((CatKey) = 18) AND (TO_CHAR(PeriodKey,N'YYYYMMDD') Between N'20140131' And N'20140131') AND ((CalcAcctType) Between -1000 and 1000) And (ROWNUM <= 1))"
Sure enough tDataSeg0 does not exist. We have the default 50 data segments 1-50
Any thoughts on what causes this?
0