Hyperion Financial Management Source Application List is Blank with New Feature in 11.1.2.4.200 Import Application (Doc ID 2127725.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

Source Application drop-down list is blank in the Import Application feature.

The following error is generated and captured in the oracle-epm-fm.log (i.e. DiskDrive\Oracle\Middleware\user_projects\domains\EPMSystem\servers\HFMWeb(n)\logs\hfm):

[DateTime] [HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [APP: FMADFWEB#11.1.2.0] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] {? = call HFMUTIL_PKG.ListAppNames(?)}
[DateTime] [HFMWeb0] [ERROR] [EPMHFM-66152] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [APP: FMADFWEB#11.1.2.0] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] An error occurred in executing the query.[[
java.sql.SQLException: ORA-04063: package body "HYPHFM.HFMUTIL_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "HYPHFM.HFMUTIL_PKG"
ORA-06512: at line 1

Changes

 After updating to version 11.1.2.4.200

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