oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pos.position_id position_id ,business_group_id ,date_effective ,date_end ,postl.name name ,job_id ,organization_id ,NULL effective_date ,status ,effective_start_date ,effective_end_date ,availability_status_id,attribute5 FROM hr_all_positions_f pos ,hr_all_positions_f_tl postl where pos.position_id = postl.position_id(+) AND postl.language(+)= userenv('LANG')) QRSLT WHERE (business_group_id = :1 and (to_date( :2 , 'RRRR/MM/DD') between effective_start_date and effective_end_date ) and organization_id = :3 and job_id = :4 and (status is NULL or status = 'VALID') and availability_status_id in (select shared_type_id from PER_SHARED_TYPES where lookup_type='POSITION_AVAILABILITY_STATUS' and system_type_cd='ACTIVE') and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS', POSITION_ID)) ='TRUE' and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID)) ='TRUE' AND ( UPPER(NAME) like UPPER(:5) AND (NAME like :6 OR NAME like :7 OR NAME like :8 OR NAME like :9))) ORDER BY 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 1761829, 1 year ago
(business_group_id = :1 and (to_date( :2 , 'RRRR/MM/DD') between effective_start_date and effective_end_date ) and organization_id = :3 and job_id = :4 and (status is NULL or status = 'VALID') and availability_status_id in (select shared_type_id from
via Oracle Community by user444732, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select peg.name , paf.assignment_number from per_grades peg ,per_grade_definitions pgd ,per_all_assignments_f paf where pgd.grade_definition_id
via Oracle Community by user632699, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'N' as select1, substr(:1,1,15) as Site_Name, organization_id, name,:2 as Site_Name_Display from hr_operating_units WHERE mo_global.check_access(organization_id) = 'Y') QRSLT ORDER BY name
via Oracle Community by 5a1630f0-0de2-490c-91db-6d734cee73a4, 3 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select ItemDescription, ItemNumber, ProductNumber, SerialNumber, null LotNumber, SystemName, null ExternalReference, InstanceStatusName, Quantity, OwnerName
via blogspot.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.   Statement: SELECT * FROM (SELECT ca.location LocId, ca.party_site_number LocNumber, ca.party_name PartyName, ca.party_number PartyNumber, ca.address1 Address1
via Oracle Community by Tarun Prakash, 1 year ago
oracle.jbo.InvalidObjNameException: JBO-25005: Object name 2 for type Variable is invalid
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pos.position_id position_id ,business_group_id ,date_effective ,date_end ,postl.name name ,job_id ,organization_id ,NULL effective_date ,status ,effective_start_date ,effective_end_date ,availability_status_id,attribute5 FROM hr_all_positions_f pos ,hr_all_positions_f_tl postl where pos.position_id = postl.position_id(+) AND postl.language(+)= userenv('LANG')) QRSLT WHERE (business_group_id = :1 and (to_date( :2 , 'RRRR/MM/DD') between effective_start_date and effective_end_date ) and organization_id = :3 and job_id = :4 and (status is NULL or status = 'VALID') and availability_status_id in (select shared_type_id from PER_SHARED_TYPES where lookup_type='POSITION_AVAILABILITY_STATUS' and system_type_cd='ACTIVE') and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS', POSITION_ID)) ='TRUE' and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID)) ='TRUE' AND ( UPPER(NAME) like UPPER(:5) AND (NAME like :6 OR NAME like :7 OR NAME like :8 OR NAME like :9))) ORDER BY 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:3000)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1884)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)
at undefined._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.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)

Users with the same issue

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
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

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