My Oracle Support Banner

Hyperion Financial Management (HFM) Journal Templates not Displaying in Manage Journal Templates if the Number Templates to be Displayed is More Than 200 (Doc ID 2372190.1)

Last updated on MAY 31, 2018

Applies to:

Hyperion Financial Management - Version 11.1.2.4.206 to 11.1.2.4.206 [Release 11.1]
Information in this document applies to any platform.

Symptoms

After applying HFM Patch 11.1.2.4.206, Oracle <Patch 26760297>, Managed Journal Templates will return a blank screen if more than 200 Journal Template match the search criteria.

Following error messages are logged in Application's ODL file

HFM ODL log:

 [host:<HOSTNAME>] [nwaddr:<NETWORK ADDRESS>] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.206.5284] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 42000; NATIVE ERROR = 933; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00933: SQL command not properly ended]]

  [XFM] [ERROR:1] [EPMHFM-00000] [XFM] [ecid:] [File: XfmODBC.cpp] [Line: 1884] [userId: ] [Msg arguments: ] [appName:<APPNAME>] [pid: 7012] [tid: 6348] [host:<HOSTNAME>] [nwaddr: <NETWORK ADDRESS>] [errorCode: 0] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.206.5284] [[SELECT DISTINCT T.JOURNAL_TEMPLATE_ID, T.LABEL, T.ATTRIBUTE, T.JOURNAL_GROUP, T.DESCRIPTION, T.DESCRIPTION, T.TEMPLATE_TYPE, T.VALUE_ID, T.SECURITYCLASS_ID, T.SINGLE_ENTITY_ID, T.LAST_MODIFIED_DATE , T.LAST_MODIFIED_BY FROM XXXXXXX_JLTMP T T.JOURNAL_TEMPLATE_ID IN (SELECT DIMID FROM TEMP_DIMID_TABLE WHERE DIMIDX = 0) ORDER BY T.LABEL]]

Changes

 <Patch 26760297> Patch Set Update: 11.1.2.4.206 for Oracle Hyperion Financial Management applied

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.