My Oracle Support Banner

Error When Editing Rule in Oracle Configurator Developer - JBO-27122: SQL error during statement preparation CZ_DEVELOPER_UTILS_PVT.replace_Rule_Text (Doc ID 2574194.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

Oracle Configurator Developer - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to view or edit the rule text for a statement rule in Oracle Configurator Developer for certain impacted rules, the following error occurs for some users.
Not all users observe the error message, others can edit and open the rules for viewing without error.


Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select CZ_DEVELOPER_UTILS_PVT.replace_Rule_Text(:1,1) from dual
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument( [...]


1. Oracle Configurator Developer responsibility as an impacted user

2. Navigate to the model in the repository and edit it

3. Select the Rules tab

4. Edit one of the impacted statement rules.

5. Error occurs.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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