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

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 oraclepro73, 1 year ago
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
via Oracle Community by 743539, 1 year ago
and pvg.job_id = :1 union all select distinct pg.name grade_name, pg.grade_id, 'No' valid_for_grade from per_grades pg where not exists (select pvg.job_id from per_valid_grades pvg where pg.grade_id = pvg.grade_id and pvg.job_id = :1)) QRSLT WHERE (( UPPER(GRADE_NAME) like UPPER(:1) AND (GRADE_NAME like :2 OR GRADE_NAME like :3 OR GRADE_NAME like :4 OR GRADE_NAME like :5)))
via Oracle Community by 741371, 1 year ago
= jrgt.GROUP_ID AND jrre.resource_id = jrrr.role_resource_id AND jrrr.role_id = jrrb.role_id AND jrgt.group_name = xsts.xo2c_entering_unit AND jrgt.LANGUAGE = 'US' AND jrrb.role_code = 'USS_CSR' AND xsts.xo2c_entering_unit like NVL(:1,'%')) QRSLT WHERE (( UPPER(SOURCE_NAME) like :2 AND (SOURCE_NAME like :3 OR SOURCE_NAME like :4 OR SOURCE_NAME like :5 OR SOURCE_NAME like :6)))
via Oracle Community by 574833, 1 year ago
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)))
via Oracle Community by 713492, 1 year ago
AND msi.primary_uom_code = muc.uom_code AND msi.organization_id = :1) QRSLT WHERE (( CATEGORY_ID = :2 AND UPPER(UOM) = :3 AND (UOM like :4 OR UOM like :5 OR UOM like :6 OR UOM like :7)AND UPPER(ITEM_DESC) = :8 AND (ITEM_DESC like :9 OR ITEM_DESC
via Oracle Community by 901919, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT competence_id, step_value || ' - ' || name step_value FROM per_competence_levels_v) QRSLT WHERE (COMPETENCE_ID = :1 AND ( UPPER(STEP_VALUE) like UPPER(:2) AND (STEP_VALUE like :3 OR STEP_VALUE like :4 OR STEP_VALUE like :5 OR STEP_VALUE like :6)))
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.