Unique Index Drop and Data Loader Changes

The unique index in all the six processing Management Ledger tables have been dropped to improve allocation execution timings for rules writing into Management Ledger tables.

The Management Ledger Data Loader Program that loads data from Stage Management Ledger tables into Processing Management Ledger tables has undergone a change where the IDENTITY-CODE is not re-used for more than one load into the same Management Ledger table. Thus each load within a Management Ledger table becomes unique with a completely independent IDENTITY-CODE. This guarantees that every record in the Processing Management Ledger will always be unique without needing a Unique Index on the table.

Improves allocation execution performance.

Steps to Enable

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