iProcurement gets Unexpected Error with SQLException at Add To Cart in Non-Catalog Request page (Doc ID 2136077.1)

Last updated on MAY 10, 2016

Applies to:

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

Symptoms

In 12.1.3 iProcurement

iProcurement gets Unexpected Error at Add To Cart in Non-Catalog Request page

ERROR
You have encountered an unexpected error

Exception Details. oracle.apps.fnd.framework.OAException: java.sql.SQLException: Missing IN or OUT parameter at index:: 2

DEBUG LOG

icx.por.common.server.TransactionUtil getProfile.begin
icx.por.common.server.TransactionUtil getProfile: profileName == PO_VALIDATE_GL_PERIOD
icx.por.common.server.TransactionUtil getPorAppsContext.begin
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(): BEGIN/END
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(null,1730387868,false,false,false): : BEGIN
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@1c4d3d3
fnd.profiles.Profiles getProfileOptionValue: name=PO_VALIDATE_GL_PERIOD; levelID=10001; levelValue=0; levelValueApplID=0
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(): BEGIN/END
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(null,1730387868,false,false,false): : BEGIN
fnd.common.WebAppsContext oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@1c4d3d3
icx.por.common.server.TransactionUtil getProfile: profileValue == R
icx.por.common.server.TransactionUtil getProfile.end
icx.por.schema.server.EncumbranceHelper Returning from getGLPeriodNameFromDate():
icx.por.schema.server.EncumbranceHelper #Param# glPeriodName=null
java.lang.String Fatal OAException:java.sql.SQLException: Missing IN or OUT parameter at index:: 2
java.lang.String "Fatal OAException:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Missing IN or OUT parameter at index:: 2;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException(ErrorUtil.java:667)
at oracle.apps.icx.por.schema.server.EncumbranceHelper.validateInternal(EncumbranceHelper.java:846)
at oracle.apps.icx.por.schema.server.CheckoutInfoBaseHelper.validate(CheckoutInfoBaseHelper.java:185)
at oracle.apps.icx.por.schema.server.PoReqDistributionEOImpl.validationLogic(PoReqDistributionEOImpl.java:240)
at oracle.apps.icx.por.schema.server.PorBaseEOImpl.executeHelperLogic(PorBaseEOImpl.java:576)
at oracle.apps.icx.por.schema.server.PorBaseEOImpl.validateEntity(PorBaseEOImpl.java:628)
at oracle.jbo.server.EntityImpl.validate(EntityImpl.java:1549)
at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4019)
at oracle.apps.icx.por.req.server.ValidationSvrCmd.validateReq(ValidationSvrCmd.java:87)
at oracle.apps.icx.por.req.server.RequisitionAMImpl.validateReq(RequisitionAMImpl.java:758)

 

STEPS TO REPRODUCE
1. Login into iProcurement
2. Navigate to iProcurement Home Page
3. Click on non-catalog request
4. Enter the non-catalog request item details

Item Type = Goods billed by quantity
Item Description = test
Category = MISC.MISC
Quantity = 1
Unit of Measure = $US
Unit Price = 500
Currency = USD
Supplier = ABC USA
Site = USAABC1

5. Click Add to Cart
- get the error
6. Verify the period is open, despite the debug message glPeriodName=null
(Reference; <Note:1600434.1> - Checking Out iProcurement Requisition Errors With java.sql.SQLException - Missing IN Or OUT Parameter At Index:: 2)

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