My Oracle Support Banner

N_GL_ACCOUNT_SKEY Is Missing From Reporting FTP FCT_FTP_ACCOUNT_SUMMARY Table (Doc ID 2880021.1)

Last updated on JULY 13, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
General Ledger (GL)

Goal

The column N_GL_ACCOUNT_SKEY (General Ledger information), a key processing dimension used by the FTP module, is missing from the reporting table at deal level FCT_FTP_ACCOUNT_SUMMARY, even though the GL information exists in the source of this table, as FSI_D_INST_SUMMARY.GL_ACCOUNT_ID.

The standard FTP Reports are created at deal level (based on table FCT_FTP_ACCOUNT_SUMMARY) or aggregated level (based on table FCT_LEDGER_STAT) so this means that according to the current structure of CT_FTP_ACCOUNT_SUMMARY the reports on deal level will not contain the GL information of the deal.

Why the N_GL_ACCOUNT_SKEY data is missing from the FCT_FTP_ACCOUNT_SUMMARY table?

 

Solution

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
Goal
Solution
References


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