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

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, 1 year 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 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 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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week 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

Write tip

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