Error in Account Chase Report "ORA-00907: missing right parenthesis" (Doc ID 1071624.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Error in Account Chase - Free Form Wildcard Audit Report

Comments
--------
   When running the Account Chase - Freeform (TargAcct, Per, Cat) report an error box appears...

"Data access error"

The log shows the following information:
** Begin FDM Runtime Error Log Entry [2010-03-03-08:35:10] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... ORA-00907: missing right parenthesis
SELECT
tPOVPartition.PartName AS PartitionKey,  
1 AS TargAcctIndex,
N'ALL' AS TargAcctGroup,
N'NA' AS TargAcctDesc,
N'NA' AS TargAcctType,  
vData.AccountX AS SrcAcctKeyX,
vData.Account AS SrcAcctKey,
vData.Entity AS SrcCenterKey,
vData.Desc1 AS SrcAcctDesc,
vData.ChangeSign,
vData.Amount AS SrcAmount,
tPOVCategory.CatName,
vData.PeriodKey,
tPOVCategory.CatKey,
tPOVPartition.PartCurrencyKey

FROM
tPOVPartition
INNER JOIN tPOVCategory
INNER JOIN vData
ON tPOVCategory.CatKey = vData.CatKey
ON tPOVPartition.PartitionKey = vData.PartitionKey
INNER JOIN tStructPartitionHierarchy
ON tPOVPartition.PartitionKey = tStructPartitionHierarchy.LocationID

WHERE
((TO_CHAR(vData.PeriodKey, N'YYYYMMDD')=N'20100131')
AND ((tPOVCategory.CatKey)=12)
AND ((vData.PartitionKey) NOT IN(0))
AND ((vData.CalcAcctType)>0)
AND ((vData.AccountX)=N'101100000')

ORDER BY
tStructPartitionHierarchy.HIndex,
vData.AccountX,
vData.Account,
vData.Entity
Procedure........................................ clsDataAccess.farsSnap
Component........................................ upsWDataWindowDM
Version.......................................... 1111
Thread........................................... 984


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms