FDM Import fails with Integration script
edited Apr 8, 2013 10:25AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 1 commentAnswered
Hi,
While running the Import integration script below error message is displayed. Please help ASAP.
** Begin FDM Runtime Error Log Entry [2013-04-06-14:52:00] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... ORA-00928: missing SELECT keyword
Insert into (PartitionKey,Catkey,PeriodKey,DataView,CalcAcctType,Entity,Account,ICP,UD1,UD2,UD3,UD4,Amount)
Select Distinct
N'759'
,N'12'
,to_Date(N'1/31/2013',N'YYYYMMDD')
,N'YTD'
,N'9' ,Segment1 || Segment2
,Segment3
,Segment5 || Segment2
,Segment4
,N'[NONE]'
,N'US_DOLLAR'
,N'[NONE]'
,(begin_balance_dr - begin_balance_cr) (period_net_dr - period_net_cr)
from GL_BALANCES@ORA_GL_INTERFACE A
,GL_CODE_COMBINATIONS@ORA_GL_INTERFACE B
0