My Oracle Support Banner

Clarification On Usage of STG_COMMITMENT_CONTRACTS and STG_CREDIT_LINE_DETAILS Tables in PFT (Doc ID 2413378.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Data Foundation (FSDF)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Financial Services Institutional Performance Analytics (IPA)
Oracle Financial Services Retail Performance Analytics (RPA)


The following questions came up related to the following two tables that exist in FSDF data model: STG_COMMITMENT_CONTRACTS and STG_CREDIT_LINE_DETAILS.


Question 1: Profitability application was noticed to be using STG_COMMITMENT_CONTRACTS for storing both line details and commitment to commit/pipeline. If this is true, is line level information also required?

If line level information is needed, how to get the undrawn and unutilized amount derived without having access to STG_CREDIT_LINE_DETAILS table? Profitability 8.0.5 application does not have any reference to STG_CREDIT_LINE_DETAILS.

Will there be a new T2T in the future or it is not required? If it is not required, please help understand the rationale?


Question 2: What kind of data is expected in STG_COMMITMENT_CONTRACTS for the purpose of Profitability?


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.