My Oracle Support Banner

Error Code 9100 "Org Term > Amrt Term" Upon Running Cash Flow Edits / Engine Converts AMRT_TERM_MULT & AMRT_TERM to Days (Doc ID 2509212.1)

Last updated on SEPTEMBER 25, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

Error 9100 - "Org Term > Amrt Term" was received post running Cash Flow Edits (CFE).

AMRT_TERM = ORG_TERM and AMRT_TERM_MULT = ORG_TERM_MULT were already set according to expectations (see below).

Example:
 ORIGINATION_DATE= 17-Mar-17
 MATURITY_DATE = 17-MAR-29
 AMRT_TERM = 12
 AMRT_TERM_MULT= Y
 ORG_TERM=12
 ORG_TERM_MULT= Y
 AMRT_TYPE_CD=800

FSI_PROCESS_ERRORS revealed CORRECTED_VALUEs below:
 AMRT_TERM_MULT = D
 AMRT_TERM= 4383

 

Please answer below queries:

Question 1: Why does Cash Flow Edits suggest to use D, when 12Y was actually suggesting exact tenor? CFE Engine seems to transform 12Y = 4383D.

Please advise if this defaulting should be done when AMRT_TERM equals to ORG_TERM?

 

Question 2: Considering the AMRT_TYPE_CD is not 700 (Non-Amortizing instruments) and AMRT_TERM = ORG_TERM, why would AMRT_TERM be defaulted to '0'?

Could you please further explain with a scenario?

 

Question 3: Regarding the CFE error 9100, is there need to convert the AMRT_TERM and ORG_TERM to "D"?

Can you please advise what is the best practice or suggested solution here? It doesn't seem to make sense for "D" to be the only value, since the field also allows "M" and "Y" settings.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.