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)
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.
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.
Expect correct CHARGE_CREDIT_TRATE to be generated.
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
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);
5. Created new TP Process - coki_charge_credit_cond_assump using coki_charge_credit_cond_ass
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms