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.