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

Solutions on the web1386

  • via Oracle Community by Harrrry, 11 months 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 user621385, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT paf1.full_name, paf1.last_name, paf1.first_name, paf1.email_address, nvl(paf1.employee_number,paf1.npw_number) AS employee_num
  • via Oracle Community by 648384, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoVendors.VENDOR_ID AS SUPPLIER_ID, PoVendorSitesAll.VENDOR_SITE_ID AS SUPPLIER_SITE_ID, PoVendorContacts.VENDOR_CONTACT_ID AS
  • Stack trace

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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates