HPCM Error:"ORA-02289: sequence does not exist" when Deploying HPCM Application from EPMA (Doc ID 1598416.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Profitability and Cost Management - Version 11.1.2.1.103 and later
Information in this document applies to any platform.

Symptoms

Unable to deploy the HPCM Application from EPMA. The following error message is generated in the HPCM.log:
"Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Error Code: 2289
Call: SELECT SEQ_GEN_SEQUENCE.NEXTVAL FROM DUAL
Query: ValueReadQuery(sql="SELECT SEQ_GEN_SEQUENCE.NEXTVAL FROM DUAL")"

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