Cannot Create Sourcing Events By Using A Sourcing Template Due To Error JBO-27122 at FND_LOOKUP_VALUES (Doc ID 1614979.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

On 12.1.3 in Oracle Sourcing

Get JBO-27122 exception at FND_LOOKUP_VALUES when clicking Apply Template in Oracle Sourcing

ERROR

Error Page
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = :1
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 0
AND SECURITY_GROUP_ID = 0
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3260)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)
at _OA._jspService(_OA.java:228)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
...
## 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)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
...



STEPS TO REPRODUCE
1. Apply <Patch 17333489> (as recommended by Oracle for the issue reported via Doc id 1589622.1)
2. Create a sourcing document, and click Apply Template
    - Get the exception



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