oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

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

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    14 more bugmates