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

Oracle Community | 1761829 | 3 years ago
  1. 0

    Sql exception/error while extending standard view object - oracle.apps.per.selfservice.deployperson.PositionLovVO

    Oracle Community | 3 years ago | 1761829
    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
  2. 0

    Daniel Borgstrom talking about Oracle: Fix for java.sql.SQLException: Invalid column type when extending a VO

    blogspot.com | 3 months ago
    oracle.apps.fnd.framework.OAException: 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, ca.address2 Address2, ca.address3 Address3, ca.address4 Address4, ca.city City, ca.state State, ca.zip PostalCode, ca.country Country, ca.party_id partyId, hzp.site_use_type CurrSiteUsage FROM csi_hzpty_addresses_v ca, hz_party_site_uses hzp, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE ca.party_id = :1 AND ca.location = hzp.party_site_id(+) AND site_use_type(+) = 'INSTALL_AT' AND ca.status = 'A' AND SYSDATE BETWEEN NVL(ca.start_date_active, SYSDATE) AND NVL(ca.end_date_active, SYSDATE) AND hzp.status(+) = 'A' AND ca.location = hcas.party_site_id AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id AND hcsu.status = 'A' AND hcsu.site_use_code = 'SHIP_TO' AND hcas.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcas.org_id) AND hcsu.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcsu.org_id)) QRSLT WHERE (( UPPER(ADDRESS1) like UPPER(:2) AND (ADDRESS1 like :3 OR ADDRESS1 like :4 OR ADDRESS1 like :5 OR  ADDRESS1 like :6)))
  3. 0

    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at

    Oracle Community | 6 years ago | 779216
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    oracle.jbo.NoDefException: JBO-25058: Definition ColumnName of type Attribute not found in NameOfVO1

    Oracle Community | 3 years ago | user5803804
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition CustomerName of type Attribute not found in CustNameLovVO1
  6. 0

    Could not load application module error in EBS 12.0.6 / JDev 10.1.3.3

    Oracle Community | 5 years ago | elcaro
    oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.icx.por.rcv.server.ReceivingHomeAM'.

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3000)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1884)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)
      7 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    8. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    9. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    10. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    11. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    12. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    13. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    14. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame