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 SUDHIR BHILAR, 1 year ago
(+),:7)) and hl.lookup_type(+)='YES_NO' and hl.lookup_code(+)=nvl2(vg.valid_grade_id,'Y',(nvl2(to_number(:8),'N',''))) and hr_psf_shd.get_availability_status(pos.availability_status_id, pos.business_group_id)='ACTIVE' and exists (select 1 from
via Oracle Community by Cedric.Catalyst, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.12.12020000.14 2015/06/19 10:06:21 svedi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
via Oracle Community by 814480, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pc.competence_id ,pc.name ,pc.competence_alias as short_name ,pc.unit_standard_id ,qual_ctype.meaning credit_type ,pc.credits ,qual_level_type.meaning
via Oracle Community by Renu Gupta, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID
via Oracle Community by user621385, 2 years ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT paf1.full_name, paf1.last_name, paf1.first_name, paf1.email_address, nvl(paf1.employee_number,paf1.npw_number) AS employee_num
via Oracle Community by Bipin Behari Sethy, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT pos.NAME,         pos.POSITION_ID,         pos.EFFECTIVE_START_DATE,          pos.EFFECTIVE_END_DATE,         hl.MEANING AS valid_for_pos,          hl.LOOKUP_TYPE,         hl.LOOKUP_CODE,         vg.VALID_GRADE_ID,          pos.BUSINESS_GROUP_ID,         pos.JOB_ID,         pos.ORGANIZATION_ID FROM HR_ALL_POSITIONS_F_VL pos, PER_VALID_GRADES vg, HR_LOOKUPS hl WHERE pos.business_group_id = :1  and :2 between pos.effective_start_date and pos.effective_end_date and pos.organization_id=nvl(to_number(:3),pos.organization_id)  and pos.position_id=vg.position_id(+) and vg.grade_id(+)=:4  and :5 between (nvl(vg.date_from(+),:6)) and (nvl(vg.date_to(+),:7))  and hl.lookup_type(+)='YES_NO'  and hl.lookup_code(+)=nvl2(vg.valid_grade_id,'Y',(nvl2(to_number(:8),'N','')))  and hr_psf_shd.get_availability_status(pos.availability_status_id, pos.business_group_id)='ACTIVE'  and exists (select 1 from hr_positions_f pos_sec where pos_sec.position_id=pos.position_id) AND SUBSTR (POS.NAME, 1, 1) <> '4'        AND POS.POSITION_ID NOT IN               (SELECT DISTINCT B.POSITION_ID                  FROM PER_ALL_ASSIGNMENTS_F A, HR_ALL_POSITIONS_F B                 WHERE     ASSIGNMENT_TYPE = 'E'                       AND ASSIGNMENT_STATUS_TYPE_ID = 1                       AND PRIMARY_FLAG = 'Y'                       AND B.POSITION_ID = A.POSITION_ID                       AND B.POSITION_TYPE = 'SINGLE'                       AND ADD_MONTHS (SYSDATE, 3) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE                       AND SYSDATE BETWEEN B.EFFECTIVE_START_DATE                                       AND B.EFFECTIVE_END_DATE AND b.position_id NOT IN                              (SELECT ppi.position_id                                 FROM Per_Position_Extra_Info Ppi                                WHERE     Ppi.Information_Type = 'PER_OVERLAP'                                      AND SYSDATE BETWEEN TRUNC ( TO_DATE ( REPLACE (                                                                   Ppi.Poei_Information3, '0:', '1:'),                                                                'yyyy/mm/dd HH:MI:SS')) AND TRUNC ( TO_DATE ( REPLACE ( Ppi.Poei_Information4, '0:', '1:'),                                                                'yyyy/mm/dd HH:MI:SS')))) ORDER BY pos.name	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.processFormRequest(OAPageBean.java:3173)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1924)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)	at _pages.__oa._jspService(__oa.java:233)	at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)	at java.security.AccessController.doPrivileged(Native Method)	at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)	at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)	at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)	at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)	at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)	at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)