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 3521229, 10 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 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 _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)