I tried to extend an iRecruitment vo, JobResultsVO with couple of additional fields. Getting “java.sql.SQLSyntaxErrorException: ORA-00904: “IVS”.”EMPLOYEE”: invalid identifier
” error. The system is putting my query in another select statement, “QRSLT”, but trying to put a where statement with old table name. Can someone please help? I am using Binding Style: Oracle Positional.
Thanks,
Sarah
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ INDEX(LOC HR_LOCATIONS_N1) INDEX(pav) CARDINALITY(pav, 10) LEADING(pav) */ * FROM (SELECT HRL.MEANING,
HRL.LOOKUP_TYPE,
HRL.LOOKUP_CODE LOOKUP_CODE,
HL2.MEANING AS MEANING2,
HL2.LOOKUP_TYPE AS LOOKUP_TYPE2,
HL2.LOOKUP_CODE AS LOOKUP_CODE2,
PAV.VACANCY_ID,
PAV.BUSINESS_GROUP_ID,
PAV.POSITION_ID,
PAV.JOB_ID,
PAV.GRADE_ID,
PAV.ORGANIZATION_ID,
PAV.REQUISITION_ID,
PAV.PEOPLE_GROUP_ID,
PAV.LOCATION_ID,
PAV.RECRUITER_ID,
PAV.DATE_FROM,
PAV.NAME,
PAV.DATE_TO,
PAV.DESCRIPTION,
PAV.NUMBER_OF_OPENINGS,
PAV.STATUS,
PAV.VACANCY_CATEGORY,
PAV.MANAGER_ID,
PAV.SECURITY_METHOD,
PRA.RECRUITMENT_ACTIVITY_ID,
PRA.BUSINESS_GROUP_ID AS BUSINESS_GROUP_ID1,
PRA.AUTHORISING_PERSON_ID,
PRA.RUN_BY_ORGANIZATION_ID,
PRA.INTERNAL_CONTACT_PERSON_ID,
PRA.PARENT_RECRUITMENT_ACTIVITY_ID,
PRA.CURRENCY_CODE,
PRA.DATE_START,
PRA.NAME AS NAME1,
PRA.ACTUAL_COST,
PRA.CONTACT_TELEPHONE_NUMBER,
PRA.DATE_CLOSING,
PRA.DATE_END,
PRA.EXTERNAL_CONTACT,
PRA.PLANNED_COST,
PRA.TYPE,
PRA.STATUS AS STATUS1,
PRA.INTERNAL_POSTING,
PRA.EXTERNAL_POSTING,
PRF.RECRUITMENT_ACTIVITY_FOR_ID,
IPC.POSTING_CONTENT_ID,
IPC.DISPLAY_MANAGER_INFO,
IPC.DISPLAY_RECRUITER_INFO,
IPC.NAME AS NAME2,
IPC.ORG_NAME,
IPC.ORG_DESCRIPTION,
IPC.JOB_TITLE,
IPC.BRIEF_DESCRIPTION,
IPC.DETAILED_DESCRIPTION,
IPC.JOB_REQUIREMENTS,
IPC.ADDITIONAL_DETAILS,
IPC.HOW_TO_APPLY,
IPC.IMAGE_URL,
IPC.IMAGE_URL_ALT,
IPC.ATTRIBUTE_CATEGORY,
IPC.ATTRIBUTE1,
IPC.ATTRIBUTE2,
IPC.ATTRIBUTE3,
IPC.ATTRIBUTE4,
IPC.ATTRIBUTE5,
IPC.ATTRIBUTE6,
IPC.ATTRIBUTE7,
IPC.ATTRIBUTE8,
IPC.ATTRIBUTE9,
IPC.ATTRIBUTE10,
IPC.ATTRIBUTE11,
IPC.ATTRIBUTE12,
IPC.ATTRIBUTE13,
IPC.ATTRIBUTE14,
IPC.ATTRIBUTE15,
IPC.ATTRIBUTE16,
IPC.ATTRIBUTE17,
IPC.ATTRIBUTE18,
IPC.ATTRIBUTE19,
IPC.ATTRIBUTE20,
IPC.ATTRIBUTE21,
IPC.ATTRIBUTE22,
IPC.ATTRIBUTE23,
IPC.ATTRIBUTE24,
IPC.ATTRIBUTE25,
IPC.ATTRIBUTE26,
IPC.ATTRIBUTE27,
IPC.ATTRIBUTE28,
IPC.ATTRIBUTE29,
IPC.ATTRIBUTE30,
IPC.OBJECT_VERSION_NUMBER,
IPC.BENEFIT_INFO,
IVS.OBJECT_ID,
IVS.LOCATION,
IVS.EMPLOYEE EMPLOYEE,
IVS.CONTRACTOR CONTRACTOR,
IVS.EMPLOYMENT_CATEGORY,
IVS.KEYWORDS,
IVS.TRAVEL_PERCENTAGE,
IVS.MIN_SALARY,
IVS.MAX_SALARY,
IVS.SALARY_CURRENCY,
IVS.PROFESSIONAL_AREA,
IVS.WORK_AT_HOME,
IVS.MIN_QUAL_LEVEL,
IVS.MAX_QUAL_LEVEL,
IVS.OBJECT_TYPE,
IVS.SEARCH_CRITERIA_ID,
TO_CHAR (DECODE ( :1,
‘Y’, NVL2 (LOC.GEOMETRY,
FLOOR (IRC_LOCATION_UTILITY.SDO_MILES (
MDSYS.SDO_GEOMETRY (
2001,
8307,
MDSYS.SDO_POINT_TYPE ( :2,
:3,
NULL),
NULL,
NULL),
LOC.GEOMETRY,
0.01)),
”),
”))
AS DISTANCE_TO_LOCATION,
LOC.LOCATION_ID AS LOCATION_ID1,
LOC.DERIVED_LOCALE,
IVS.ATTRIBUTE_CATEGORY AS SC_ATTRIBUTE_CATEGORY,
IVS.ATTRIBUTE1 AS SC_ATTRIBUTE1,
IVS.ATTRIBUTE2 AS SC_ATTRIBUTE2,
IVS.ATTRIBUTE3 AS SC_ATTRIBUTE3,
IVS.ATTRIBUTE4 AS SC_ATTRIBUTE4,
IVS.ATTRIBUTE5 AS SC_ATTRIBUTE5,
IVS.ATTRIBUTE6 AS SC_ATTRIBUTE6,
IVS.ATTRIBUTE7 AS SC_ATTRIBUTE7,
IVS.ATTRIBUTE8 AS SC_ATTRIBUTE8,
IVS.ATTRIBUTE9 AS SC_ATTRIBUTE9,
IVS.ATTRIBUTE10 AS SC_ATTRIBUTE10,
IVS.ATTRIBUTE11 AS SC_ATTRIBUTE11,
IVS.ATTRIBUTE12 AS SC_ATTRIBUTE12,
IVS.ATTRIBUTE13 AS SC_ATTRIBUTE13,
IVS.ATTRIBUTE14 AS SC_ATTRIBUTE14,
IVS.ATTRIBUTE15 AS SC_ATTRIBUTE15,
IVS.ATTRIBUTE16 AS SC_ATTRIBUTE16,
IVS.ATTRIBUTE17 AS SC_ATTRIBUTE17,
IVS.ATTRIBUTE18 AS SC_ATTRIBUTE18,
IVS.ATTRIBUTE19 AS SC_ATTRIBUTE19,
IVS.ATTRIBUTE20 AS SC_ATTRIBUTE20,
IVS.ATTRIBUTE21 AS SC_ATTRIBUTE21,
IVS.ATTRIBUTE22 AS SC_ATTRIBUTE22,
IVS.ATTRIBUTE23 AS SC_ATTRIBUTE23,
IVS.ATTRIBUTE24 AS SC_ATTRIBUTE24,
IVS.ATTRIBUTE25 AS SC_ATTRIBUTE25,
IVS.ATTRIBUTE26 AS SC_ATTRIBUTE26,
IVS.ATTRIBUTE27 AS SC_ATTRIBUTE27,
IVS.ATTRIBUTE28 AS SC_ATTRIBUTE28,
IVS.ATTRIBUTE29 AS SC_ATTRIBUTE29,
IVS.ATTRIBUTE30 AS SC_ATTRIBUTE30,
IVS.ISC_INFORMATION_CATEGORY,
IVS.ISC_INFORMATION1,
IVS.ISC_INFORMATION2,
IVS.ISC_INFORMATION3,
IVS.ISC_INFORMATION4,
IVS.ISC_INFORMATION5,
IVS.ISC_INFORMATION6,
IVS.ISC_INFORMATION7,
IVS.ISC_INFORMATION8,
IVS.ISC_INFORMATION9,
IVS.ISC_INFORMATION10,
IVS.ISC_INFORMATION11,
IVS.ISC_INFORMATION12,
IVS.ISC_INFORMATION13,
IVS.ISC_INFORMATION14,
IVS.ISC_INFORMATION15,
IVS.ISC_INFORMATION16,
IVS.ISC_INFORMATION17,
IVS.ISC_INFORMATION18,
IVS.ISC_INFORMATION19,
IVS.ISC_INFORMATION20,
IVS.ISC_INFORMATION21,
IVS.ISC_INFORMATION22,
IVS.ISC_INFORMATION23,
IVS.ISC_INFORMATION24,
IVS.ISC_INFORMATION25,
IVS.ISC_INFORMATION26,
IVS.ISC_INFORMATION27,
IVS.ISC_INFORMATION28,
IVS.ISC_INFORMATION29,
IVS.ISC_INFORMATION30,
LOC.ADDRESS_LINE_1,
LOC.TOWN_OR_CITY,
LOC.POSTAL_CODE,
LOC.LOCATION_CODE,
(SELECT MIN (PRA2.DATE_END)
FROM PER_RECRUITMENT_ACTIVITY_FOR PRAF2,
IRC_ALL_RECRUITING_SITES IARS2,
PER_RECRUITMENT_ACTIVITIES PRA2
WHERE PRAF2.VACANCY_ID = PAV.VACANCY_ID
AND PRA2.RECRUITMENT_ACTIVITY_ID =
PRAF2.RECRUITMENT_ACTIVITY_ID
AND IARS2.RECRUITING_SITE_ID = PRA2.RECRUITING_SITE_ID
AND IARS2.EXTERNAL = ‘Y’)
AS EXTERNAL_SITE_DATE,
(SELECT MIN (PRA2.DATE_END)
FROM PER_RECRUITMENT_ACTIVITY_FOR PRAF2,
IRC_ALL_RECRUITING_SITES IARS2,
PER_RECRUITMENT_ACTIVITIES PRA2
WHERE PRAF2.VACANCY_ID = PAV.VACANCY_ID
AND PRA2.RECRUITMENT_ACTIVITY_ID =
PRAF2.RECRUITMENT_ACTIVITY_ID
AND IARS2.RECRUITING_SITE_ID = PRA2.RECRUITING_SITE_ID
AND IARS2.INTERNAL = ‘Y’)
AS INTERNAL_SITE_DATE,
CASE INSTR (HRL.MEANING, ‘Faculty -‘) WHEN 0 THEN ‘N’ ELSE ‘Y’ END
AS FACULTY_POSTING
FROM HR_LOOKUPS HRL,
HR_LOOKUPS HL2,
PER_ALL_VACANCIES PAV,
PER_RECRUITMENT_ACTIVITIES PRA,
PER_RECRUITMENT_ACTIVITY_FOR PRF,
IRC_POSTING_CONTENTS_VL IPC,
IRC_SEARCH_CRITERIA IVS,
HR_LOCATIONS_ALL_VL LOC,
HR_LOOKUPS HLW,
HR_LOOKUPS HLT,
IRC_ALL_RECRUITING_SITES_VL IAS
WHERE PAV.STATUS = ‘APPROVED’
AND PAV.VACANCY_ID = PRF.VACANCY_ID
AND PRF.RECRUITMENT_ACTIVITY_ID = PRA.RECRUITMENT_ACTIVITY_ID
AND PRA.POSTING_CONTENT_ID = IPC.POSTING_CONTENT_ID
AND PAV.VACANCY_ID = IVS.OBJECT_ID
AND IVS.OBJECT_TYPE = ‘VACANCY’
AND HRL.LOOKUP_TYPE(+) = ‘IRC_PROFESSIONAL_AREA’
AND IVS.PROFESSIONAL_AREA = HRL.LOOKUP_CODE(+)
AND HL2.LOOKUP_TYPE(+) = ‘IRC_EMP_CAT’
AND IVS.EMPLOYMENT_CATEGORY = HL2.LOOKUP_CODE(+)
AND HLW.LOOKUP_TYPE(+) = ‘IRC_WORK_AT_HOME’
AND IVS.WORK_AT_HOME = HLW.LOOKUP_CODE(+)
AND HLT.LOOKUP_TYPE(+) = ‘IRC_TRAVEL_PERCENTAGE’
AND IVS.TRAVEL_PERCENTAGE = HLT.LOOKUP_CODE(+)
AND :4 BETWEEN PRA.DATE_START AND NVL (PRA.DATE_END, :5)
AND LOC.LOCATION_ID(+) = PAV.LOCATION_ID
AND ( PAV.DATE_FROM <= :6
AND ( (PAV.DATE_TO IS NOT NULL AND PAV.DATE_TO >= :7)
OR (PAV.DATE_TO IS NULL)))
AND EXISTS
(SELECT 1
FROM PER_VACANCIES VAC1
WHERE VAC1.VACANCY_ID = PAV.VACANCY_ID)
AND PRA.RECRUITING_SITE_ID = IAS.RECRUITING_SITE_ID
AND :8 BETWEEN PRA.DATE_START AND NVL (PRA.DATE_END, :9)) QRSLT WHERE (ias.internal=’Y’ and HRL.LOOKUP_CODE in (:10) and (ivs.contractor = ‘Y’ or ivs.employee = ‘Y’)) ORDER BY DATE_START DESC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1196)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1465)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3084)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1914)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:559)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:441)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
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:429)
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:911)
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)
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: “IVS”.”EMPLOYEE”: invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4568)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.irc.candidateSelfService.webui.AplJobSearchCriteriaCO.processFormRequest(AplJobSearchCriteriaCO.java:414)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(OAHeaderBean.java:410)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OABorderLayoutBean.processFormRequest(OABorderLayoutBean.java:367)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1202)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3080)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1914)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:559)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:441)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
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:429)
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:911)
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)
java.sql.SQLSyntaxErrorException: ORA-00904: “IVS”.”EMPLOYEE”: invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4568)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.irc.candidateSelfService.webui.AplJobSearchCriteriaCO.processFormRequest(AplJobSearchCriteriaCO.java:414)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(OAHeaderBean.java:410)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OABorderLayoutBean.processFormRequest(OABorderLayoutBean.java:367)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(OAStackLayoutBean.java:370)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1202)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1055)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1021)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:876)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3080)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1914)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:559)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:441)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
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:429)
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:911)
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)