Renaming An Attribute On View Object Does Not Rename Attribute Used In Sorting (Doc ID 2856194.1)

Last updated on JULY 21, 2022

Applies to:

Symptoms

Renaming an attribute on View Object does not rename attribute used in sorting

The application fails when executing a View Object that has had an attribute been renamed that is used in the sorting criteria. The issue is that the renaming does not affect the attribute used in the sorting criteria.

A great concern is that the error message does not specify that the sorting criteria is the issue. Only that the attribute of the previous name can not be found.

Workaround :

Remove the attribute from sorting criteria and reapply the attribute

Exception stack trace :

oracle.jbo.NoDefException: JBO-25058: Definition CommissionPct of type Attribute is not found in EmployeesView1.
at oracle.jbo.server.ViewObjectImpl.findAttributeDef(ViewObjectImpl.java:9079)
at oracle.jbo.server.ViewObjectImpl.traverseSortCriteria(ViewObjectImpl.java:4974)
at oracle.jbo.server.ViewObjectImpl.processAttrsForQuery(ViewObjectImpl.java:4813)
at oracle.jbo.server.ViewObjectImpl.processNewSelectSet(ViewObjectImpl.java:1992)
at oracle.jbo.server.ViewObjectImpl.prepareVOForQuery(ViewObjectImpl.java:5490)
at oracle.jbo.server.ApplicationModuleImpl.selectAttributesForViewObjects(ApplicationModuleImpl.java:8330)
at oracle.jbo.server.ApplicationModuleImpl.prepareViewObjects(ApplicationModuleImpl.java:8251)
at oracle.adf.model.binding.DCIteratorBinding.fetchAttributeProperties(DCIteratorBinding.java:3143)
at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(DCIteratorBinding.java:1955)
at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(DCIteratorBinding.java:1900)
at oracle.jbo.uicli.binding.JUIteratorBinding.internalGetRowSetIterator(JUIteratorBinding.java:571)
at oracle.adf.model.binding.DCIteratorBinding.getRowSetIterator(DCIteratorBinding.java:1862)
at oracle.adf.internal.model.rest.core.domain.Resource.getChildRSI(Resource.java:1729)
at oracle.adf.internal.model.rest.core.domain.ResourceTree.configureResource(ResourceTree.java:302)
at oracle.adf.internal.model.rest.core.domain.ResourceTree.init(ResourceTree.java:290)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceProcessingContext.init(ResourceProcessingContext.java:156)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecycle.prepareModel(ResourceLifecycle.java:127)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecyclePhase$2.executePhase(ResourceLifecyclePhase.java:12)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecycleProcessor.processPhase(ResourceLifecycleProcessor.java:351)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecycleProcessor.processExecutionPhases(ResourceLifecycleProcessor.java:289)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecycleProcessor.executeLifecycle(ResourceLifecycleProcessor.java:142)
at oracle.adf.internal.model.rest.core.lifecycle.ResourceLifecycleProcessor.execute(ResourceLifecycleProcessor.java:74)
at oracle.adf.internal.model.rest.core.http.RESTHttpRequestExecutor.internalExecute(RESTHttpRequestExecutor.java:233)
at oracle.adf.internal.model.rest.core.http.RESTHttpRequestExecutor.execute(RESTHttpRequestExecutor.java:112)
at oracle.adf.model.servlet.rest.ResourceServlet.execute(ResourceServlet.java:96)
at oracle.adf.internal.model.rest.core.http.BaseResourceServlet.internalExecute(BaseResourceServlet.java:233)
at oracle.adf.internal.model.rest.core.http.BaseResourceServlet.doGet(BaseResourceServlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.