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)


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?



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.