OFSAA Cash Flow Edits Updates Amort Type Code Set For Behaviour Pattern - Error code: 9105 Invalid Amortization Type (Doc ID 1471058.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Symptoms

On Oracle Financial Services Asset Liability Management (ALM) and Oracle Financial Services Funds Transfer Pricing (FTP) 5.6 when running the Cash Flow Edits, the 9105 rule for AMRT_TYPE_CD is now incorrect. The rule overwrites entries in the AMRT_TYPE_CD field when greater than 29999. This field contains the arithmetic code for either a Payment Pattern or a Behavior Pattern. When try to create these patterns in the application, you are prompted to assign a value of 1000 - 69999 or 70000 - 99999 respectively. In the documentation for the Cash Flow engine (OFSAACFE_E24987_01_090611, page 6-11) incorrectly states "If AMRT_TYPE_CD = 800, 801, or 802 (Schedule) or 1000 to 29999 (Pattern),...). This make me believe that in a previous version of the application this field was not supposed to be populated with values greater than 29999. For that version, this Cash Flow Edit rule was correct. For current version, the rule allows (under condition) payment patterns but overwrites all behavior patterns. Therefore the rule should change to allow all values between 1000 to 99999.

ERROR
Error code: 9105 Invalid Amortization Type

Steps to Reproduce:

1. Financial Services Applications -> Asset | Liability Management -> ALM Processing -> Cash Flow Edits
2. Add
3. Cash Flow Edit Rules
4. See list with various Error Codes, see description for Error Code 9105
5. If you run the process without the Preview box ticked, will overwrite values in db

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