My Oracle Support Banner

Add To Cart from Non Catalog Request Items From Favorite List Causes Unexpected Error: JBO-27122; java.sql.SQLException: Missing IN or OUT parameter at index:: 1 (Doc ID 1954986.1)

Last updated on JULY 26, 2022

Applies to:

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

Symptoms

Add To Cart of Non Catalog Request Item from Favorite List causes unexpected error.

ERROR
You have encountered an unexpected error

Exception Details

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PorNoncatTemplatesAll.TEMPLATE_ID, PorNoncatTemplatesAll.ORG_ID, PorNoncatTemplatesAll.ITEM_TYPE, PorNoncatTemplatesAll.DESC_EDITABLE_FLAG, PorNoncatTemplatesAll.CATEGORY_ID, ... ...
...
 ## Detail 0 ##
 java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  at
 oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1783

 

STEPS

The issue can be reproduced at will with the following steps:
1. Login iProcurement
2. Non-Catalog Request
3. Specify item details
4. Add to Favorites
5. Navigate to favorites shopping list
6. Add to cart
- get the error
7. Click back button
8. Reattempt add to cart
- no error

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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