Exalytics - Searching for Saved Template in FCM 11.1.2.4 Fails with Error: "ORA-01460: Unimplemented Or Unreasonable Conversion Requested" (Doc ID 2152922.1)

Last updated on JUNE 23, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.4.101 and later
Oracle Exalytics Software - Version 1.0.0.5.0 and later
Information in this document applies to any platform.

Symptoms

Encountering error when trying to use a saved Financial Close Management (FCM) 11.1.2.4.101 Template.

Steps that lead to the error are:

1.  Login and open Financial Close Management (FCM)
2.  Select "new template" icon
3.  Enter name
4.  Click "save and close" - (appears on top)
5.  Select "Open Template" icon - message: "There are no templates"

If selecting search and looking for the template in the Open template window by selecting the highlighted icon, the following error message is displayed:

Error

Exception SQLException has occurred after the invocation of the method: fcc.model.view.common.SQLServerViewObjectImpl.executeQueryForCollection() [line:92]
ORA-01460: unimplemented or unreasonable conversion requested

Analysis of the provisioning report showed that the user had been provisioned with 700+ FDMEE location groups. If provisioning was modified to reduce this to only 24 FDMEE location groups, no error occurred.

This error is occurring on an Exalytics X5-4, Linux 6 server, but can happen on any Linux 6 server environment.

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