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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

  • via Unknown by 2899825,
  • via Unknown by Cedric.Catalyst,
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates