HPCM: Trace Allocations Fails with Error:"Unexpected error in business logic" (Doc ID 1474876.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Profitability and Cost Management - Version 11.1.2.1.000 to 11.1.2.3.501 [Release 11.1]
Information in this document applies to any platform.
Add ***Checked for relevance on 03-jun-2014***

Symptoms

Trace Allocations Fails and below error message is reported in HPCM.log:

"[2012-06-28T20:07:04.444+10:00] [Profitability0] [ERROR] [EPMPCM-04000] [oracle.EPMPCM.web] [tid: 16] [userId: ] [ecid: 0000JWmZiJQEcLY5Tr0Fyc1Fu^Xo0000xe,0] [SRC_CLASS: com.hyperion.profitability.common.logging.Logger] [APP: PROFITABILITY#11.1.2.0] [SRC_METHOD: error] Unexpected error in business logic.[[
Unexpected error in business logic.
........
Caused by: javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult()
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNonUniqueResultException(EJBQueryImpl.java:1250)
...."

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