No Rows to ALM Result Detail Table with Assertion `mDataType == FCDimensionDesc::double_type' Failed (Doc ID 1324151.1)

Last updated on JUNE 24, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 5.2, nothing is output to the Result Detail RES_DTL_xxxxx table.  The table is created but it is empty.  Also, no records are output to the FSI_PROCESS_ERRORS table.

If you execute the ALM process directly on the server from $FIC_DB_HOME/bin, the following error appears:

$ ./ofsrm OFSAA52INFOD_200341_20101130_9 ALMPROCESS TASK1 19991231 200341 OFSAUSR ALM
Warning: iso88951 does not exist.
Rem = 0Host IP--> 111.111.111.111
HostIP... 111.111.111.111
Port... 8086
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement

| strBatchId : OFSAA52INFOD_200341_20101130_9 | strComponentId : ALMPROCESS | Process ID : 200341 | User ID : OFSAUSR|

ProcSysID = 200341
Running RM, Process ID: 200341mAppId : TM_Engine
Engine started execution
mAllowSrcSelect = 1
ofsrm: RMLogPack.h:32: void FCGlobalEnblDimDesc::SetDouble(double): Assertion `mDataType == FCDimensionDesc::double_type' failed.

The final statement in the alm log file in $FIC_DB_HOME/log/FusionApps is an insert into RES_DTL_xxxxx:

Module Logging OFS Access module data: insert
insert into RES_DTL_200341(ORG_UNIT_ID, GL_ACCOUNT_ID,
COMMON_COA_ID, PRODUCT_ID, iso_currency_cd, result_sys_id,
financial_elem_id, scenario_num, start_date_index,
result_type_cd, bucket_001, bucket_002, bucket_003, bucket_004,
bucket_005, bucket_006, bucket_007, bucket_008, bucket_009,
bucket_010, bucket_011, bucket_012, bucket_013, bucket_014,
bucket_015, bucket_016, bucket_017, bucket_018, bucket_019,

.
.
.
etc

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