Hyperion Financial Management 11.1.1.3.50 (SP50) System Generated Journal Reports Do Not Run to Completion (Doc ID 1282934.1)

Last updated on AUGUST 08, 2016

Applies to:

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

Symptoms

Financial Management 11.1.1.3.50 (SP50) System Generated Journal Reports Do Not Run If Account Label & Description Fields Are Included.

Create a system generated journal report where the account dimension is added twice, once for the description, the other for the label. (Do not want to use the "both" option as need to have the label and
description in separate columns).

Since applying SP50, reports designed this way do not return any result and an "unspecified error" is recorded in the HFM log:


Error*11*SVC-HFMADMIN*10/19/2010 09:51:19*CHsvDSJournals.cpp*Line 2847*<?xml
version="1.0"?>

<EStr><Ref>{F72E2EF5-C752-47FD-9729-E0A8A5E3CB9C}</Ref><AppName>GGHFM</AppName
><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>1</Type><DTime
>10/19/2010 9:51:19
AM</DTime><Svr>CHCADAS074</Svr><File>CHsvDSJournals.cpp</File><Line>2847</Line
><Ver>11.1.1.3.50.2839</Ver><DStr>SELECT J.JOURNAL_ID, J.LABEL,
J.DESCRIPTION, J.JOURNAL_GROUP, L.ENTITY_ID, L.ICP_ID, L.CUSTOM2_ID,
L.ACCOUNT_ID, L.ACCOUNT_ID, L.CUSTOM1_ID, L.DESCRIPTION, L.CUSTOM4_ID,
J.SECURITYCLASS_ID,L.DEBIT_CREDIT_UNIT, L.AMOUNT, J.SECURITYCLASS_ID,
L.ENTITY_ID, L.PARENT_ID, L.ACCOUNT_ID, L.ICP_ID, L.CUSTOM1_ID,
L.CUSTOM2_ID, L.CUSTOM3_ID, L.CUSTOM4_ID FROM GGHFM_JL_1_2010 J,
GGHFM_JLENT_1_2010 L , GGHFM_ENTITY_ITEM E , GGHFM_ACCOUNT_ITEM A ,
GGHFM_ACCOUNT_ITEM A WHERE (J.JOURNAL_ID = L.JOURNAL_ID) AND J.PERIOD_ID =
83886088 AND J.VALUE_ID = 13 AND J.LABEL LIKE N'GG%' AND J.STATUS IN (0, 1,
2, 3, 4, 5) AND J.TYPE IN (0, 1, 4, 8) AND J.ATTRIBUTE IN (0, 1, 2, 4) AND
L.ENTITY_ID = E.ItemID AND L.ACCOUNT_ID = A.ItemID AND L.ACCOUNT_ID =
A.ItemID ORDER BY J.LABEL, E.Label , A.Label , A.Label
</DStr><PSec><Param>ORA-918: column ambiguously
defined</Param></PSec></ESec></EStr>


Changes

Applied SP 50 to 11.1.1.3.00

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