12.0.6: Mapping Rule Fails with APP-FEM-416323, ORA-01403: No Data Found, and Signal 6 (Doc ID 1394693.1)

Last updated on SEPTEMBER 24, 2013

Applies to:

Oracle Profitability Manager - Version 12.0.6 to 12.0.6 [Release 12]
Oracle Enterprise Performance Foundation - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Checked for relevance on 24-Sep-2013.

Symptoms

In Oracle Profitability Manager (PFT) 12.0.6, when you run a Mapping Rule that has been imported/loaded from another environment, the rule ends in an error and the following messages are listed in the Output and View Log:

View Log:

FEMCCE: 8581841/fem/lib/FCFilterCond.cpp:353: int FCFilterConditions::GetAssemblerPredicate(SimpleString&, int): Assertion `0' failed.
/apps/apps_st/appl/fem/12.0.0/bin/FEMCCE
Program was terminated by signal 6

Output:

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.

If FEMCCE debug is on, the following output appears before the error in the View Log:

Module Logging OFS Access module data: begin fem_assembler_predicate_api.generate_assembler_predicate(
:w_clause, :ret_status, :msg_count, :msg_data, :cond_obj_id,
:eff_date, :data_set_id, :period_id, :request_id, :obj_id,
:ledger_id, :dim_column, :cond_dimension, :cond_dim_val,
:table_name, :table_alias, :ledger_flag, :api_version,
:init_msg_list, :commit_flag, :encoded) ; end;

Not all Mapping Rules end with this error.  Only certain rules get the error.

Steps to Reproduce:

  1. Go to the Profitability Manager responsibility
  2. Go to Business Rule > Mapping
  3. Run a Mapping Rule

The Mapping rule fails with an error.

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