Instrument Allocation with Expression Fails To Complete After First Run

(Doc ID 1354143.1)

Last updated on AUGUST 31, 2011

Applies to:

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

Symptoms

On Oracle Profitability Management 5.6,  when attempting to run an allocation with an Expression, the allocation fails to run and ends with the following queries:

Module Logging OFS Access module data: select
select REV_EXPRESSION_DETAILS.sys_id_num,
REV_EXPRESSION_DETAILS.sequences,
REV_EXPRESSION_DETAILS.table_name,
REV_EXPRESSION_DETAILS.ext_field_name,
REV_EXPRESSION_DETAILS.operator,
REV_EXPRESSION_DETAILS.constant_amt,
REV_EXPRESSION_DETAILS.formula_sys_id,
REV_EXPRESSION_DETAILS.formula_type,
REV_EXPRESSION_DETAILS.return_type
from REV_EXPRESSION_DETAILS
where REV_EXPRESSION_DETAILS.sys_id_num = 200215.00000
order by REV_EXPRESSION_DETAILS.sequences


Module Logging OFS Access module data: select
select REV_TABLES_V.display_name, REV_TABLES_V.description,
REV_TABLES_V.display_flg, 0, REV_TABLES_V.table_name,
REV_TABLES_V.owner, REV_TABLES_V.dbf_name
from REV_TABLES_V
where REV_TABLES_V.table_name = 'FSI_D_TERM_DEPOSITS'


Module Logging OFS Access module data: select
select REV_TABLES_V.display_name, REV_TABLES_V.description,
REV_TABLES_V.display_flg, 0, REV_TABLES_V.table_name,
REV_TABLES_V.owner, REV_TABLES_V.dbf_name
from REV_TABLES_V
where REV_TABLES_V.table_name = 'FSI_D_TERM_DEPOSITS'


Module Logging OFS Access module data: select
select REV_TABLES_V.display_name, REV_TABLES_V.description,
REV_TABLES_V.display_flg, 0, REV_TABLES_V.table_name,
REV_TABLES_V.owner, REV_TABLES_V.dbf_name
from REV_TABLES_V
where REV_TABLES_V.table_name = 'FSI_D_TERM_DEPOSITS'

This allocation was previously working in 5.2.2 version.

Steps:
1. Financial Services Application ----->Profitability Management ---> Rule Specification ----> Allocation Specification
2. Run previously working Instrument to Instrument with Expression allocation.

Changes

Applied Oracle Profitability Management Service Pack 5.6.

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