Which Dimension Tables Are Used for AMRT_TYPE_CD (Amortization Type Code) in EPM Cash Flow Engine Calculations? (Doc ID 2114873.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Hedge Management and IFRS Valuations - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Enterprise Performance Management (EPM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Hedge Management and IFRS Valuations (HM/IFRS)

Goal

In FTP 6.1. v_amrt_type in FSI_AMORTIZATION_TYPE_CD has the data type as Numeric and a display code was provided in this column. For example: For leases, display code provided is 840.

Now implementing FTP 8.x. In FSDF 8.0.2,the data dictionary FSI_AMORTIZATION_TYPE_CD table is not available but DIM_AMORTIZATION_TYPE table is available.

1. Is DIM_AMORTIZATION_TYPE table the replacement for FSI_AMORTIZATION_TYPE_CD table, with respect to FTP application?
2. If yes, v_amrt_type in DIM_AMORTIZATION_TYPE has VARCHAR2(60). Should the description be populated in the v_amrt_type column while giving staging data?
3. Does the v_amrt_type column impact FTP calculations?

Solution

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