Unexpected Error & JBO-26041 / ORA-00001 Adding Node to Hierarchy Component (Doc ID 1071766.1)

Last updated on JUNE 07, 2012

Applies to:

Oracle Profitability Manager - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 07-June-2012.

Symptoms

In Profitability Manager 11i, you cannot add additional nodes to a large hierarchy dimension component in a Mapping Rule.  After selecting the nodes to add and clicking Apply, the following error appears:

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

If you have "FND: Diagnostics" enabled, when you click on the exception details link, you see the following error:

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO FEM_COND_DIM_CMP_DTL(COND_DIM_CMP_OBJ_DEF_ID,CRITERIA_SEQUENCE,HIERARCHY_OBJ_ID,NODE,RELATION_CODE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,
LAST_UPDATED_BY,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)".
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2680)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
at _oa__html._OA._jspService(_OA.java:84)>
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)>
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: ORA-00001: unique constraint (FEM.FEM_COND_DIM_CMP_DTL_PK) violated
.
.
.


The error prevents you from adding additional values to the hierarchy dimension component.

Steps to reproduce:

  1. Go to the Profitability Manager responsibility
  2. Go to Business Rule > Mapping
  3. Open a Mapping Rule that has a hierarchy dimension component
  4. Click on Update for the section with the dimension component
  5. Click on Update for the condition
  6. Click on the Dimension Components button
  7. Click on Update Definition for the hierarchy component
  8. Add a node to the hierarchy component
  9. Click Apply

The error occurs.

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