Usage of Interest Rate Columns in STG_BILLS_CONTRACTS and ALM Download Specifications Missing Columns from STG_BILLS_CONTRACTS

(Doc ID 2315591.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Hedge Management and IFRS Valuations (HM/IFRS)

Goal

Currently looking at the STG_BILLS_CONTRACTS table.  It does not appear to be properly handled in ALM.  When looking at the T2T for the table in ALM - T2T_BILLS_CONTRACTS, it seems to be a fairly standard configuration to populate an instrument table. However, the following issues can be seen:

1. Looking at the ALM download specifications, there appear to be only 35 columns defined, with  all of them as DL-OPT.  Key fields such as v_contract_code (which is used to create the synthetic account number) are not present.
2. From a functional point of view why are the interest rate columns present in the staging table? Are they there just to enable defaults to be plugged in to ensure the engines run?

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