'Another Data Element' Type Data Filter Does Not Work in OFSPM Allocations

(Doc ID 1315503.1)

Last updated on APRIL 20, 2011

Applies to:

Oracle Financial Services Profitability Management - Version: 5.2.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
PFT
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Symptoms

On Oracle Financial Services Profitability Management (OFSPM) 5.2.2, when attempting to use a Data Filter of the type "Another Data Element', incorrect SQL is generated in the allocation. If the Data Filter is used as part of the Lookup Table Driver definition, the following error occurs:

ERROR
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [60] - odescr() SQL
Function: [0] - SQL function not found! Oracle Error: ORA- 00936:
missing expression Driver Function:
drv_oci::SetColInfoFromResults() SQL Statement:
select count(a.identity_code), SUM(NVL(TRANSFER_RATE, 0)),
a.identity_code_chg
from RI_ACCT a
where (((a.TRANSFER_RATE_SRC_FLAG = 0))
and ((a.YIELD_CURVE_ACCRUAL_BASIS_CD < ())))
and a.as_of_date='08/ 31/ 2010'
group by a.identity_code_chg

If used as Data Filter for Source, the allocation will not even complete and the following error is thrown if run command line:

$ 1 Allocation Task1 19991231 201213COKI AsOfDate=12/31/1999 <
Warning: iso88951 does not exist.
Rem = 0ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
Host IP--> 10.143.92.26
HostIP... 10.143.92.26
Port... 6501
Connection to database OFSAA52 successful
Allocation ID failed to convert.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an allocation with an 'Another Data Element' type data filter
2. Run the allocation

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