OGL-EPF 'You have encountered an unexpected error. ' and ORA-01403: no data found Errors Navigating to Either Oracle Dimension Sources or Oracle Data Sources (Doc ID 1573244.1)

Last updated on OCTOBER 20, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version 12.1.2 and later
Information in this document applies to any platform.
FEM
OGL-EPF

Symptoms

On Enterprise Performance Foundation (EFP) 12.1.3, when navigating to the Data Rules -> Oracle Dimension Sources page, the following error occurs:

ERROR
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception 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:912)
at oracle.apps.fem.oglintg.dimrule.server.DimRuleSearchVORowImpl.getMappingDescription(DimRuleSearchVORowImpl.java:586)
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:196)
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 oracle.apps.fnd.framework.webui.OADataBoundValue.getValue(OADataBoundValue.java:158)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
at oracle.apps.fnd.framework.webui.beans.message.OAMessageStyledTextBean.getAttributeValueImpl(OAMessageStyledTextBean.java:238)
at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source)

The page was previously working.

The issue can be reproduced at will with the following steps:
1. Navigate to Data Rules -> Oracle Dimension Sources

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