My Oracle Support Banner

ALM Process Fails for Loans with a 'Non Performing' Behaviour Type (Doc ID 2297205.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

In Oracle Financial Services Asset Liability Management (ALM), when running an ALM Process against records with a Non Performing Behavior Pattern type (BEHAVIOUR_TYPE_CD = 2), the ALM process fails.  Checking the ofsrm.xxxxx.log in $FIC_DB_HOME/log/FusionApps, the last SQL in the file is a query against the instrument table:

Module Logging OFS Access module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.CUSTOMER_ID,
a.iso_currency_cd, a.id_number, a.identity_code,
a.account_number, a.HOLIDAY_CALENDAR_CODE,
a.HOLIDAY_ROLLING_CONVENTION_CD, a.HOLIDAY_CALC_OPTION_CD,
  .
  .
  .
a.MINIMUM_BALANCE, a.BEHAVIOUR_TYPE_CD, a.BEHAVIOUR_SUB_TYPE_CD,
a.DEVOLVEMENT_STATUS_CD, a.ACCRUED_INTEREST, a.ACCRUED_GROSS_AMT,
a.ACCRUED_TRANSFER_AMT
from FSI_D_LOAN_CONTRACTS a
where a.as_of_date = :as_of_date
and a.PRODUCT_ID = :PRODUCT_ID
and AS_OF_DATE = TO_DATE('11/ 27/ 2017', 'MM/ DD/ YYYY')
and LEGAL_ENTITY_ID = 765
 

There is nothing in the log after this SQL.  There are no errors in FSI_PROCESS_ERRORS.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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