FTP Process with Large Rule Hangs or Fails to Create Transfer Rates
Last updated on FEBRUARY 11, 2012
Applies to:Oracle Financial Services Funds Transfer Pricing - Version: 5.2
IBM AIX on POWER Systems (64-bit)
Oracle Financial Services Analytical Applications (OFSAA)
This issue has occurred with several different large rules.
Example 1: Transfer Pricing Rule
If you have a Transfer Pricing Rule with definitions for over 2,000 product / currency combinations, the FTP Process ends without any rates written to the instrument tables. Based on the information in the ofstp log, the process seems to fail while loading the FTP Rule definition.
If you reduce the Product / Currency combinations to a value below 2,000, the process runs successfully.
Example 2: Adjustment Rule
If you have an Adjustment Rule with over 350 product / currencies defined and over 180,000 rows in the related FSI_M_ADD_ON_RATE_DTL table, the FTP process fails. Based on the information in the ofstp log, the process seems to fail while processing the instrument table data.
If you delete all data related to one or two Product / Currency combinations from FSI_M_ADJUSTMENT_RULE and FSI_M_ADD_ON_RATE_DTL, reducing the amount of rows in these tables, the process completes successfully.
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