Unexpected Error, JBO-26041 & ORA-00001 Errors Submitting Mapping Rule for Approval (Doc ID 578699.1)

Last updated on NOVEMBER 28, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10.2
This problem can occur on any platform.
FEMAPPR - FEM Approvals

Symptoms

In Profitability Manager 11i, when you submit a Mapping Rule for approval, the following unexpected error occurs:

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

Note: You must have the profile option FND: Diagnostics set to Yes for your user to get the exception details.

When you click on exception details, the following errors exist:

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO FEM_WF_REQ_OBJECT_DEFS(OBJECT_DEFINITION_ID,WF_REQUEST_ID,PREV_APPROVAL_STATUS_CODE,OBJECT_TYPE_CODE,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)".

and

java.sql.SQLException: ORA-00001: unique constraint (FEM.FEM_WF_REQ_OBJECT_DEFS_PK) violated

Before submitting this rule for approval, you had manually set the APPROVAL_STATUS_CODE column in FEM_OBJECT_DEFINITION_B from "SUBMIT_APPROVAL" to "NEW" because the approval process was not working and you needed to access the Mapping Rule.

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