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

Last updated on APRIL 16, 2024

Applies to:

Symptoms

Custom Responsibility:

Trying to create an expenditure batch using Excel.
Excel template has been configured as was 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-validate' 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

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