FTP Adjustment Rule is not Creating an Adjustment Rate for Level0 / Leaf Level Definitions (Doc ID 2140761.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Funds Transfer Pricing (FTP), when you run an FTP Process with an Adjustment Rule, the Adjustment Rate is not getting output to the instrument table.  The TRANSFER_RATE column is populated successfully but the column OTHER_ADJUSTMENTS_RATE remains empty.

The Adjustment Rule definition is entered at the leaf / level0 level.  However, if you check the row in the table FSI_PROCESS_NODE_MAP for the process, the column ADJ_NODE contains a node level value and not the leaf level value.

select * from FSI_PROCESS_NODE_MAP
where node_map_id in (select node_map_id from FSI_PROCESS_NODE_HEADER
     where tp_process_sys_id = <insert System Id of FTP Process>);

If you change the definition from the leaf level to the node level, the Adjustment Rate is populated successfully.  You do not understand why the Adjustment Rate is not populated when the definition exists at the leaf level.

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