R12 : Setup Purchasing Options Gives Error JBO-27122 You Have Encountered An Error (Doc ID 1353102.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Purchasing - Version 12.1.1 and later
Information in this document applies to any platform.
PBWC : Professional Buyer Work Center
***Checked for relevance on 02-Sep-2014***


Symptoms

When attempting to setup the purchasing options, error is encountered:

Error:
You have encountered an error. Please contact the System Administrator for assistance.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID,
PoSystemParameterEO.ORG_ID,
PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE,
PoSystemParameterEO.REQ_CAN_AUTHORIZE,
PoSystemParameterEO.INSPECTION_REQUIRED_FLAG,
PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE,
PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE,
PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE,
PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE,
PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE,
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1738)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3382)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)


Replication Steps:
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Setup/Organizations/Purchasing Options
3. Framework based web form opens, and there is an error.

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