Ora-01403: No Data Found and Signal 6 Error When Using an Intercompany Data Component in PFT Mapping Rule (Doc ID 466191.1)

Last updated on MAY 25, 2012

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Profitability Manager - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Oracle Enterprise Performance Foundation (EPF) - Version: 11.5.10
FEM
Checked for relevance on 25-May-2012.

Symptoms

In Profitability Manager (PFT) 11i, when attempting to run a mapping rule with an Intercompany dimension data component the following error occurs:

ERRORS
Error from View Log:

APP-FEM-416323: An unhandled error has occurred while processing the condition: ORA-01403: no data found. Please contact your system administrator for more information.

Error from Output Log:

FEMCCE: 5975797/fem/lib/FCFilterCond.cpp:355: INT FCFilterConditions:GetAssemblerPredicate(class
SimpleString &,DBHandle = DB_ID): Assertion '0' failed.

/u001/crpfchappl/fem/11.5.0/bin/FEMCCE
Program was terminated by signal 6

The View Source results from the Mapping Rule also display incorrect results. The errors occur in both a Local or Global condition and if "Display SQL" is used in a Global Condition, instead of the condition sql the following error results from the 'FEMCONDAPI module: FEM: Conditions API':

An unhandled error has occurred while processing the condition: ORA-01403: no data found. Please contact your system administrator for more information.

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a Simple Source Mapping Rule
2. Add a local or global 'Intercompany' dimension Data Component

==> Check the View Source results
==> Run the Mapping Rule

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