Desktop Integration Manager Form Errors JBO-27122 Attempting To Create Template (Doc ID 1906303.1)

Last updated on JULY 16, 2014

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.1.3, the following error during statement preparation occurs when clicking on next using Create Integrator:

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT BneContentsEO.APPLICATION_ID, BneContentsEO.CONTENT_CODE, BneContentsEO.OBJECT_VERSION_NUMBER, BneContentsEO.INTEGRATOR_APP_ID, BneContentsEO.INTEGRATOR_CODE, BneContentsEO.PARAM_LIST_APP_ID, BneContentsEO.PARAM_LIST_CODE, BneContentsEO.CONTENT_CLASS, BneContentsEO.CREATION_DATE, BneContentsEO.LAST_UPDATED_BY, BneContentsEO.LAST_UPDATE_LOGIN, BneContentsEO.LAST_UPDATE_DATE, BneContentsEO.ONCE_ONLY_DOWNLOAD_FLAG, BneContentsEO.USER_NAME, BneContentsEO.CREATED_BY, CASE nvl(BneContentsEO.CONTENT_CLASS ,'NONE') WHEN 'oracle.apps.bne.webui.control.BneFileDownloadControl' THEN 'TEXT' WHEN 'oracle.apps.bne.webui.control.BneStoredSQLControl' THEN 'SQLQUERY' WHEN 'oracle.apps.bne.webui.control.BnePassedSQLControl' THEN 'SQLQUERY' WHEN 'NONE' THEN 'NONE' ELSE 'JAVA' END AS MEANING, decode (nvl(BneContentsEO.CONTENT_CLASS ,'NONE'), 'NONE', 'DeleteDisabled', 'DeleteEnabled') as DELETE_SWITCHER, 'UpdateEnabled' as UPDATE_SWITCHER, nvl((Select distinct mb.reporting_flag from bne_mappings_b mb, bne_mapping_lines ml where mb.application_id = ml.application_id and mb.mapping_code = ml.mapping_code and mb.integrator_app_id = BneContentsEO.integrator_app_id and mb.integrator_code = BneContentsEO.integrator_code and ml.content_app_id = BneContentsEO.application_id and ml.content_code like BneContentsEO.content_code ), 'N') AS REPORTING_FLAG, (SELECT USER_NAME FROM BNE_PARAM_LISTS_TL BneParamListTL WHERE BneParamListTL.APPLICATION_ID = BneContentsEO.PARAM_LIST_APP_ID AND BneParamListTL.PARAM_LIST_CODE = BneContentsEO.PARAM_LIST_CODE AND BneParamListTL.LANGUAGE=USERENV('LANG')) AS CONTENT_PARAM_LIST_NAME, (SELECT APPLICATION_NAME FROM FND_APPLICATION_VL FA WHERE FA.APPLICATION_ID = BneContentsEO.PARAM_LIST_APP_ID) AS CONTENT_PARAM_LIST_APP_NAME FROM BNE_CONTENTS_VL BneContentsEO) QRSLT ORDER BY content_code at
oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)


## Detail 0 ## java.sql.SQLException: ORA-01427: single-row subquery returns more than one row at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)


at oracle.apps.bne.wdf.content.server.BneContentTableVOImpl.executeQuery(BneContentTableVOImpl.java:176)
at oracle.apps.bne.wdf.content.server.BneContentsAMImpl.createContentTableRow(BneContentsAMImpl


The issue can be reproduced at will with the following steps:
1. Using desktop Integration Manager.
2. Create Integrator.
3. Filling out details and clicking on next.

The issue has the following business impact:
Due to this issue, users cannot create BNE Templates.

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