HFM import application feature is not listing the available applications (Doc ID 2659614.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

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

Symptoms

Hyperion Financial Management import application feature is not listing the available applications

Error in oracle-epm-fm.log

================

[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 23] [userId: <anonymous>] [ecid: 005cmPwVleI3V895VfO5yc0004A50000Di,0:1:4] [APP: FMADFWEB#11.1.2.0] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] {? = call HFMUTIL_PKG.ListAppNames(?)}

[HFMWeb0] [ERROR] [EPMHFM-66152] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 23] [userId: <anonymous>] [ecid: 005cmPwVleI3V895VfO5yc0004A50000Di,0:1:4] [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-06550: line 1, column 13:

PLS-00201: identifier 'HFMUTIL_PKG.LISTAPPNAMES' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)