Getting Application Error When Trying To Select The Compensation Plans (Doc ID 2009641.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Compensation - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Manage Compensation

When attempting to select the Manage Workforce Compensation Plans, the following error occurs.

ERROR
-----------------------
An application error occurred, Please check the incident log for more details

Error Stack
-------------Stack Trace
-----------
java.lang.Exception: An application error occurred. See the incident log for more
  information.
at oracle.apps.fnd.applcore.messages.ExceptionHandlerUtil.processExceptionWithResourceBundle(ExceptionHandlerUtil.java:119)
at oracle.apps.fnd.applcore.messages.ExceptionHandlerUtil.processException(ExceptionHandlerUtil.java:44)
at oracle.apps.fnd.applcore.messages.MessageFormatHandler.reportException(MessageFormatHandler.java:406)
at oracle.adf.model.binding.DCBindingContainer.reportException(DCBindingContainer.java:432)
at oracle.adf.model.binding.DCBindingContainer.reportException(DCBindingContainer.java:480)
at oracle.adf.model.binding.DCControlBinding.reportException(DCControlBinding.java:201)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.reportException(JUCtrlActionBinding.java:2101)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1733)
at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2188)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:789)
at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:407)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:210)
at sun.reflect.GeneratedMethodAccessor26337.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at oracle.adf.controller.internal.util.ELInterfaceImpl.invokeMethod(ELInterfaceImpl.java:173)
at oracle.adfinternal.controller.activity.MethodCallActivityLogic.execute(MethodCallActivityLogic.java:162)
at oracle.adfinternal.controller.engine.ControlFlowEngine.executeActivity(ControlFlowEngine.java:1156)
at oracle.adfinternal.controller.engine.ControlFlowEngine.doRouting(ControlFlowEngine.java:1006)
at oracle.adfinternal.controller.engine.ControlFlowEngine.doRouting(ControlFlowEngine.java:905)
at oracle.adfinternal.controller.engine.ControlFlowEngine.routeFromActivity(ControlFlowEngine.java:549)
at oracle.adfinternal.controller.engine.ControlFlowEngine.performControlFlow(ControlFlowEngine.java:155)
at oracle.adfinternal.controller.application.NavigationHandlerImpl.handleAdfcNavigation(NavigationHandlerImpl.java:109)
at oracle.adfinternal.controller.application.NavigationHandlerImpl.handleNavigation(NavigationHandlerImpl.java:78)
at org.apache.myfaces.trinidadinternal.application.NavigationHandlerImpl.handleNavigation(NavigationHandlerImpl.java:43)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:130)
at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)
at org.apache.myfaces.trinidad.component.UIXCollection.broadcast(UIXCollection.java:151)
at org.apache.myfaces.trinidad.component.UIXTable.broadcast(UIXTable.java:279)
at oracle.adf.view.rich.component.UIXTable.broadcast(UIXTable.java:145)
.
.
.
.
Caused by: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO CMP_LOOKUP_USAGES_B(LOOKUP_USAGE_ID,KEY_TYPE,KEY_VALUE,ATTRIBUTE_NAME,ATTRIBUTE_VALUE,ENABLED_FLAG,ORDER_NUM,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)".
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:586)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:9040)
at oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.doDML(OAEntityImpl.java:725)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:7251)
at oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.postChanges(OAEntityImpl.java:3639)
at oracle.apps.hcm.common.core.HcmEntityImpl.postChanges(HcmEntityImpl.java:3015)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3359)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3162)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2165)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2446)
at oracle.apps.hcm.compensation.plans.uiModel.applicationModule.TaskListAMImpl.setGlobalParams(TaskListAMImpl.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.adf.model.binding.DCInvokeMethod.invokeMethod(DCInvokeMethod.java:690)
at oracle.adf.model.binding.DCDataControl.invokeMethod(DCDataControl.java:2181)
at oracle.adf.model.bc4j.DCJboDataControl.invokeMethod(DCJboDataControl.java:3141)
at oracle.adf.model.binding.DCInvokeMethod.callMethod(DCInvokeMethod.java:262)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1708)
... 126 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("FUSION"."CMP_LOOKUP_USAGES_B"."BUSINESS_GROUP_ID")

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)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:432)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate to Compensation > Workforce Compensation -> Manage Plans >select the plan >

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users unable to make any changes to plan


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