My Oracle Support Banner

OGL EPF: Unexpected Error on Oracle Dimension Sources Tab After Changing Mapping Option to Single Value (Doc ID 755457.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.5
This problem can occur on any platform.
OGL EPF Data Integration


When attempting to access the Oracle Dimension Sources tab, the following error message is displayed:

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance

With FND: Diagnostics set to Yes, the following exception details are shown:

Error Details:
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fem.oglintg.dimrule.server.DimRuleSearchVORowImpl.getMappingDescription( at oracle.apps.fem.oglintg.dimrule.server.DimRuleSearchVORowImpl.getAttrInvokeAccessor( at oracle.jbo.server.ViewRowImpl.getAttribute( at oracle.jbo.server.ViewRowImpl.getAttribute( at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectGoodValue( at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue( at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectValue( at oracle.apps.fnd.framework.webui.OADataBoundValue.selectValue( at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(
at at$ at com.evermind.util.ReleasableResourcePooledExecutor$ at
## Detail 0 ## java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1
at$ at com.evermind.util.ReleasableResourcePooledExecutor$ at java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1

Steps to replicate:

  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Data Rules > Oracle Dimension Sources > Chart of Accounts


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.