oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.

Oracle Community | elcaro | 3 years ago
  1. 1

    Extended VO errors after upgrading to 12.1.3

    Oracle Community | 3 years ago | elcaro
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.
  2. 0

    : Missing IN or OUT parameter at index:: 8 at

    Oracle Community | 5 years ago | 802240
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, paa.date_start, paa.date_end, paa.absence_days, paat.name, paat.absence_attendance_type_id, paa.absence_attendance_id abs_attd_id, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),AbsAdjHeaderEO.status,'Actioned') Disp_Status, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),decode( AbsAdjHeaderEO.status,'Awaiting Manager Approval',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0),'Submitted',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0), 0),1) Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCES paa, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE paa.absence_attendance_type_id=paat.absence_attendance_type_id and AbsAdjHeaderEO.CUR_ABS_ATTD_ID(+) = paa.absence_attendance_id and ((paa.person_id=:1 and paa.date_start between :2 and nvl(:3,sysdate) and paa.date_end between :4 and nvl(:5,sysdate) and paa.ABSENCE_ATTENDANCE_TYPE_ID=nvl(:6,paa.ABSENCE_ATTENDANCE_TYPE_ID)) or paa.absence_attendance_id=:7) and nvl(paa.date_end,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) union SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, AbsAdjHeaderEO.CUR_ABS_START_DATE date_start, AbsAdjHeaderEO.CUR_ABS_END_DATE date_end, AbsAdjHeaderEO.CUR_ABS_DURATION absence_days, paat.name name, null absence_attendance_type_id, null abs_attd_id, 'Actioned' Disp_Status, 1 Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE AbsAdjHeaderEO.CUR_ABS_TYPE_ID=paat.absence_attendance_type_id and ((AbsAdjHeaderEO.EMP_ID=:1 and AbsAdjHeaderEO.CUR_ABS_START_DATE between :2 and nvl(:3,sysdate) and AbsAdjHeaderEO.CUR_ABS_END_DATE between :4 and nvl(:5,sysdate) and AbsAdjHeaderEO.CUR_ABS_TYPE_ID=nvl(:6,AbsAdjHeaderEO.CUR_ABS_TYPE_ID)) or AbsAdjHeaderEO.CUR_ABS_ATTD_ID=:7) and nvl(AbsAdjHeaderEO.CUR_ABS_END_DATE,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) and not exists (select 1 from PER_ABSENCE_ATTENDANCES where absence_attendance_id=AbsAdjHeaderEO.CUR_ABS_ATTD_ID)) QRSLT ORDER BY CUR_ABS_START_DATE,CUR_ABS_END_DATE
  3. 0

    SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :1 and PO_RELEASE_ID = :2)) ORDER BY LINE_NUM
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-00604: error occurred at recursive SQL level 2;

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, DECODE (pol.po_line_id, pol.line_num), 0, NULL, '@' ) archived_attachment FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM
  6. 0

    EO Substitution

    Oracle Community | 1 decade ago | 542163
    oracle.apps.fnd.framework.OAException: oracle.jbo.PersistenceException: JBO-26038: Cannot find an entity usage for entity Perc2382PerQualificationsEOEx in view link definition IrcCandidateEduQualVL, view link end IrcCandidateEduQualVO.

    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.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAViewObjectImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1136)
      6 frames
    3. oracle.apps.icx
      VrcDetCO.processRequest
      1. oracle.apps.icx.por.rcv.webui.VrcDetCO.processRequest(VrcDetCO.java:78)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      18 frames
    5. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    6. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    7. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    9. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    10. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    11. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    12. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    13. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    14. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    16. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    17. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    18. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    19. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    20. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    21. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    22. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame