Selecting Supplier Information For Procurement Contractor Request gets Unexpected Error JBO-27122 and SQLException Missing IN or OUT parameter at index:: 1 (Doc ID 2157746.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Exception error when selecting supplier information for Procurement Contractor Request


Error

"You have encountered an unexpected error. Please contact the System Administrator for assistance."

JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM
(SELECT pha.segment1 source_doc_no,
      pha.org_id,
      pha.po_header_id,
      pha.vendor_id,
      pha.vendor_site_id,
      pha.vendor_contact_id,
      pha.start_date,
      pha.end_date,
      pha.type_lookup_code,
      pla.po_line_id,
      pla.line_num,
      pla.unit_meas_lookup_code,
      pla.negotiated_by_preparer_flag,
      pla.job_id,
      gt.num2 score,
      gt.char1 currency_code,
      gt.char2 rate_type,
      gt.date1 rate_date,
      gt.num4 rate,
      gt.num5 unit_price,
      gt.num6 price_break_id,
      DECODE(gt.num6, NULL, 'BLANKET LINE', 'PRICE BREAK')
price_diff_entity_type,
      DECODE(gt.num6, NULL, pla.po_line_id, gt.num6) price_diff_entity_id,
      gt.num7 base_price,
      gt.num8 discount,
      gt.char3 allow_rate_differential_flag,
      pla.not_to_exceed_price,
      pla.allow_price_override_flag,
      pav.num_cat_attribute1,
      pav.num_cat_attribute2,
      pav.num_cat_attribute3,
      pav.num_cat_attribute4,
      pav.num_cat_attribute5,
...
....
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(UnknownSource)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4591)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2654)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1471)
at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2836)
at oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5831)
at oracle.apps.icx.por.req.webui.RateCardPostProcessingCO.postProcessRateCard(RateCardPostProcessingCO.java:90)
at oracle.apps.icx.por.req.webui.RateCardPostProcessingCO.processFormRequest(RateCardPostProcessingCO.java:61)
...

 


Steps to reproduce

1. Try to create a contract request
2. Click on "Suggest Supplier and Contractor" radio button
3. See the error

Changes

 

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