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 Harrrry, 1 year ago
hrl, hr_locations_all_tl hrlt, org_organization_definitions ood, per_all_people_f papf WHERE hrl.location_id = hrlt.location_id and hrlt.language = :6 and ood.organization_id = hrl.inventory_organization_id and ood.set_of_books_id = :7 and sysdate
via Oracle Community by 680883, 2 years ago
= hrat.location_id and hrat.language = userenv('LANG') and (hrl.business_group_id is null or hrl.business_group_id = :3) and pkg_xxx_ss_ext.fn_display_loc(:asg,to_date(:1,'RRRR/MM/DD'),hrl.location_id)='Y') QRSLT WHERE (( UPPER(LOCATION_CODE) like :4 AND (LOCATION_CODE like :5 OR LOCATION_CODE like :6 OR LOCATION_CODE like :7 OR LOCATION_CODE like :8)))
via Oracle Community by oraclepro73, 1 year ago
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
via Oracle Community by 741371, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT jrre.source_name, jrgm.group_member_id, xsts.xo2c_entering_unit entering_unit FROM jtf_rs_resource_extns jrre
via Oracle Community by 907821, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select po_header_id,line_num from po_lines_all) QRSLT WHERE (PO_HEADER_ID =:1 AND ( LINE_NUM like :2 ))
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hrlt.location_code || ' (' || ood.organization_code || ')' as location_display,
PO_POAPPROVAL_INIT1.Get_Formatted_Address(hrl.location_id) as address,
hrlt.description as description,
hrlt.location_code as location_code,
hrl.location_id as location_id,
ood.organization_id as deliver_to_org_id,
ood.organization_code as organization_code,
papf.full_name as contact
FROM hr_locations_all hrl,
hr_locations_all_tl hrlt,
org_organization_definitions ood,
per_all_people_f papf
WHERE hrl.location_id = hrlt.location_id
and hrlt.language = :6
and ood.organization_id = hrl.inventory_organization_id
and ood.set_of_books_id = :7
and sysdate < nvl(hrl.inactive_date, sysdate + 1)
and trunc(sysdate) < nvl(ood.disable_date, trunc(sysdate + 1))
and (hrl.business_group_id is null or
hrl.business_group_id = :8)
and hrl.location_id <> nvl(:9, -1)
and hrl.designated_receiver_id = papf.person_id(+)
and trunc(sysdate) between
nvl(papf.effective_start_date, trunc(sysdate-1)) and           nvl(papf.effective_end_date,trunc(sysdate+1))
and ood.organization_id = hrl.inventory_organization_id
and ood.organization_id IN( SELECT oav.organization_id from org_access_v oav
WHERE oav.responsibility_id = FND_PROFILE.VALUE('RESP_ID')
and oav.resp_application_id =FND_PROFILE.VALUE('RESP_APPL_ID'))) QRSLT WHERE (( UPPER(LOCATION_CODE) like UPPER(:10) AND (LOCATION_CODE like :11 OR LOCATION_CODE like :12 OR LOCATION_CODE like :13 OR LOCATION_CODE like :14)))	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.processRequest(OAPageBean.java:2662)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)