About This Architecture

OFSAA PFT (Profitability and Fund Transfer Pricing) flow orchestrates multi-stage data transformation from staging tables through allocation engines to reconciled ledger and reporting tables. Data flows from OFSAA Staging Tables (Instrument, Rates, Dimensions) through Processing Tables via T2T and PL/SQL jobs, with allocation logic applied across three views (Before, After, and Allocation). The pipeline identifies and flags three critical mismatch types—Account Number, Account Currency vs. Transaction Currency—and produces reconciled outputs in FCT_LEDGER_STAT, FCT_ACCOUNTING_ENTRIES, and FCT_FTP_ACCOUNT_SUMMARY for downstream FTP Reports and Profitability aggregations. This architecture ensures data quality and auditability in complex financial profitability calculations. Fork and customize this diagram on Diagrams.so to adapt allocation rules, add validation checkpoints, or integrate with your GL reconciliation workflows.

People also ask

How does OFSAA orchestrate fund transfer pricing and profitability allocation from staging through reconciled reporting?

OFSAA PFT flow ingests Staging Tables (Instrument, Rates, Dimensions) into Processing Tables via T2T and PL/SQL jobs, applies allocation logic across Before/After/Allocation views, detects mismatches (Account Number, Currency), and outputs reconciled data to FCT_LEDGER_STAT, FCT_ACCOUNTING_ENTRIES, and FCT_FTP_ACCOUNT_SUMMARY for profitability and FTP reporting.