On performing qbe, exception occurs in the following scenario
Let the current selected row be 'a'. Now perform a query using qbe.
1. If the resultant set of rows after qbe contains previous selected row i.e
'a', then the error doesn't occur.
2.If the resultant set of rows doesn't contains previous selected row i.e
'a', then the error occurs
Stacktrace:
[2013-10-15T23:46:38.771-07:00] [ProductManagementServer_1] [ERROR] [ADFC-50017] [oracle.adfinternal.controller.application.AdfcExceptionHandler] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: pimqa] [ecid: 004uDOG95WMBt1GLIy^Ayf0004DJ0000qz,0:2] [APP: ProductManagementApp#V2.0] [DSID: 0000K6zxwIxBt1GLIy^Ayf1IHw6R007_^J] ADFc: While attempting to handle this exception the application's exception handler failed.[[
oracle.jbo.NoDefException: JBO-25058: Definition vc_temp_3 of type Variable is not found in ItemVO_313790_findByKey_.
at oracle.jbo.common.VariableManagerImpl.findVariable(VariableManagerImpl.java:337)
at oracle.jbo.common.VariableValueManagerImpl.getVariableValue(VariableValueManagerImpl.java:248)
at oracle.jbo.server.ViewObjectImpl.getRowMatchBindValue(ViewObjectImpl.java:23238)
at oracle.jbo.ExprEval.getOrTypeRowVal(ExprEval.java:1906)
at oracle.jbo.ExprEval.getRowVal(ExprEval.java:1887)
at oracle.jbo.server.RowImpl.getOrTypeExprVarVal(RowImpl.java:2029)
at oracle.jbo.server.RowImpl.getExprVarVal(RowImpl.java:2014)
at oracle.jbo.server.ViewRowImpl.getExprVarVal(ViewRowImpl.java:3079)
at oracle.jbo.RowValueSupplier.getOrTypeExprVarVal(RowValueSupplier.java:109)
at oracle.jbo.RowValueSupplier.getExprVarVal(RowValueSupplier.java:100)
at oracle.jbo.expr.JIParserNode.evaluate(JIParserNode.java:752)
at oracle.jbo.expr.JIParserNode.evaluate(JIParserNode.java:968)
at oracle.jbo.expr.JIExprSQL.getBuiltInMethodVal(JIExprSQL.java:291)
at oracle.jbo.expr.JIParserMethodNode.evaluate(JIParserMethodNode.java:89)
at oracle.jbo.expr.JIParserNodeRegExp.evaluate(JIParserNodeRegExp.java:35)
at oracle.jbo.ExprEval.doEvaluate(ExprEval.java:1824)
at oracle.jbo.ExprEval.doEvaluate(ExprEval.java:1754)
at oracle.jbo.ExprEval.evaluateForRow(ExprEval.java:1485)
at oracle.jbo.RowMatch.rowQualifies(RowMatch.java:187)
at oracle.jbo.server.ViewObjectImpl.rowQualifies(ViewObjectImpl.java:3035)
at oracle.apps.scm.productCatalogManagement.versions.protectedModel.view.ChangeVersionViewImpl.rowQualifiesSuper(ChangeVersionViewImpl.java:2442)
at oracle.apps.scm.productCatalogManagement.versions.protectedModel.view.ChangeVersionViewImpl.rowQualifies(ChangeVersionViewImpl.java:2438)
at oracle.apps.scm.productModel.items.protectedUiModel.view.ItemVOImpl.rowQualifies(ItemVOImpl.java:197)
at oracle.jbo.server.QueryCollection.rowQualifies(QueryCollection.java:3957)
at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3842)
at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3635)
at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2348)
at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5192)
at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2989)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2845)
at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3086)
at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2853)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1321)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1459)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1366)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1351)
at oracle.jbo.server.ViewObjectImpl.getFinderRS(ViewObjectImpl.java:18007)
at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17528)
at oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17522)
at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5614)
at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5363)
at oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5357)
at oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11996)
at oracle.apps.scm.productCatalogManagement.versions.protectedModel.view.ChangeVersionViewImpl.findByKeySuper(ChangeVersionViewImpl.java:2311)
at oracle.apps.scm.productCatalogManagement.versions.protectedModel.view.ChangeVersionViewImpl.findByKey(ChangeVersionViewImpl.java:1176)
at oracle.jbo.uicli.binding.JUCtrlHierBinding.bringNodeToRangeKeyPath(JUCtrlHierBinding.java:828)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding.bringNodeToRangeKeyPath(FacesCtrlHierBinding.java:109)
at oracle.adfinternal.view.faces.model.binding.RowDataManager.setRowKey(RowDataManager.java:133)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.setRowKey(FacesCtrlHierBinding.java:705)
at org.apache.myfaces.trinidad.component.UIXCollection.setRowKey(UIXCollection.java:443)