DH 1.0.45477.1
Overview
- Release Date: July 4, 2024
- Previous Release Version: N/A
Breaking Changes
Aggregator
- #100 Updated balm_aggr_super
- Previously super-aggregator made use of cf outputs which added overhead. Now we make use of aggregator outputs directly for super aggregator.
- Programs Affected:
balm_aggr_super: Changes in the input parameters as now it takes aggregator output and we removed config file.
Products
- #110 Updated llg_gl_recon
- Previously, llg_gl_recon used to take a config file containing different sources as input and write to same output file for all sources. The config file use is removed and it is converted to separate process for each source.
- The other change is that it has inbuilt loader using which the output are loaded to required table. No separate data loading is required.
- Programs Affected:
llg_gl_recon: Separate process level setup for each source. Changes in input parameters as no more config file utilization and also connection string is required.
- #181 Updated src_gl_recon_data
- The updated src_gl_recon_data takes the outputs of llg_gl_recon process and merge it into single file and then process it. It has inbuilt loader using which the output are loaded to required table. No separate data loading is required.
- Programs Affected:
src_gl_recon_data: Changes in the input parameters as now it takes connection string too for uploading data.
Loaders
- #195 Newly developed Balm-specific Loaders
- For faster loading of balm data to Oracle or MSSQL DB, new balm-specific loader is developed.
- Programs Affected:
balm_bulk_insert: Newly developed balm-specific data loader for Oracle and MsSql.
Changes
Aggregator
- #34 Better logging
- New and better logging service using a newly developed standard library.
- Programs Affected:
balm_aggr_nm,balm_aggr_m,balm_aggr_dim_nm,balm_aggr_dim_m,balm_aggr_consol,balm_aggr_super,llg_gl_recon,src_gl_recon_data: Only the logging part is affected; the rest of the program remains the same.
- #242 NPA change
- User can pass npa field in required fields file and npa values directly.
- Programs Affected:
balm_aggr_nm,balm_aggr_m,balm_aggr_dim_nm,balm_aggr_dim_m: Change in the required fields 'npa' and new input param 'npa-values'.
Utilities
- #196 Newly developed bulk_insert
- Newly developed bulk_insert program that can bulk load data to MSSQL or ORACLE database as per the requirement.
- #89 Newly developed data_cleaner_mssql
- Newly developed data_cleaner_mssql program that can delete data from MSSQL table as per the where condition provided.
- #89 Newly developed data_cleaner_oracle
- Newly developed data_cleaner_oracle program that can delete data from ORACLE table as per the where condition provided.
- #154 Newly developed query_runner
- Newly developed query_runner program that takes a directory as input and executes all the sql file contained in it. It provides support for both MSSQL and ORACLE database.
- #148 Newly developed zip_n_purge
- Newly developed zip_n_purge program that can perform zipping, purging or translocating operation for given directory.
- #240 Newly developed extractor
- Newly developed extractor program that is used to extract data from database and write it to a file.
Fixes
Aggregator
- #179 Consider Avg days beyond 30 Years
- For all the cfdate which beyond 30years from asondate, previously it was considered to be at 30years but now actual daynum is considered for the average and then it is written to last bucket.
- Programs Affected:
balm_aggr_m,balm_aggr_dim_m: Only the calculation part for last bucket is affected; the rest of the bucket structure remains the same.
- #177 Overdue File.
- For all the overdue cashflows(cfdate < asondate), previously we were passing it all to single default overdue code but now we can make use of residual period(asondate-cfdate) to bucket overdue cashflow to different overdue llg based on residual period.
- Programs Affected:
balm_aggr_m,balm_aggr_dim_m: The scripts needs to be updated to change default overdue llg code to overdue file.
- #178 is-amt-abs & is-aggr-amt-abs.
is-amt-abs makes the amount absolute at the account level ,i.e, before aggregation. is-aggr-amt-abs makes the amount absolute at the llg level ,i.e., after the aggregation.
Programs Affected:
balm_aggr_m,balm_aggr_dim_m: These parameters are optional, set to false by default. Therefore no affects to already existing setup.
- #125 Currency conversion for non src_local_ccy
- Currency conversion was not working as expected for non src_local_ccy.
- Programs Affected:
balm_aggr_m: Only the currency conversion part for non src_local_ccy is affected; the rest of the logic remains the same.