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

Oracle Community | 2899825 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    EO extension in Oracle Sales online dashbourd

    Oracle Community | 2 years ago | 2899825
    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.

    Oracle Community | 2 years ago | SUDHIR BHILAR
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pos.NAME, pos.POSITION_ID, pos.EFFECTIVE_START_DATE, pos.EFFECTIVE_END_DATE, hl.MEANING AS valid_for_pos, hl.LOOKUP_TYPE, hl.LOOKUP_CODE, vg.VALID_GRADE_ID, pos.BUSINESS_GROUP_ID, pos.JOB_ID, pos.ORGANIZATION_ID FROM HR_ALL_POSITIONS_F_VL pos, PER_VALID_GRADES vg, HR_LOOKUPS hl WHERE pos.business_group_id = :1 and :2 between pos.effective_start_date and pos.effective_end_date and pos.organization_id=nvl(to_number(:3),pos.organization_id) and pos.position_id=vg.position_id(+) and vg.grade_id(+)=:4 and :5 between (nvl(vg.date_from(+),:6)) and (nvl(vg.date_to(+),:7)) and hl.lookup_type(+)='YES_NO' and hl.lookup_code(+)=nvl2(vg.valid_grade_id,'Y',(nvl2(to_number(:8),'N',''))) and hr_psf_shd.get_availability_status(pos.availability_status_id, pos.business_group_id)='ACTIVE' and exists (select 1 from hr_positions_f pos_sec where pos_sec.position_id=pos.position_id) AND SUBSTR (POS.NAME, 1, 1) <> '4' AND POS.POSITION_ID NOT IN (SELECT DISTINCT B.POSITION_ID FROM PER_ALL_ASSIGNMENTS_F A, HR_ALL_POSITIONS_F B WHERE ASSIGNMENT_TYPE = 'E' AND ASSIGNMENT_STATUS_TYPE_ID = 1 AND PRIMARY_FLAG = 'Y' AND B.POSITION_ID = A.POSITION_ID AND B.POSITION_TYPE = 'SINGLE' AND ADD_MONTHS (SYSDATE, 3) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND SYSDATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE AND b.position_id NOT IN (SELECT ppi.position_id FROM Per_Position_Extra_Info Ppi WHERE Ppi.Information_Type = 'PER_OVERLAP' AND SYSDATE BETWEEN TRUNC ( TO_DATE ( REPLACE ( Ppi.Poei_Information3, '0:', '1:'), 'yyyy/mm/dd HH:MI:SS')) AND TRUNC ( TO_DATE ( REPLACE ( Ppi.Poei_Information4, '0:', '1:'), 'yyyy/mm/dd HH:MI:SS')))) ORDER BY pos.name
  3. 0

    Error when i want to create a Resource

    Oracle Community | 1 month ago | Cedric.Catalyst
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.12.12020000.14 2015/06/19 10:06:21 svedi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID , FLEX_T0_0.VENDOR_NAME FLEX_DISPLAY0 , fnd_flex_server.get_concatenated_value( , :SEGMENT_COUNT , FLEX_T0_0.VENDOR_NAME ) FLEX_CONCATENATED_DISPLAY FROM OTA_RESOURCE_DEFINITIONS , PO_VENDORS FLEX_T0_0 WHERE (OTA_RESOURCE_DEFINITIONS.enabled_flag = 'Y' and nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate)) between nvl(trunc(OTA_RESOURCE_DEFINITIONS.start_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and nvl(trunc(OTA_RESOURCE_DEFINITIONS.end_date_active), nvl(fnd_date.canonical_to_date(:VDATE), trunc(SysDate))) and OTA_RESOURCE_DEFINITIONS.ID_FLEX_NUM = :STRUCTURE and 1 = 1 and OTA_RESOURCE_DEFINITIONS.SEGMENT1 = FLEX_T0_0.VENDOR_ID and (1 = 1) and FLEX_T0_0.VENDOR_NAME like :FLEX_QUERY_VALUE0) ORDER BY FLEX_DISPLAY0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Custom OAF page deployment R12.2.4?

    Oracle Community | 1 month ago | Reddy007
    oracle.apps.fnd.framework.OAException: Could not load application module 'XXTEST.oracle.apps.ar.test.server.TestAM'.
  6. 0

    Null Pointer Exception - VO Extension

    Oracle Community | 2 months ago | Nimaat
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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

      java.lang.NullPointerException

      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.processFormRequest(OAPageBean.java:3173)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1924)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
      7 frames
    3. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:233)
      1 frame
    4. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    5. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      5 frames
    6. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    7. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    8. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    9. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    10. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    11. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    12. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    13. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    14. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    15. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    16. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    17. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    18. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      1 frame
    19. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
      3 frames
    20. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    21. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    22. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
      3 frames
    23. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames