Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: ORA-01007: variable not in select list (JDeveloper 9i, Apps 11.5.10.2)
java.sql.SQLException: ORA-01007: variable not in select list [message #503186] Wed, 13 April 2011 07:21 Go to next message
stephaniewatton
Messages: 5
Registered: April 2011
Junior Member
Hi,

I am extending a seeded VO and when after I deploy it to the server and try to open the page I get the following error stack:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID,
QRSLT.RCV_SHIPMENT_NUMBER,
QRSLT.ORDER_TYPE_CODE,
QRSLT.RECEIPT_DATE,
QRSLT.REQUESTOR_ID,
QRSLT.PO_HEADER_ID,
QRSLT.PO_RELEASE_ID,
QRSLT.ORDER_ID,
QRSLT.PO_NUMBER,
QRSLT.PO_LINE_ID,
QRSLT.PO_LINE_LOCATION_ID,
QRSLT.PO_RELEASE_NUMBER,
QRSLT.PO_LINE_NUMBER,
QRSLT.PO_SHIPMENT_NUMBER,
QRSLT.TO_ORGANIZATION_ID,
QRSLT.ITEM_ID,
QRSLT.PRIMARY_UOM,
QRSLT.PRIMARY_UOM_CLASS,
QRSLT.QUANTITY_DELIVERED,
QRSLT.EXPECTED_RECEIPT_QTY,
QRSLT.ITEM_DESCRIPTION,
QRSLT.SHIP_TO_LOCATION_ID,
QRSLT.VENDOR_ID,
QRSLT.SOURCE,
QRSLT.VENDOR_SITE_ID,
QRSLT.SUPPLIER_SITE,
QRSLT.NEED_BY_DATE,
QRSLT.PROMISED_DATE,
QRSLT.EXPECTED_RECEIPT_DATE,
QRSLT.ORDERED_QTY,
QRSLT.ORDERED_UOM,
QRSLT.USSGL_TRANSACTION_CODE,
QRSLT.PO_DISTRIBUTION_ID,
QRSLT.PO_NUM_REL_NUM,
QRSLT.UNIT,
QRSLT.RECEIPT_QUANTITY,
QRSLT.REQ_DISTRIBUTION_ID,
QRSLT.DELIVER_TO_LOCATION_ID,
QRSLT.REQ_HEADER_ID,
QRSLT.REQUISITION_NUMBER,
QRSLT.ORDER_TYPE,
QRSLT.PO_DISTRIBUTION_NUM,
QRSLT.VENDOR_PRODUCT_NUM,
QRSLT.ORDER_NUMBER,
QRSLT.MATCHING_BASIS,
QRSLT.REQ_LINK,
QRSLT.SHIPMENT_HEADER_ID ,
QRSLT.MANUFACTURER_PART_NUMBER,
QRSLT.OPERATING_UNIT,
PORD.PROJECT_ID,
PAPA.SEGMENT1 PROJECT_NUMBER,
papa.name PROJECT_NAME,
PORL.LINE_NUM REQ_LINE_NUM,
PAT.TASK_NUMBER,
PAT.TASK_NAME,
pord.Expenditure_Type,
NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE
FROM
(SELECT REQ_LINE_ID,
RCV_SHIPMENT_NUMBER,
ORDER_TYPE_CODE,
RECEIPT_DATE,
REQUESTOR_ID,
PO_HEADER_ID,
PO_RELEASE_ID,
ORDER_ID,
PO_NUMBER,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_RELEASE_NUMBER,
PO_LINE_NUMBER,
PO_SHIPMENT_NUMBER,
TO_ORGANIZATION_ID,
ITEM_ID,
PRIMARY_UOM,
PRIMARY_UOM_CLASS,
QUANTITY_DELIVERED,
EXPECTED_RECEIPT_QTY,
ITEM_DESCRIPTION,
SHIP_TO_LOCATION_ID,
VENDOR_ID,
SOURCE,
VENDOR_SITE_ID,
SUPPLIER_SITE,
NEED_BY_DATE,
PROMISED_DATE,
EXPECTED_RECEIPT_DATE,
ORDERED_QTY,
ORDERED_UOM,
USSGL_TRANSACTION_CODE,
PO_DISTRIBUTION_ID,
PO_NUM_REL_NUM,
PRIMARY_UOM UNIT,
EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY,
REQ_DISTRIBUTION_ID,
DELIVER_TO_LOCATION_ID,
REQ_HEADER_ID,
REQUISITION_NUMBER,
(SELECT lookup.meaning
FROM fnd_lookup_values_vl lookup
WHERE lookup.lookup_code = rcv.order_type_code
AND lookup.lookup_type ='POR_RCV_ORDER_TYPE'
) ORDER_TYPE,
PO_DISTRIBUTION_NUM,
VENDOR_PRODUCT_NUM,
to_number(NULL) ORDER_NUMBER,
matching_basis,
DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link,
to_number(NULL) shipment_header_id,
MANUFACTURER_PART_NUMBER,
OPERATING_UNIT
FROM por_rcv_my_purchase_items_v rcv
UNION ALL
SELECT REQ_LINE_ID,
RCV_SHIPMENT_NUMBER,
ORDER_TYPE_CODE,
RECEIPT_DATE,
REQUESTOR_ID,
PO_HEADER_ID,
TO_NUMBER(NULL) PO_RELEASE_ID,
ORDER_ID,
PO_NUMBER,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_RELEASE_NUMBER,
PO_LINE_NUMBER,
PO_SHIPMENT_NUMBER,
TO_ORGANIZATION_ID,
ITEM_ID,
PRIMARY_UOM,
PRIMARY_UOM_CLASS,
QUANTITY_DELIVERED,
EXPECTED_RECEIPT_QTY,
ITEM_DESCRIPTION,
SHIP_TO_LOCATION_ID,
VENDOR_ID,
SOURCE,
VENDOR_SITE_ID,
SUPPLIER_SITE,
NEED_BY_DATE,
PROMISED_DATE,
EXPECTED_RECEIPT_DATE,
ORDERED_QTY,
ORDERED_UOM,
USSGL_TRANSACTION_CODE,
PO_DISTRIBUTION_ID,
PO_NUM_REL_NUM,
PRIMARY_UOM UNIT,
EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY,
REQ_DISTRIBUTION_ID,
DELIVER_TO_LOCATION_ID,
REQ_HEADER_ID,
REQUISITION_NUMBER,
(SELECT lookup.meaning
FROM fnd_lookup_values_vl lookup
WHERE lookup.lookup_code = rcv1.order_type_code
AND lookup.lookup_type ='POR_RCV_ORDER_TYPE'
) ORDER_TYPE,
PO_DISTRIBUTION_NUM,
VENDOR_PRODUCT_NUM,
ORDER_NUMBER,
matching_basis,
DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link,
to_number(NULL) shipment_header_id,
MANUFACTURER_PART_NUMBER,
OPERATING_UNIT
FROM por_rcv_internal_items_v rcv1
) QRSLT
,PO.PO_REQ_DISTRIBUTIONS_ALL pord
,PO.PO_REQUISITION_LINES_ALL porl
,PA.PA_PROJECTS_ALL PAPA
,PA.PA_TASKS PAT
WHERE
pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID
AND pord.requisition_line_id = porl.requisition_line_id
AND pord.PROJECT_ID = papa.PROJECT_ID
AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: ORA-01007: variable not in select list

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4507)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.icx.por.rcv.server.ReceiveItemsVOImpl.executeQuery(ReceiveItemsVOImpl.java:113)
at oracle.apps.icx.por.rcv.server.ReceiveItemsAMImpl.initQuery(ReceiveItemsAMImpl.java:165)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
java.sql.SQLException: ORA-01007: variable not in select list

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:631)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:518)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3375)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4507)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3339)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3326)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.icx.por.rcv.server.ReceiveItemsVOImpl.executeQuery(ReceiveItemsVOImpl.java:113)
at oracle.apps.icx.por.rcv.server.ReceiveItemsAMImpl.initQuery(ReceiveItemsAMImpl.java:165)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)
at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:94)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)

I am also not able to tick the Generate Accessors checkbox when compiling the VO. If I do I get the following:

Error in updating the java files for component:XXReceiveMyItemsVO

Exception: java.lang.NullPointerException

Can anyone help me please?

Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503188 is a reply to message #503186] Wed, 13 April 2011 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle Database Error Code ORA-1007 Description :
variable not in select list
Error Cause:
A reference was made to a variable not listed in the SELECT clause. In OCI, this can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in any of the following calls: DESCRIBE, NAME, or DEFINE. In SQL*Forms or SQL*Report, specifying more variables in an INTO clause than in the SELECT clause also causes this error.

Regards
Michel
Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503191 is a reply to message #503188] Wed, 13 April 2011 07:50 Go to previous messageGo to next message
stephaniewatton
Messages: 5
Registered: April 2011
Junior Member
Thanks for your reply. I have seen this already but it hasn't helped me. I have put the same query into the seeded VO and the page works fine, it is only a problem when I extend the VO.
Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503195 is a reply to message #503191] Wed, 13 April 2011 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, what is VO? And what is the meaning of "extend the VO"?

Regards
Michel

[Updated on: Wed, 13 April 2011 07:57]

Report message to a moderator

Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503198 is a reply to message #503195] Wed, 13 April 2011 07:58 Go to previous messageGo to next message
stephaniewatton
Messages: 5
Registered: April 2011
Junior Member
View Object
Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503200 is a reply to message #503198] Wed, 13 April 2011 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, I can't help you on this point.
I could help you on Java/JDBC code but not on GUI one.

What I can say from what you posted is that your SQL contains a ":2" without ":1" which is weird and that the error comes when you try to pass more variables than there are ":x" place holders in the query (for instance here 2 variables for only one ":2").

Regards
Michel
Re: java.sql.SQLException: ORA-01007: variable not in select list [message #503203 is a reply to message #503200] Wed, 13 April 2011 08:16 Go to previous messageGo to next message
stephaniewatton
Messages: 5
Registered: April 2011
Junior Member
this part is actually not part of my query but gets appended at runtime:

QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
Re: java.sql.SQLException: ORA-01007: variable not in select list [message #516300 is a reply to message #503203] Sat, 16 July 2011 05:19 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Did you try to run the sql standalone?
I'm getting Quote:
ORA-00904: "USSGL_TRANSACTION_CODE": invalid identifier
Please crosscheck whether the views por_rcv_my_purchase_items_v / por_rcv_internal_items_v are having this column.

By
Vamsi
Previous Topic: java.sql.SQLException: executeBatch, Exception = 1
Next Topic: Loading and processing XML file at run time
Goto Forum:
  


Current Time: Thu Mar 28 12:49:57 CDT 2024