Conditional Assumptions Not Using the Assigned TP Method Selection Defined in the Transfer Pricing Rule
(Doc ID 2366970.1)
Last updated on MARCH 23, 2018
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
As per Calculation Engine logic, conditional assumptions are not using the assigned TP method selection in Transfer Pricing Rule:
For one particular example, a Transfer Pricing rule had been configured on FSI_D_LOAN_CONTRACTS with two conditional assumptions, used for selecting either of the two different corresponding TP methods or the default one:
- Condition 1: If BEHAVIOUR_SUB_TYPE_CD IN ('202','203','201') then TP method as "Do Not Calculate"
- Condition 2: If BEHAVIOUR_SUB_TYPE_CD NOT IN ('202','203','201') AND ADJUSTABLE_TYPE_CD IN ('0') AND AMRT_TYPE_CD NOT IN ('600','850','400','10','70001','840','700','710') then TP method as "Cash: Duration"
- Default: TP method as "Straight term"
As per FSI_O_FTP_AUDIT_TRAIL table data, FTP engine is processing different number of records under each condition as below:
- Condition 1: "Do Not Calculate" - 2190 records (1 record is calculated by Cash: Duration)
- Condition 2: "Cash: Duration" - 12737 records (additional 8470 records are calculated by Cash: Duration)
- Default: "Straight term" - 34674 records
As per instrument data in FSI_D_LOAN_CONTRACTS table (49601 records in total), below number of records satisfy each condition:
- Condition 1: "Do Not Calculate" - 2191 records
- Condition 2: "Cash: Duration" - 4267 records
- Default: "Straight term" - 43143 records
Ideally, FTP engine should assign the TP method to a record based on the satisfied conditions. Based on obtained results, this has been found to work differently. What is the explanation for this?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!