3 Replies Latest reply on May 6, 2014 11:20 AM by 2648629

    R12.1.3: Iprocurement : Non-Catalog Request Error

    1025008

      Hi All -

       

      We are using I-procurement module and when we do the following navigation we receive below error.

       

       

       

      Navigation :

       

      Iprocurement - Click on Non-Catalog Request tab

       

       

       

      Error :

       

       

       

      Error Page

       

      Exception Details

       

      oracle.apps.fnd.framework.OAException:

       

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT

       

      LOOKUP_CODE, MEANINGFROM FND_LOOKUP_VALUES_Vl WHERE LOOKUP_TYPE = :1and enabled_flag = 'Y'

       

      ORDER BY MEANING ASC

       

      at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)

       

      at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)

       

      ...

       

      ## Detail 0 ##

       

      java.sql.SQLException: Missing IN or OUT parameter at index:: 1

       

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

       

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

       

      ...

       

       

       

      We found a hit in metalink related to the issue, we performed the steps, but no luck. Appreciate if someone could let us know the root cause for the issue or provide resolution

       

      Note: iProcurement Gets OAException And JBO-27122 At Non-Catalog Request (Doc ID 787125.1)

       

       

       

      Thanks,