af:query: Reset Button Fails With AttrValException JBO-27036 When jbo.ampool.doampooling=false

(Doc ID 1325762.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version to [Release Oracle11g]
Information in this document applies to any platform.


You have developed an ADF Faces/BC application in JDeveloper
Some pages have an af:query based on a View Criteria where Criteria items have the property "Validation" set to "Selectively Required".
When running the page under normal conditions, the page works correctly.
Under heavy load, however, end users get the following error when they click the "Reset" button after they executed a query:

"At least one of the following attributes <list of criteria items> is required."

and the following stack trace is displayed in the Logs:

<Utils> <buildFacesMessage> ADF: Adding the following JSF error message: At least one of the following attributes FirstName, LastName, PhoneNumber is required.
oracle.jbo.AttrValException: JBO-27036: At least one of the following attributes FirstName, LastName, PhoneNumber is required.
   at oracle.jbo.rules.JboVCItemRequiredValidator.validate(
   at oracle.jbo.common.ViewCriteriaImpl.validateRow(
   at oracle.jbo.common.ViewCriteriaImpl.validate(
   at oracle.jbo.server.ViewRowSetImpl.validateViewCriteria(
   at oracle.jbo.server.ViewRowSetImpl.execute(
   at oracle.jbo.server.ViewRowSetImpl.activateRowSetState(
   at oracle.jbo.server.ViewRowSetIteratorImpl.activateIteratorState(
   at oracle.jbo.server.ViewRowSetIteratorImpl.getRangeSize(
   at oracle.jbo.server.ViewRowSetImpl.getRangeSize(
   at oracle.jbo.server.ViewObjectImpl.getRangeSize(
   at oracle.adf.model.binding.DCIteratorBinding.initSourceRSI(
   at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(
   at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(
   at oracle.adf.model.binding.DCIteratorBinding.refresh(
   at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(
   at oracle.jbo.uicli.binding.JUCtrlHierNodeBinding.getChildren(
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.getHintMap(
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.getHints(
   at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGet(
   at oracle.jbo.uicli.binding.JUCtrlRangeBinding.internalGet(
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.internalGet(

If they press "Reset" a second time, they get a popup error:

JBO-27036: At least one of the following attributes <list of criteria items> is required.

ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #2"

The problem can be reproduced at will in the Development environment by setting jbo.ampool.doampooling=false, as explained in the following note:
<Note:417546.1> - How To Reproduce Problems Related to AM Passivation / Activation

A similar issue had been reported in the past.
At this time, the root cause had been identified as being the following bug:

However this bug was considered as fixed in JDeveloper
You have migrated to JDeveloper but still encountered the issue there.


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