Changes to Transaction Summary Loader-2 Program

The process for data loading from the Stage Transaction Summary tables to the corresponding Processing Transaction Summary tables has now been enhanced to delete the existing records before the new records are inserted. The Transaction Summary Data Loader first identifies the records existing in the Processing table for the given (AS_OF_DATE, File Name) combination and deletes this existing set of records entirely, and then the entire new input file data is loaded into the table via a pure Insert operation.

This process ensures capturing always the latest snapshot for account data coming from the latest file loaded.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

Regression Testing Recommended.

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html