Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

FDM Import fails with Integration script

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center