Error When Trying To Save An Integrator With An Asynchronous Type of Concurrent Request (Doc ID 1368367.1)

Last updated on DECEMBER 03, 2015

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


The following error is shown when trying to save a custom integrator with an Asynchronous type of concurrent request and no pre-import rules defined:
401:CR_500010 has the following error: API Parameter name is not defined in Attribute 1.

BNE.LOG shows:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT BnePreImportRulesEO.APPLICATION_ID,
BnePreImportRulesEO.PARAM_LIST_CODE,
BnePreImportRulesEO.SEQUENCE_NUM,
BnePreImportRulesEO.OBJECT_VERSION_NUMBER,
BnePreImportRulesEO.PARAM_DEFN_APP_ID,
BnePreImportRulesEO.PARAM_DEFN_CODE,
BnePreImportRulesEO.PARAM_NAME,
BnePreImportRulesEO.STRING_VALUE,
BnePreImportRulesEO.DESC_VALUE,
BnePreImportRulesEO.CREATED_BY,
BnePreImportRulesEO.CREATION_DATE,
BnePreImportRulesEO.LAST_UPDATED_BY,
BnePreImportRulesEO.LAST_UPDATE_DATE,
BnePreImportRulesEO.LAST_UPDATE_LOGIN,
(select BneParamListsBEO.USER_NAME from BNE_PARAM_LISTS_VL BneParamListsBEO where BneParamListsBEO.PARAM_LIST_CODE = substr(BnePreImportRulesEO.STRING_VALUE,instr(BnePreImportRulesEO.STRING_VALUE,':')+1) AND BneParamListsBEO.application_id = substr(BnePreImportRulesEO.STRING_VALUE,0,instr(BnePreImportRulesEO.STRING_VALUE,':')-1)) as USER_NAME,
(select BneParamListsBEO.PARAM_LIST_CODE from BNE_PARAM_LISTS_VL BneParamListsBEO where BneParamListsBEO.PARAM_LIST_CODE = substr(BnePreImportRulesEO.STRING_VALUE,instr(BnePreImportRulesEO.STRING_VALUE,':')+1) AND BneParamListsBEO.application_id = substr(BnePreImportRulesEO.STRING_VALUE,0,instr(BnePreImportRulesEO.STRING_VALUE,':')-1)) as LIST_CODE,
(select BneParamListsBEO.APPLICATION_ID from BNE_PARAM_LISTS_VL BneParamListsBEO where BneParamListsBEO.PARAM_LIST_CODE = substr(BnePreImportRulesEO.STRING_VALUE,instr(BnePreImportRulesEO.STRING_VALUE,':')+1) AND BneParamListsBEO.application_id = substr(BnePreImportRulesEO.STRING_VALUE,0,instr(BnePreImportRulesEO.STRING_VALUE,':')-1)) as LIST_APP_ID,
CASE BnePreImportRulesEO.PARAM_NAME WHEN 'SQL' THEN 1
WHEN 'SEQUENCE' THEN 4
WHEN 'PLSQL' THEN 3 END AS RULE_TYPE,
row_number() OVER (ORDER BY BnePreImportRulesEO.SEQUENCE_NUM) AS SEQ_NUM
FROM BNE.BNE_PARAM_LIST_ITEMS BnePreImportRulesEO
where BnePreImportRulesEO.PARAM_NAME in ('SQL', 'SEQUENCE' , 'PLSQL') AND BnePreImportRulesEO.APPLICATION_ID = :1 AND BnePreImportRulesEO.PARAM_LIST_CODE = :2
ORDER BY BnePreImportRulesEO.SEQUENCE_NUM ASC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)...
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
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)
...

 

OR

When attempting to upload data using Web ADI with an Asynchronous Type of Concurrent Request, the following error occurs:

An error has occurred while running an API Import. The ERRORED_ROWS step 20003:ER-500288,parameter number 1 must contain the value BIND in attribute 1 or

The import program could not be started. Contact your system administrator. The ERRORED_ROWS step 140:ER_500165, parameter number 1 must contain the value BIND in attribute 1

The import program could not be started. Contact your system administrator. The ERROR_LOOKUP step 140:EL_500166 parameter QUEUE_NAME must have a data type of VARCHAR2

The import program could not be started. Contact your system administrator. Parameter 1 of the SQL import step parameter List 140:EL_500166 must have a value in attribute 2 for RETURN parameters.

The issue can be reproduced at will with the following steps:
1. Create a new WebADI document using standard navigation.
2. Upload data.
3. Collect the BNE trace.
4. Review the trace file.

Changes

Fresh install of R12.1.3

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