Exalytics - Searching for Saved Template in FCM 188.8.131.52 Fails with Error: "ORA-01460: Unimplemented Or Unreasonable Conversion Requested"
Last updated on JUNE 23, 2016
Applies to:Hyperion Financial Close Management - Version 184.108.40.206.101 and later
Oracle Exalytics Software - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Encountering error when trying to use a saved Financial Close Management (FCM) 18.104.22.168.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:
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.
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