Mapping Rules Ends with Signal 11 Error & ORA-01654 in Output Log (Doc ID 392391.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 12.1.2
Oracle Profitability Manager - Version 11.5.10 to 12.1.2
Information in this document applies to any platform.
Checked for relevance on 20-Jul-2015.

Symptoms

In Profitability Manager, Mapping Rules are failing with a Signal 11 error.  The "View Log" contains an error like the following:

*** FCFilterCondition: SqlStr returned: (a.FINANCIAL_ELEM_ID = 37102) AND (a.NATURAL_ACCOUNT_ID = 37122) AND (((a.DATASET_CODE =11001)and(a.CAL_PERIOD_ID = 24539480000000000000071100100140)) )
AND (a.CREATED_BY_OBJECT_ID NOT IN(24818)) AND (a.LEDGER_ID = 2002)
/d01/oracle/visappl/fem/11.5.0/bin/FEMCCE
Program was terminated by signal 11

The "Output Log" contains the following error:

APP-FND-01564: ORACLE error 1654 in drv_upi

Cause: drv_upi failed due to ORA-01654: unable to extend index FEM.FEM_BALANCES_PK by 16 in tablespace APPS_TS_TX_DATA

As a result, the Mapping Rules do not output any results.

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