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
FEM

Symptoms

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(OAException.java:896)
at oracle.apps.fem.oglintg.dimrule.server.DimRuleSearchVORowImpl.getMappingDescription(DimRuleSearchVORowImpl.java:581) at oracle.apps.fem.oglintg.dimrule.server.DimRuleSearchVORowImpl.getAttrInvokeAccessor(DimRuleSearchVORowImpl.java:362) at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695) at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760) at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectGoodValue(OADictionaryDataRow.java:144) at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue(OADictionaryData.java:90) at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectValue(OADictionaryDataRow.java:78) at oracle.apps.fnd.framework.webui.OADataBoundValue.selectValue(OADataBoundValue.java:278) at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(OADataBoundValue.java:238)
...
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)
## Detail 0 ## java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1
...
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) 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

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