java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 400 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1294 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1231 ORA-06512: at "APPS.FWK_PORTLET_GEN_UTIL", line 19 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

Oracle Community | 933794 | 2 years ago
  1. 0

    Clicking on Personalize icon on functional admin responsibility gives the below error

    Oracle Community | 2 years ago | 933794
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 400 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1294 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1231 ORA-06512: at "APPS.FWK_PORTLET_GEN_UTIL", line 19 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  2. 0

    Format Payment Instructions with Text Output fails with ora 01422

    Oracle Community | 5 years ago | Tam_11
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  3. 0

    Imoprting page to server

    Oracle Community | 5 years ago | user11258661
    java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02938: Multi-organization routine failed to initialize a session for the product: &PRODUCT. Please inform your support representative. ORA-06512: at "APPS.FND_MESSAGE", line 509 ORA-06512: at "APPS.MO_GLOBAL", line 36 ORA-06512: at "APPS.MO_GLOBAL", line 757 ORA-06512: at "APPS.MO_GLOBAL", line 700 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Positive Pay with Additional Parameters erroring out on Manual Run

    Oracle Community | 5 years ago | 843443
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  6. 0

    Significance of FND_JDBC_PLSQL_RESET

    Oracle Community | 5 years ago | user10088255
    java.sql.SQLException: ORA-20101: ORA-06512: at "APPS.XXAP_APXINAGE_XMLP_PKG", line 302 ORA-06512: at line 4at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
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. java.sql.SQLException

    ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 400 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1294 ORA-06512: at "APPS.JDR_MDS_INTERNAL", line 1231 ORA-06512: at "APPS.FWK_PORTLET_GEN_UTIL", line 19 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    12 frames
  3. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.util.pg.tools.PortletUtil.getPageMetaDataFromRepository(PortletUtil.java:407)
    2. oracle.apps.fnd.framework.util.pg.tools.PortletUtil.getPortletizableRegions(PortletUtil.java:377)
    3. oracle.apps.fnd.framework.webui.PortletizationHelper.addPortletizeRegions(PortletizationHelper.java:211)
    4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2672)
    5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
    6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
    7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
    7 frames
  4. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:213)
    1 frame
  5. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  6. 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
  7. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  8. 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:308)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  9. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  10. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:407)
    2 frames
  11. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:222)
    1 frame
  12. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  13. 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
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  15. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  16. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  17. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  18. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
    1 frame
  19. 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:911)
    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
  20. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  21. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  22. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame