R12 WEBADI Project Expenditure Excel Spreadsheet Upload, Exception Name: Oracle.apps.bne.exception.BneSQLException - Cannot Execute SQL Statement. (Doc ID 1592440.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Project Costing - Version 12.0.6 and later
Information in this document applies to any platform.
*** Checked for relevance 06-Apr-2015 ***

Symptoms

Custom Responsibility:

Trying to create an expenditure batch Entry using Excel.
Excel template has been configured as done for another Operating Unit.
While trying to upload the data, encountering an error for the Project field and the error is as follows;


The following error has occurred
Exception Name: oracle.apps.bne.exception.BneSQLException - Cannot execute SQL Statement.
Cause: A low level API call failed.
Action: Please note this error to your support representative.
Statement: SELECT PROJECT_NUMBER,PROJECT_NAME FROM PA_PROJECTS_EXPEND_V WHERE PROJECT_OU = :1 ORDER BY 1 ASC
Bind values used in SQL statement:
Log File Bookmark: 485130'

The error is encountered only when using the 'Pre-valdiate' option in the Upload Parameters section.
If not, the expenditure is getting uploaded without error. The same error is encountered when clicking
on the Project field as well. It appears to be something to do with the Operating Unit.

*********
7/17/13 3:35 PM AJPRequestHandler-HTTPThreadGroup-3 WARNING BneSitePropertyManager.setValuesFromBneProperties - loading values from properties file
7/17/13 3:35 PM AJPRequestHandler-HTTPThreadGroup-3 WARNING BneSitePropertyManager.setValuesFromBneProperties - end
7/17/13 3:36 PM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneParentMenuResolver.getMenuItem() MENU 101:BUDGET_NOTE - Menu item excluded because IntegratorAppId and Code does not match that of the Top-Most Menu Item or current Integrator: 275:PAXTTRXB
7/17/13 3:36 PM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneBaseSQL.executeBneQuery: Exception while running query. Error Code: 17041, Message: Missing IN or OUT parameter at index:: 1
7/17/13 3:36 PM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneBaseSQL.executeBneQuery: Query: SELECT PROJECT_NUMBER,PROJECT_NAME FROM PA_PROJECTS_EXPEND_V WHERE PROJECT_OU = :1 ORDER BY 1 ASC
7/17/13 3:36 PM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneBaseSQL.executeBneQuery: Args :
7/17/13 3:36 PM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneBaseSQL.executeBneQuery: Stack trace: 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)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1719)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3334)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at oracle.apps.bne.utilities.sql.BneBaseSQL.executeBneQuery(BneBaseSQL.java:1592)
at oracle.apps.bne.utilities.sql.BneBaseSQL.getBneResultSet(BneBaseSQL.java:739)
at oracle.apps.pa.webadi.integrator.validators.PaProjectValidator.getDomainValues(PaProjectValidator.java:105)
at oracle.apps.pa.webadi.integrator.component.PaProjectComponent.getTableData(PaProjectComponent.java:248)
at oracle.apps.pa.webadi.integrator.component.PaProjectComponent.handleListOfValues(PaProjectComponent.java:173)
at oracle.apps.bne.integrator.component.BneAbstractListOfValues.handleComponent(BneAbstractListOfValues.java:549)
at oracle.apps.bne.integrator.component.BneComponentService.executeComponent(BneComponentService.java:443)
at oracle.apps.bne.integrator.component.BneComponentService.handleRequest(BneComponentService.java:265)
at oracle.apps.bne.framework.BneBajaServlet.doRequest(BneBajaServlet.java:246)
at oracle.apps.bne.framework.BneBaseServlet.doPost(BneBaseServlet.java:95)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)

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