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.

  • LOV query with bind variable
    via by 574833,
  • Problem with messageLovChoice
    via by 605963,
  • Search and Select
    via by 792224,
  • How to Handle oracle.jbo.SQLStmtException Exception
    via by HaroonAfridi,
    • 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(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

    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