R12 : Setup Purchasing Options Gives Error JBO-27122 You Have Encountered An Error

To Bottom

---

In this Document Symptoms Cause Solution References 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 The financial options are not yet setup. SOLUTION To implement the solution, please execute the following steps : 1. Navigate - Setup/Organizations/Financial Options 2. Proceed to setup the Financial Options then proceed to setup the Purchasing Options The following error message should appear - as it does if you navigate to the Document Types form prior to setting up the Financial Options. Purchasing Options or Financial Options have not been defined for the Operating Unit The following severity 3 bug is with Oracle Development to request that the same proper error message be given: Bug 12918777 - JBO-27122 WHEN NAVIGATING TO THE PURCHASING OPTIONS FORM -IMPROPER ERROR