Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by Pradeep Navin Kumar, 1 year ago
, Job.NAME AS JOB_NAME, Offer.OFFER_STATUS, Offer.LATEST_OFFER, (SELECT max (status_change_date) FROM irc_offer_status_history StatusHistory1 WHERE StatusHistory1.offer_id = Offer.offer_id and StatusHistory1.offer_status ='APPROVED
via Oracle Community by user961956, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.icx.por.wf.server.ReqApprovalNotificationsAM of type ApplicationModule not found
via Oracle Community by 1648343, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.po.notifications.server.PONotifAM of type ApplicationModule not found
via Oracle Community by user13348924, 1 year ago
oracle.jbo.NameClashException: JBO-25001: Name LOV_oracle_apps_wip_transaction_server_ComponentAM of object type ApplicationModule already exists
via Oracle Community by 933794, 1 year ago
oracle.jbo.CustomClassNotFoundException: JBO-26022: Could not find and load the custom class oracle.apps.icx.por.req.server.PoEndecaBwcProcplanVOImpl
via Oracle Community by user8921798, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: Erreur SQL lors de la préparation d'une instruction. Instruction : select VENDOR_ID , VENDOR_NAME from AP_SUPPLIERS where 1=1 and vendor_id = :1 WHERE (( UPPER(VENDOR_NAME) like UPPER(:1) AND (VENDOR_NAME like :2 OR VENDOR_NAME like :3 OR VENDOR_NAME like :4 OR VENDOR_NAME like :5)))
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT Offer.OFFER_ID,        Offer.OFFER_VERSION,        Offer.LAST_UPDATE_DATE,        Offer.CREATION_DATE,        Vac.VACANCY_ID,        Vac.NAME,        Job.JOB_ID,        Recruiter.FULL_NAME,        Recruiter.PERSON_ID,        Recruiter.EFFECTIVE_START_DATE,        Recruiter.EFFECTIVE_END_DATE,        Recruiter.EMAIL_ADDRESS,        Status.LOOKUP_TYPE,        Status.LOOKUP_CODE,        Manager.EMAIL_ADDRESS AS EMAIL_ADDRESS1, Manager.EMPLOYEE_NUMBER, Manager.PERSON_ID AS PERSON_ID1, Manager.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE1,         Manager.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE1,        Manager.FULL_NAME AS FULL_NAME1,        Job.NAME AS JOB_NAME,        Offer.OFFER_STATUS,        Offer.LATEST_OFFER,        (SELECT max (status_change_date) FROM irc_offer_status_history StatusHistory1 WHERE StatusHistory1.offer_id = Offer.offer_id and StatusHistory1.offer_status ='APPROVED') AS OFFER_APPROVED_DATE, Offer.EXPIRY_DATE, Applicant.FULL_NAME AS FULL_NAME2, Applicant.PERSON_ID AS PERSON_ID2, Applicant.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE2,         Applicant.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE2, decode(Offer.offer_status,'PENDING','T','CORRECTION','T','APPROVED',nvl((select          update_allowed from irc_rec_team_members rec where rec.vacancy_id          = vac.vacancy_id and rec.person_id = :1 and irc_utilities_pkg.is_function_allowed          ('IRC_UPDATE_APPROVED_OFFER') = 'TRUE'),'T'),'F') AS PREVIEW_ENABLED, Status.MEANING, ASG.ASSIGNMENT_ID, ASG.EFFECTIVE_START_DATE AS ASG_EFFECTIVE_START_DATE,         ASG.EFFECTIVE_END_DATE AS ASG_EFFECTIVE_END_DATE, to_char(RowNum) AS RowNumber, Applicant.APPLICANT_NUMBER, Reason.MEANING AS MEANING1, Offer.OBJECT_VERSION_NUMBER, Reason.LOOKUP_TYPE AS LOOKUP_TYPE1,        Reason.LOOKUP_CODE AS LOOKUP_CODE1,        Offer.ATTRIBUTE1,        Offer.ATTRIBUTE2,        Offer.ATTRIBUTE3,        Offer.ATTRIBUTE4,        Offer.ATTRIBUTE5,        Offer.ATTRIBUTE6,        Offer.ATTRIBUTE7,        Offer.ATTRIBUTE8,        Offer.ATTRIBUTE9,        Offer.ATTRIBUTE10,        Offer.ATTRIBUTE11,        Offer.ATTRIBUTE12,        Offer.ATTRIBUTE13,        Offer.ATTRIBUTE14,        Offer.ATTRIBUTE15,        Offer.ATTRIBUTE16,        Offer.ATTRIBUTE17,        Offer.ATTRIBUTE18,        Offer.ATTRIBUTE19,        Offer.ATTRIBUTE20,        Offer.ATTRIBUTE21,        Offer.ATTRIBUTE22,        Offer.ATTRIBUTE23,        Offer.ATTRIBUTE24,        Offer.ATTRIBUTE25,        Offer.ATTRIBUTE26,        Offer.ATTRIBUTE27,        Offer.ATTRIBUTE28,        Offer.ATTRIBUTE29,        Offer.ATTRIBUTE30,        Vac.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1, AST.USER_STATUS, Recruiter.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER2,         ASG.CHANGE_REASON,        Manager.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER3,         (SELECT meaning   FROM   hr_lookups hl     WHERE hl.lookup_type = 'APL_ASSIGN_REASON' AND hl.lookup_code = IAS.STATUS_CHANGE_REASON  ) AS APPL_STATUS_CHANGE_REASON,        AST.ASSIGNMENT_STATUS_TYPE_ID,        Offer.ATTRIBUTE_CATEGORY,        ASG.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER4, Vac.BUSINESS_GROUP_ID, Applicant.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER5,         Bg.NAME AS NAME1,        Bg.ORGANIZATION_ID,        (select Meaning     from hr_lookups     where lookup_type = 'IRC_CANDIDATE_TYPE'     and lookup_code =  NVL( (SELECT 'EMP'      FROM DUAL   WHERE EXISTS            (SELECT NULL             FROM PER_ALL_PEOPLE_F PPF11,                   PER_ALL_PEOPLE_F PPF12,       PER_PERSON_TYPES PPT             WHERE PPF11.PERSON_ID = ASG.PERSON_ID               AND PPF11.PARTY_ID = PPF12.PARTY_ID AND TRUNC(SYSDATE) BETWEEN PPF12.EFFECTIVE_START_DATE AND PPF12.EFFECTIVE_END_DATE AND PPF12.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID               AND PPT.SYSTEM_PERSON_TYPE IN ('EMP', 'EMP_APL')           )   ), NVL(     (SELECT 'EX_EMP'        FROM DUAL       WHERE EXISTS               (SELECT NULL                 FROM PER_ALL_PEOPLE_F PPF21,      PER_ALL_PEOPLE_F PPF22,                      PER_PERSON_TYPES PPT    WHERE PPF21.PERSON_ID = ASG.PERSON_ID              AND PPF21.PARTY_ID = PPF22.PARTY_ID      AND TRUNC(SYSDATE) BETWEEN PPF22.EFFECTIVE_START_DATE AND PPF22.EFFECTIVE_END_DATE                  AND PPF22.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID                  AND PPT.SYSTEM_PERSON_TYPE IN ('EX_EMP', 'EX_EMP_APL')              )     ), 'EXT' ))) AS CANDIDATE_TYPE, (select hl5.Meaning     from hr_lookups hl5   where lookup_type   = 'YES_NO'     and lookup_code           = decode(        ( SELECT 1                     FROM per_all_assignments_f paf2, per_all_people_f ppf2, per_all_people_f ppf21 WHERE ppf2.person_id = asg.person_id                     and ppf2.party_id = ppf21.party_id                     and trunc(sysdate) between ppf21.effective_start_date  and ppf21.effective_end_date and ppf21.person_id = paf2.supervisor_id                 and trunc(sysdate) between paf2.effective_start_date and paf2.effective_end_date              and  paf2.ASSIGNMENT_TYPE IN ('E','C')            AND rownum = 1   ), 1, 'Y', 'N'             ) and irc_utilities_pkg.is_internal_person(asg.person_id ,trunc(sysdate)) = 'TRUE') AS DIRECT_REPORTS, Applicant.PARTY_ID,        (select lookup_code from hr_lookups where lookup_type = 'IRC_REHIRE_RECOMMENDATION' and lookup_code = 'NOT_APPLICABLE') AS VIEW_ATTR,        PROPOSED_START_DATE AS PROPOSED_START_DATE FROM IRC_OFFERS Offer, PER_ALL_VACANCIES Vac, PER_JOBS_VL Job, PER_ALL_PEOPLE_F Recruiter, PER_ALL_PEOPLE_F Manager, HR_LOOKUPS Status, PER_ALL_ASSIGNMENTS_F ASG, PER_ALL_PEOPLE_F Applicant, HR_LOOKUPS Reason, IRC_OFFER_STATUS_HISTORY ioh, IRC_ASSIGNMENT_STATUSES IAS, PER_ASSIGNMENT_STATUS_TYPES_V AST, HR_ALL_ORGANIZATION_UNITS_VL Bg, PER_ALL_ASSIGNMENTS_F asg4 WHERE Offer.vacancy_id = Vac.vacancy_id  and Vac.Recruiter_id = Recruiter.PERSON_ID(+) and :2 between nvl(Recruiter.EFFECTIVE_START_DATE,:3) and nvl(Recruiter.EFFECTIVE_END_DATE, :4) and Vac.Manager_id = Manager.PERSON_ID(+) and   :5 between nvl(Manager.EFFECTIVE_START_DATE,:6) and nvl(Manager.EFFECTIVE_END_DATE,:7) and Status.LOOKUP_TYPE(+) = 'IRC_OFFER_STATUSES' and Offer.Offer_Status = Status.LOOKUP_CODE(+) And Offer.LATEST_OFFER = 'Y' and offer.applicant_assignment_id = asg.assignment_id and asg.person_id = applicant.person_id and :8 between nvl(applicant.EFFECTIVE_START_DATE,:9) and nvl(applicant.EFFECTIVE_END_DATE, :10) and asg.effective_start_date=(select max(effective_start_date)  from per_all_assignments_f asg2  where asg.assignment_id=asg2.assignment_id  and asg2.effective_start_date<=:11) AND EXISTS (SELECT NULL FROM PER_PEOPLE_F ppfs WHERE ppfs.person_id = applicant.person_id) AND exists (select null from per_vacancies pvacs where pvacs.vacancy_id = vac.vacancy_id) and reason.LOOKUP_TYPE(+) = 'IRC_OFFER_STATUS_CHANGE_REASON' and Offer.Offer_Status = Status.LOOKUP_CODE(+)   and ioh.change_reason = reason.lookup_code(+) and ioh.offer_id =offer.offer_id AND NOT EXISTS (SELECT 1 FROM irc_offer_status_history iosh1 WHERE iosh1.offer_id = ioh.offer_id AND iosh1.status_change_date > ioh.status_change_date) AND ioh.offer_status_history_id = (SELECT MAX(iosh2.offer_status_history_id) FROM irc_offer_status_history iosh2 WHERE iosh2.offer_id = ioh.offer_id AND iosh2.status_change_date = ioh.status_change_date) AND ASG.ASSIGNMENT_ID =IAS.ASSIGNMENT_ID       AND IAS.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID(+)       AND NOT EXISTS          (SELECT 1                                    FROM    irc_assignment_statuses ias2                                    WHERE   ias2.assignment_id             = asg.assignment_id                                        AND TRUNC(ias2.status_change_date) > TRUNC(ias.status_change_date))       AND ias.last_update_date =          (SELECT MAX(ias3.last_update_date) FROM    irc_assignment_statuses ias3 WHERE   ias3.assignment_id             = asg.assignment_id                                                    AND TRUNC(ias3.status_change_date) = TRUNC(ias.status_change_date)) and Vac.BUSINESS_GROUP_ID = Bg.ORGANIZATION_ID AND EXISTS ( SELECT  NULL FROM per_assignments_f asg3 WHERE asg.assignment_id = asg3.assignment_id ) AND     offer.offer_assignment_id = asg4.assignment_id AND     asg4.person_id = applicant.person_id AND     asg4.job_id = job.job_id AND asg4.effective_start_date = (         SELECT  max (effective_start_date)         FROM per_all_assignments_f asg5 WHERE   asg4.assignment_id = asg5.assignment_id         AND     asg5.effective_start_date <= :12         ) AND (( UPPER(Vac.NAME)  like UPPER(:1) AND (Vac.NAME  like :2 OR Vac.NAME  like  :3 OR Vac.NAME  like :4 OR Vac.NAME  like  :5))) ORDER BY Applicant.FULL_NAME ASC	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2675)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)	at _OA._jspService(_OA.java:212)	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)	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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)	at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)	at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)	at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)	at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)	at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)	at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)	at _OA._jspService(_OA.java:221)	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)	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:318)	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)	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)