oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

Oracle Community | user12281793 | 5 years ago
  1. 0

    Error while opening Non-Catlog request in iprocurement

    Oracle Community | 5 years ago | user12281793
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  2. 0

    Oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation - webnetta.com

    webnetta.com | 3 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,        PoRequisitionLineEO.REQUISITION_HEADER_ID,        PoRequisitionLineEO.LINE_NUM,        PoRequisitionLineEO.LAST_UPDATE_DATE,        PoRequisitionLineEO.LAST_UPDATED_BY,        PoRequisitionLineEO.LAST_UPDATE_LOGIN,        PoRequisitionLineEO.CREATION_DATE,        PoRequisitionLineEO.CREATED_BY,        PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,        PoRequisitionLineEO.TO_PERSON_ID,        PoRequisitionLineEO.ITEM_DESCRIPTION,        PoRequisitionLineEO.CATEGORY_ID,        PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,        PoRequisitionLineEO.UNIT_PRICE,        PoRequisitionLineEO.QUANTITY,        PoRequisitionLineEO.LINE_TYPE_ID,        PoRequisitionLineEO.SOURCE_TYPE_CODE,        PoRequisitionLineEO.ITEM_ID,        PoRequisitionLineEO.ITEM_REVISION,        PoRequisitionLineEO.QUANTITY_DELIVERED,        PoRequisitionLineEO.SUGGESTED_BUYER_ID,        PoRequisitionLineEO.ENCUMBERED_FLAG,        PoRequisitionLineEO.RFQ_REQUIRED_FLAG,        PoRequisitionLineEO.NEED_BY_DATE,        PoRequisitionLineEO.LINE_LOCATION_ID,        PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,        PoRequisitionLineEO.PARENT_REQ_LINE_ID,        PoRequisitionLineEO.JUSTIFICATION,        PoRequisitionLineEO.NOTE_TO_AGENT,        PoRequisitionLineEO.NOTE_TO_RECEIVER,        PoRequisitionLineEO.PURCHASING_AGENT_ID,        PoRequisitionLineEO.DOCUMENT_TYPE_CODE,        PoRequisitionLineEO.BLANKET_PO_HEADER_ID,        PoRequisitionLineEO.BLANKET_PO_LINE_NUM,        PoRequisitionLineEO.CURRENCY_CODE,        PoRequisitionLineEO.RATE_TYPE,        /*PoRequisitionLineEO.RATE_DATE*/trunc(SYSDATE) rate_DATE,        /*PoRequisitionLineEO.RATE*/        (SELECT conversion_rate           FROM gl_daily_rates                ,hr_operating_units hou                ,gl_sets_of_books sob          WHERE from_currency = PoRequisitionLineEO.CURRENCY_CODE          AND to_currency = sob.currency_code          AND conversion_type = PoRequisitionLineEO.RATE_TYPE          AND conversion_date = trunc(SYSDATE)          AND  hou.organization_id = PoRequisitionLineEO.org_id           AND hou.set_of_books_id = sob.SET_OF_BOOKS_ID ) rate,        PoRequisitionLineEO.CURRENCY_UNIT_PRICE,        PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,        PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,        PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,        PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,        PoRequisitionLineEO.UN_NUMBER_ID,        PoRequisitionLineEO.HAZARD_CLASS_ID,        PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,        PoRequisitionLineEO.REFERENCE_NUM,        PoRequisitionLineEO.ON_RFQ_FLAG,        PoRequisitionLineEO.URGENT_FLAG,        PoRequisitionLineEO.CANCEL_FLAG,        PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,        PoRequisitionLineEO.SOURCE_SUBINVENTORY,        PoRequisitionLineEO.DESTINATION_TYPE_CODE,        PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,        PoRequisitionLineEO.DESTINATION_SUBINVENTORY,        PoRequisitionLineEO.QUANTITY_CANCELLED,        PoRequisitionLineEO.CANCEL_DATE,        PoRequisitionLineEO.CANCEL_REASON,        PoRequisitionLineEO.CLOSED_CODE,        PoRequisitionLineEO.AGENT_RETURN_NOTE,        PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,        PoRequisitionLineEO.VENDOR_ID,        PoRequisitionLineEO.VENDOR_SITE_ID,        PoRequisitionLineEO.VENDOR_CONTACT_ID,        PoRequisitionLineEO.RESEARCH_AGENT_ID,        PoRequisitionLineEO.ON_LINE_FLAG,        PoRequisitionLineEO.WIP_ENTITY_ID,        PoRequisitionLineEO.WIP_LINE_ID,        PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,        PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,        PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,        PoRequisitionLineEO.ATTRIBUTE_CATEGORY,        PoRequisitionLineEO.DESTINATION_CONTEXT,        PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,        PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,        PoRequisitionLineEO.BOM_RESOURCE_ID,        PoRequisitionLineEO.REQUEST_ID,        PoRequisitionLineEO.PROGRAM_APPLICATION_ID,        PoRequisitionLineEO.PROGRAM_ID,        PoRequisitionLineEO.PROGRAM_UPDATE_DATE,        PoRequisitionLineEO.USSGL_TRANSACTION_CODE,        PoRequisitionLineEO.GOVERNMENT_CONTEXT,        PoRequisitionLineEO.CLOSED_REASON,        PoRequisitionLineEO.CLOSED_DATE,        PoRequisitionLineEO.TRANSACTION_REASON_CODE,        PoRequisitionLineEO.QUANTITY_RECEIVED,        PoRequisitionLineEO.SOURCE_REQ_LINE_ID,        PoRequisitionLineEO.ORG_ID,        PoRequisitionLineEO.KANBAN_CARD_ID,        PoRequisitionLineEO.CATALOG_TYPE,        PoRequisitionLineEO.CATALOG_SOURCE,        PoRequisitionLineEO.MANUFACTURER_ID,        PoRequisitionLineEO.MANUFACTURER_NAME,        PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,        PoRequisitionLineEO.REQUESTER_EMAIL,        PoRequisitionLineEO.REQUESTER_FAX,        PoRequisitionLineEO.REQUESTER_PHONE,        PoRequisitionLineEO.UNSPSC_CODE,        PoRequisitionLineEO.OTHER_CATEGORY_CODE,        PoRequisitionLineEO.SUPPLIER_DUNS,        PoRequisitionLineEO.TAX_STATUS_INDICATOR,        PoRequisitionLineEO.PCARD_FLAG,        PoRequisitionLineEO.NEW_SUPPLIER_FLAG,        PoRequisitionLineEO.AUTO_RECEIVE_FLAG,        PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,        PoRequisitionLineEO.TAX_CODE_ID,        PoRequisitionLineEO.NOTE_TO_VENDOR,        PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,        PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,        PoRequisitionLineEO.ITEM_SOURCE_ID,        PoRequisitionLineEO.SUPPLIER_REF_NUMBER,        PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,        PoRequisitionLineEO.SECONDARY_QUANTITY,        PoRequisitionLineEO.PREFERRED_GRADE,        PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,        PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,        PoRequisitionLineEO.AUCTION_HEADER_ID,        PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,        PoRequisitionLineEO.AUCTION_LINE_NUMBER,        PoRequisitionLineEO.REQS_IN_POOL_FLAG,        PoRequisitionLineEO.VMI_FLAG,        PoRequisitionLineEO.ATTRIBUTE1,        PoRequisitionLineEO.ATTRIBUTE2,        PoRequisitionLineEO.ATTRIBUTE3,        PoRequisitionLineEO.ATTRIBUTE4,        PoRequisitionLineEO.ATTRIBUTE5,        PoRequisitionLineEO.ATTRIBUTE6,        PoRequisitionLineEO.ATTRIBUTE7,        PoRequisitionLineEO.ATTRIBUTE8,        PoRequisitionLineEO.ATTRIBUTE9,        PoRequisitionLineEO.ATTRIBUTE10,        PoRequisitionLineEO.ATTRIBUTE11,        PoRequisitionLineEO.ATTRIBUTE12,        PoRequisitionLineEO.ATTRIBUTE13,        PoRequisitionLineEO.ATTRIBUTE14,        PoRequisitionLineEO.ATTRIBUTE15,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,        PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,        PoRequisitionLineEO.BID_NUMBER,        PoRequisitionLineEO.BID_LINE_NUMBER,        PoRequisitionLineEO.AMOUNT,        PoRequisitionLineEO.CURRENCY_AMOUNT,        PoRequisitionLineEO.NONCAT_TEMPLATE_ID,        PoRequisitionLineEO.JOB_ID,        PoRequisitionLineEO.CONTACT_INFORMATION,        PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,        PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,        PoRequisitionLineEO.ASSIGNMENT_END_DATE,        PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,        PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,        PoRequisitionLineEO.LABOR_REQ_LINE_ID,        PoRequisitionLineEO.JOB_LONG_DESCRIPTION,        PoRequisitionLineEO.CONTRACTOR_STATUS,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,        PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,        PoRequisitionLineEO.CANDIDATE_FIRST_NAME,        PoRequisitionLineEO.CANDIDATE_LAST_NAME,        PoRequisitionLineEO.ASSIGNMENT_START_DATE,        PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,        PoRequisitionLineEO.PURCHASE_BASIS,        PoRequisitionLineEO.MATCHING_BASIS,        PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,        PoRequisitionLineEO.BASE_UNIT_PRICE,        PoRequisitionLineEO.AT_SOURCING_FLAG,        PoRequisitionLineEO.TAX_ATTRIBUTE_UPDATE_CODE,        PoRequisitionLineEO.DROP_SHIP_FLAG,        PoRequisitionLineEO.SHIP_METHOD,        PoRequisitionLineEO.ESTIMATED_PICKUP_DATE,        PoRequisitionLineEO.SUPPLIER_NOTIFIED_FOR_CANCEL,        PoRequisitionLineEO.TAX_NAME FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO) QRSLT  WHERE (nvl(closed_code, 'N') <> 'FINALLY CLOSED' AND nvl(cancel_flag, 'N') = 'N' AND nvl(modified_by_agent_flag, 'N') = 'N' AND line_location_id IS NULL AND ((SELECT nvl(transferred_to_oe_flag, 'N')      FROM po_requisition_headers_all h      WHERE h.requisition_header_id = PoRequisitionLineEO.requisition_header_id)      <> 'Y' OR      source_type_code = 'VENDOR')) AND REQUISITION_HEADER_ID = :1
  3. 0

    Missing class is not available-VO Extension

    Oracle Community | 2 years ago | 2837257
    oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.classloader.util.AnnotatedNoClassDefFoundError, msg= Missing class: xx.oracle.apps.icx.lov.server.xxReqCategoryVORowImpl (wrong name: oracle.apps.icx.lov.server.xxReqCategoryVORowImpl) Dependent class: xx.oracle.apps.icx.lov.server.xxReqCategoryVORowImpl Loader: oacore.root:0.0.0 Code-Source: /u01/app/SSPRJ/apps/apps_st/comn/java/classes/ Configuration: <library> in /u01/app/SSPRJ/apps/apps_st/comn/webapps/oacore/ The missing class is not available from any code-source or loader in the system.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OAException: java.lang.NullPointerException - OA Framework

    developer-works.com | 12 months ago
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    2 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

      java.lang.NullPointerException

      at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:975)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)
      3 frames
    3. oracle.apps.icx
      NonCatalogRequestCO.processRequest
      1. oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:964)
      2. oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:194)
      3. oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:112)
      4. oracle.apps.icx.icatalog.shopping.webui.NonCatalogRequestCO.processRequest(NonCatalogRequestCO.java:209)
      4 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2360)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      18 frames
    5. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:84)
      1 frame
    6. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    7. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    8. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    10. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame