IProcurement View Object Is Failing When User Enters In A Purchase Order-> PO Number Error: JBO-27122: SQL error during statement preparation. (Doc ID 3080843.1)

Last updated on APRIL 15, 2025

Applies to:

Symptoms

On : 12.2.14 version, Desktop Rcv/Returns/Correction

iProcurement View Object is failing when user enters in a PO Number.

Receiving the following error in R12.2.14 environment when user enters in a PO number when querying up data on the Receive Items page:



ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
..
## Detail 0 ##
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15906)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:911)
at
weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setObjectAtName(
Unknown Source)
at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3966


 
The issue can be reproduced at will with the following steps:

1. Log into Iprocurement responsibility
2. Click on Receive Items:
3. Clear defaults
4. Enter in a valid PO number
5. Hit Go and you receive the following error page:
 
Click on the “Click here for exception details”:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT * FROM (select REQ_LINE_ID,
null RCV_SHIPMENT_NUMBER,
ORDER_TYPE_CODE,
RECEIPT_DATE,
REQUESTOR_ID,
PO_HEADER_ID,
  PO_RELEASE_ID,
  ORDER_ID,
PO_NUMBER,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_RELEASE_NUMBER,
decode(fnd_profile.value('PO_CLM_ENABLED'),'Y',to_number(null),to_number(PO_LINE_NUMBER))
PO_LINE_NUMBER,
PO_SHIPMENT_NUMBER,
TO_ORGANIZATION_ID,
ITEM_ID,
PRIMARY_UOM,
PRIMARY_UOM_CLASS,
QUANTITY_DELIVERED,
EXPECTED_RECEIPT_QTY,
ITEM_DESCRIPTION,
SHIP_TO_LOCATION_ID,
VENDOR_ID,
SOURCE,
VENDOR_SITE_ID,
SUPPLIER_SITE,
NEED_BY_DATE,
PROMISED_DATE,
EXPECTED_RECEIPT_DATE,
ORDERED_QTY,
ORDERED_UOM,
PO_DISTRIBUTION_ID,
PO_NUM_REL_NUM,
PRIMARY_UOM UNIT,
decode(fnd_profile.value('POR_DEFAULT_RECEIPT_QUANTITY'),'N',EXPECTED_RECEIPT_QTY,'Y',to_number(n
ull),to_number(null),EXPECTED_RECEIPT_QTY) RECEIPT_QUANTITY,
REQ_DISTRIBUTION_ID,
DELIVER_TO_LOCATION_ID,
REQ_HEADER_ID,
  decode(nvl(to_char(ITEM_ID), ICX_RVW_RATING_UPDATE_PKG.blanketPOExist(REQ_LINE_ID)), 'N',
'WriteDisabled', 'WriteEnabled') AS WRITE_SWITCHER,
REQUISITION_NUMBER,
 
(select lookup.meaning
 from fnd_lookup_values_vl lookup
 where lookup.lookup_code = rcv.order_type_code
 and lookup.lookup_type ='POR_RCV_ORDER_TYPE')
ORDER_TYPE,
PO_DISTRIBUTION_NUM,
VENDOR_PRODUCT_NUM,
order_number,
  MATCHING_BASIS,
decode(req_distribution_id, to_number(null),
 'ReqLinkDisabled', 'ReqLinkEnabled') req_link,
  to_number(null) shipment_header_id,
  MANUFACTURER_PART_NUMBER,
  OPERATING_UNIT,
  QUANTITY_INVOICED,
  GL_ENCUMBERED_DATE,
fnd_global.login_id login_key,
to_number(null) Rcv_Shipment_Line_Id,
decode(fnd_profile.value('PO_CLM_ENABLED'),'Y',po_line_number,null) PO_CLM_LINE_NUMBER,
decode(fnd_profile.value('PO_CLM_ENABLED'),'Y','PoClmLineNumber','PoLineNumber') CLM_LINE_SWITCHER
from
por_rcv_purchase_items_v rcv) QRSLT WHERE (PO_HEADER_ID = :0)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:836)
at oracle.jbo.server.QueryCollection.executeQ
..
## Detail 0 ##
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15906)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:911)
at
weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setObjectAtName(
Unknown Source)
at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3966

 

Changes

 Upgrade from 12.2.09 to 12.2.14

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.