FTP 5.6 TP Charge Credit Is Not Calculated for Conditional Assumptions: 'Spread From Note Rate' Method (Doc ID 1552501.1)

Last updated on MAY 10, 2013

Applies to:

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 Funds Transfer Pricing (FTP) 5.6, after applying <Patch: 13584073> - ftp v5.6 one-off patch to address multiple ftp issue, the CHARGE_CREDIT_TRATE is generated with 0 instead of expected rate ONLY for Spread from Note Rate method ONLY if specified through Conditional Assumption.

ACTUAL BEHAVIOR
TRANSFER_RATE is correctly generated, but CHARGE_CREDIT_TRATE is generated with 0 when specified through conditional assumption. Works as expected if Spread from Note Rate is defined directly on product not through Conditional Assumption.

EXPECTED BEHAVIOR
Expect correct CHARGE_CREDIT_TRATE to be generated.

STEPS
The issue can be reproduced at will with the following steps:

1. Applied Patch: 13584073 - ftp v5.6 one-off patch to address multiple ftp issues
2. Application Preferences: 12/31/1999, Product Dimension = Common Chart of Accounts
3. New TP Rule: coki_charge_credit_cond_ass

Defined for two products: 30321

conditional assumptions
Mortgage 1 YR ARM - 30321: For ORG = 5014142, for PRODUCT = Mortgage 1 YR ARM 30321 : Straight Term

Mortgage Fixed 20 YR - 30202: For ORG = 5014064,
for PRODUCT = Mortgage Fixed 20 YR 30202 : Spread from Note Rate
for PRODUCT = Mortgage Fixed 15 YR 30201 : Spread from Interest Rate Code

4. Reset transfer rate and charge credit to null

update fsi_d_mortgages set transfer_rate = null, charge_credit_trate = null where as_of_date = '31-DEC-1999' and id_number in (121044,121530);
commit;

5. Created new TP Process - coki_charge_credit_cond_assump using coki_charge_credit_cond_ass

Calculation Selection:
Checked: Transfer Rate and Instrument Charge/Credit (TP)

6. Ran TP Process
==> confirmed 0 charge_credit_trate generated when spread from note rate defined in conditional assumption

select id_number, org_unit_id, product_id, common_coa_id, transfer_rate, CHARGE_CREDIT_TRATE from fsi_d_mortgages where id_number in (121044,121530);

"ID_NUMBER" "ORG_UNIT_ID" "PRODUCT_ID" "COMMON_COA_ID" "TRANSFER_RATE" "CHARGE_CREDIT_TRATE"
121044 5014142 30321 30321 4.1 37.583
121530 5014064 30202 30202 1.5 0

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