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

Oracle Community | Harrrry | 5 years ago
  1. 0

    Geting error while extinding the lov VO

    Oracle Community | 5 years ago | Harrrry
    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)))
  2. 0

    JBO-25005: Object name 1230_CONTEXT_VO for type View Object is invalid

    Oracle Community | 5 years ago | 882495
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 1230_CONTEXT_VO for type View Object is invalid
  3. 0

    VO Extension blows up

    Oracle Community | 5 years ago | 938291
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoObjException: JBO-25003: Object gallup.oracle.apps.ar.hz.components.contact.server of type ApplicationModule not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    VO extension looking for AM

    Oracle Community | 5 years ago | 938291
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoObjException: JBO-25003: Object gallup.oracle.apps.ar.hz.components.contact.server of type ApplicationModule not found
  6. 0

    VO Substitution error

    Oracle Community | 4 years ago | kumara23
    oracle.apps.fnd.framework.OAException: oracle.jbo.PersistenceException: JBO-26002: Error Parsing the XML file "/xxmas/oracle/apps/icx/por/wf/server/XXMASReqLinesNotificationVO.xml".

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2662)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      7 frames