Data Access Error With Complex Logic Group Accounts At Import Step (Doc ID 1382649.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When trying to import a file into a location with assigned complex logic group import fails with message:

Getting error : Code............................................. -2147217900
Description...................................... Data access error. Account=AP12221510BL10

ERROR:
Code............................................. -2147217900
Description...................................... Incorrect syntax near the keyword 'AS'.
SELECT PARTITIONKEY AS xPartitionKey, CATKEY AS xCatKey, PERIODKEY AS xPeriodKey, ENTITY AS xEntity, DATAVIEW AS xDataView, AS xAccount, N'[ICP None]' + SUBSTRING(ICP, 1, 0) AS xICP, UD1 AS xUD1, N'BL10' + SUBSTRING(UD2, 1, 0) AS xUD2, UD3 AS xUD3, UD4 AS xUD4, UD5 AS xUD5, UD6 AS xUD6, UD7 AS xUD7, UD8 AS xUD8, UD9 AS xUD9, UD10 AS xUD10, UD11 AS xUD11, UD12 AS xUD12, UD13 AS xUD13, UD14 AS xUD14, UD15 AS xUD15, UD16 AS xUD16, UD17 AS xUD17, UD18 AS xUD18, UD19 AS xUD19, UD20 AS xUD20, Sum(Amount) AS xAmount from tWab907254416845244 WHERE (((ACCOUNT) In (N'22205000'))) AND (CalcAcctType = 9) GROUP BY PARTITIONKEY, CATKEY, PERIODKEY, ENTITY, DATAVIEW, , N'[ICP None]' + SUBSTRING(ICP, 1, 0), UD1, N'BL10' + SUBSTRING(UD2, 1, 0), UD3, UD4, UD5, UD6, UD7, UD8, UD9, UD10, UD11, UD12, UD13, UD14, UD15, UD16, UD17, UD18, UD19, UD20 HAVING (((PartitionKey)=880) AND ((PeriodKey) Between N'20121231' And N'20121231') AND ((CatKey)=18))
Procedure........................................ clsDataAccess.farsKeySet
Component........................................ upsWDataWindowDM
Version.......................................... 1111
Thread........................................... 1684

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