Enabling DFF At Requisition Distribution Level In Iprocurement (Doc ID 2035574.1)

Last updated on JANUARY 19, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Catalog Shopping

Add To Cart of Non Catalog Request Item from Favorite List causes unexpected error.
User adds an item from Non Catalog Request Page to Favorite List.
Then user goes to Shopping Lists (Personal Favorites) and attempts to .This causes an unexpected error (JBO-27122).

If browser back button is used and then the user attempts there is no error.

Extract from unexpected Error:
 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, ... ...


ERROR
-----------------------
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:
...
 ## 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. Add product
4. See 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