OFSAA Profitability and Fund Transfer Pricing (PFT) flow orchestrates instrument, rates, and dimension data from staging tables through processing layers via T2T and PL/SQL transformations. Data flows through OFSAA Processing Tables into fact tables including FCT_LEDGER_STAT, FCT_ACCOUNTING_ENTRIES, and FCT_FTP_ACCOUNT_SUMMARY, with allocation views capturing before, after, and allocation states. The pipeline identifies three critical mismatches—account number discrepancies, account-transaction currency misalignment—and unreconciled amounts at total levels, feeding into profitability reports at both aggregated and detailed levels. This architecture demonstrates best practices for financial data reconciliation, multi-dimensional allocation, and hierarchical reporting in enterprise banking systems. Fork this diagram on Diagrams.so to customize transformation logic, add data quality checks, or adapt for your institution's chart of accounts structure.