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 laterInformation 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 |