oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pj.name AS PROJECT, pj.project_id, custs_assigned.party_id AS PartyId from ar_customers_assigned_v custs_assigned, hz_cust_accounts cust, pa_projects pj, pa_project_customers ppc where custs_assigned.party_id = :1 and ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = custs_assigned.cust_account_id union select distinct pj.name AS PROJECT, pj.project_id, cust.party_id AS PartyId from hz_cust_accounts cust, ar_sites_assigned_v sites_assigned, pa_projects pj, pa_project_customers ppc where ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = sites_assigned.cust_account_id and cust.party_id = :2) QRSLT WHERE (( PROJECT_ID = :3 AND UPPER(PROJECT) like UPPER(:4) AND (PROJECT like :5 OR PROJECT like :6 OR PROJECT like :7 OR PROJECT like :8)))

Oracle Community | oraclepro73 | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    formValue passed to LOV and back to calling Page gets reset to NULL

    Oracle Community | 4 years ago | oraclepro73
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pj.name AS PROJECT, pj.project_id, custs_assigned.party_id AS PartyId from ar_customers_assigned_v custs_assigned, hz_cust_accounts cust, pa_projects pj, pa_project_customers ppc where custs_assigned.party_id = :1 and ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = custs_assigned.cust_account_id union select distinct pj.name AS PROJECT, pj.project_id, cust.party_id AS PartyId from hz_cust_accounts cust, ar_sites_assigned_v sites_assigned, pa_projects pj, pa_project_customers ppc where ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = sites_assigned.cust_account_id and cust.party_id = :2) QRSLT WHERE (( PROJECT_ID = :3 AND UPPER(PROJECT) like UPPER(:4) AND (PROJECT like :5 OR PROJECT like :6 OR PROJECT like :7 OR PROJECT like :8)))
  2. 0

    LOV query with bind variable

    Oracle Community | 10 years ago | 574833
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
  3. 0

    Problem with table in table implementation

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

    Automated exception search integrated into your IDE

  5. 0

    Problem with messageLovChoice

    Oracle Community | 9 years ago | 605963
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    Help needed in Table in Table Approach using OAF

    Oracle Community | 8 years ago | 669809
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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 distinct pj.name AS PROJECT, pj.project_id, custs_assigned.party_id AS PartyId from ar_customers_assigned_v custs_assigned, hz_cust_accounts cust, pa_projects pj, pa_project_customers ppc where custs_assigned.party_id = :1 and ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = custs_assigned.cust_account_id union select distinct pj.name AS PROJECT, pj.project_id, cust.party_id AS PartyId from hz_cust_accounts cust, ar_sites_assigned_v sites_assigned, pa_projects pj, pa_project_customers ppc where ppc.customer_id = cust.cust_account_id and ppc.project_id = pj.project_id --and pj.org_id = 44 and cust.cust_account_id = sites_assigned.cust_account_id and cust.party_id = :2) QRSLT WHERE (( PROJECT_ID = :3 AND UPPER(PROJECT) like UPPER(:4) AND (PROJECT like :5 OR PROJECT like :6 OR PROJECT like :7 OR PROJECT like :8)))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames