My Oracle Support Banner

FTP Processes with Hierarchy Conditional Assumptions Fail After Upgrading to 8.0.7 (Doc ID 2599804.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

After upgrading to FTP 8.0.7, when attempting to execute FTP Processes, the processes which include Conditional Assumptions built using a Hierarchy fail to run.  The Transfer Pricing Engine log generated in /<ftpshare>/logs/<AsofDate>/<Infodom>/Transfer Pricing Engine ends with SQL like the following:

Module Logging OFS Access module data: select
select ofsa_idt_rollup.leaf_node
from ofsa_idt_rollup
where sys_id_num=200159
and (( leaf_node in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=15)
or node_01 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=14)
or node_02 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=13)
or node_03 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=12)
.
.
.
or node_14 in (select leaf_node
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=1)
or (exists (select *
from REV_HIERARCHY_FILTER
where sys_id_num=385909
and hierarchy_level=0
and leaf_node=0))))

Module Logging OFS Access module data: /* 279: io_id_view_filter::GetID*/

There is nothing after this point in the log.

The nohup.out from $FIC_DB_HOME/bin contains the following:

| strBatchId : <INFODOM>_<BATCH_NAME>_20190430_5 | strComponentId : Transfer Pricing Engine | Process ID : 359021 | User ID : <USER> | AS_OF_DATE : 04/30/2019
successfully read all database details
Connection to the following database was successful: <DATABASE>
Running TP, Process ID: 359021
ID_TYPE = 204
*** Error in 'ofstp': free(): invalid next size (normal): 0x00000000027b14d0 ***

As a result of this issue, you cannot run any FTP Processes that reference a Hierarchy within a conditional assumption.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.