Oracle.apps.fnd.framework.OAException: Java.sql.SQLException: ORA-06502 Occurs When Personalization Is Enabled (Doc ID 1913991.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Applications Framework - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Getting the following error when personalization is enabled for iRecruitment:

oracle.apps.fnd.framework.OAException: 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 1 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.util.pg.tools.PortletUtil.getPageMetaDataFromRepository(PortletUtil.java:410) at oracle.apps.fnd.framework.util.pg.tools.PortletUtil.getPortletizableRegions(PortletUtil.java:377) at oracle.apps.fnd.framework.webui.PortletizationHelper.addPortletizeRegions(PortletizationHelper.java:211) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2624) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950) at oracle.apps.fnd.framework.webui

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms