My Oracle Support Banner

Questions On Population Of STG_ALM_GAP_LIMIT_DTL Table (Doc ID 2970667.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)


Question 1: What do columns n_lwr_limit_amount and n_upr_limit_amount from STG_ALM_GAP_LIMIT_DTL table mean?

What values need to be given for those columns and how do the values affect processes.
Question 2: Say you have Repricing time buckets and Limits as follows: Limits are in Decreasing manner and they are Negative. Given the scenario, how to Address the Upper limit and Lower Limit columns in STG_ALM_GAP_LIMIT_DTL template and also, which method is suggested to be used: ABSOLUTE OR RELATIVE?

Is it possible to have same Upper limit and Lower Limit value for all the buckets, Eg: bucket1: 0-10, bucket2: 0-10, bucket3: 0-10 OR Limit must be changing from one bucket to next bucket?
Question 3: Is n_bucket_number same as the bucket number defined under ALM Maintenance > Time Buckets or are new bucket numbers defined for respective effective start & end date of limits in this table?

Question 4: How should bucket numbers be defined for period of 7 days when ALM Time Bucket is maintained for one day frequency?


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

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