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

Last updated on AUGUST 17, 2017

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.

Cause

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