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

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, 10 months 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, 1 year 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 oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
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 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.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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 6 days ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.