Forum Stats

  • 3,759,068 Users
  • 2,251,495 Discussions
  • 7,870,480 Comments

Discussions

Error in editing fdm reports

2755601
2755601 Member Posts: 41
edited Nov 24, 2014 6:32PM in Financial Data Management

Hi Experts,

I am trying to edit fdm built in reports and getting the below error while editing the data value. Please help.

ADO error # -2147217900 Incorrect syntax near 'vData. Source: Microsoft OLE DB Provider for SQL server -2147217900  Incorrect syntax near 'tPovCategory'  Source: Microsoft OLE DB Provider for SQL server

sql query :

SELECT tPOVPartition.PartName AS PartitionKey,

tPOVCategory.CatKey,

tPOVCategory.CatName,

vData.PeriodKey,

vData.Account AS SrcAcctKey,

vData.Entity AS SrcCenterKey,

vData.ICP AS SrcICP,

vData.UD1 AS SrcUD1,

vData.UD2 AS SrcUD2,

vData.UD3 AS SrcUD3,

vData.UD4 AS SrcUD4,

vData.UD5 AS SrcUD5

vData.Desc1 AS SrcAcctDesc,

vData.Amount AS SrcAmount,

vData.AccountX AS SrcAcctKeyX,

vData.EntityX AS SrcCenterKeyX,

vData.ICPX AS SrcICPX,

vData.UD1X AS SrcUD1X,

vData.UD2X AS SrcUD2X,

vData.UD3X AS SrcUD3X,

vData.UD4X AS SrcUD4X,

vData.UD5X AS SrcUD5X,

tPOVPartition.PartCurrencyKey

FROM (vData

INNER JOIN tPOVCategory ON vData.CatKey = tPOVCategory.CatKey)

INNER JOIN tPOVPartition ON vData.PartitionKey = tPOVPartition.PartitionKey

WHERE (((tPOVCategory.CatKey)=~CatKey~)

AND (TO_CHAR(vData.PeriodKey, '|sqldateformat|')='~Period~')

AND ((vData.PartitionKey)=|PartitionKey|)

AND ((vData.CalcAcctType)=0 OR (vData.CalcAcctType)=1 OR (vData.CalcAcctType)=9))

ORDER BY vData.Account

Appreciate your help

Tagged:

Answers

This discussion has been closed.