drv_upi Failed Due to ORA-24345 Error Occurs When Running PFT Mapping Rules (Doc ID 1098508.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Profitability Manager - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.
PFT

Symptoms

When attempting to run a Factor Table Mapping Rule the following error is shown in the output log:

APP-FND-01564: ORACLE error 24345 in drv_upi

Cause: drv_upi failed due to ORA-24345: A Truncation or null fetch error occurred.

The SQL statement being executed at the time of the error was: SELECT LEVEL_NUM, PARENT_ROW_NUM,DIM_MEMBER,FACTOR_VALUE FROM FEM_FACTOR_TABLE_FCTRS T1 WHERE OBJECT_DEFINITION_ID=29065 AND ((T1.LEVEL_NUM=1) OR EXISTS (SELECT NULL FROM FEM_FACTOR_TABLE_FCTRS T2 WHERE T2.OBJECT_DEFINITION_ID=T1.OBJECT_DEFINITION_ID AND T2.PARENT_ROW_NUM = T1.ROW_NUM)) CONNECT BY PRIOR ROW_NUM = PARENT_ROW_NUM AND OBJECT_DEFINITION_ID=29065 START WITH LEVEL_NUM=0 AND OBJECT_DEFINITION_ID=29065 and was executed from the file &ERRFILE.

APP-FND-01388: Cannot read value for profile option FEM_RESULT_ROUNDING_FLAG in routine &ROUTINE.
APP-FND-01388: Cannot read value for profile option FEM_CCE_DEBUG_TRACE in routine &ROUTINE.
APP-FEM-416324: An unexpected error occurred in method: &METHOD (CONTEXT=FCTableIdData::BuildIdTree)
APP-FEM-416947: Invalid 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