Ledger Stat

Ledger Stat captures ending balances, average balances, income & expense

Ledger Stat in OFSAA is one of the sources for the transfer pricing and profitability process, for example the amount of expenses incurred in running a bank branch can be derived from the ledger stat.

Ledger Stat contains balance sheet and capital allocations

Notes on Ledger Stat

Only one ledger stat table exists in each OFSAA instance

@apps2fusion (Copyright)

New columns cannot be added

Custom ledger stat tables cannot be registered

General Ledger or FAH balances can feed into Ledger Stat. The decision between FAH or GL feeding into Ledger Stat depends upon the level of granularity desired in Ledger Stat.

Instrument tables

Instrument tables contain the end of day balances at extremely granular level from the source systems

@apps2fusion (Copyright)

ALM and FTP engine use the information in these tables to calculate NII or Liquidity gaps.

ALM and FTP engine also write back into these tables with processed results

Output of these is fed into a result table

Notes on Instrument Tables

Various instrument tables are delivered by Oracle out of the box

New columns can be added to the existing instrument tables.

After the new tables and new columns are registered, these become available to the OFSAA engine.

New instrument tables can be added and registered within OFSAA provided they adhere to the standards. This process is straightforward.