llg_gl_recon_aggr

1. Description

llg_gl_recon_aggr program reads a cf file and aggregates the amount grouped by llg, gl_cd, and currency.

2. Program location

<installation_path>/llg_gl_recon_aggr

3. Input

Click ⬇️ to download the sample data.

3.1 Mandatory Parameters

#	Parameters	Description	Example
1	as_on_date	The date for which the program has to run	26-09-2023
2	input-file	Path to the input file	test-bed/out.cf
3	account-metadata-file	Path to the metadata file	test-bed/om.json
4	rules-file-path	Path to the rules file	test-bed/rules.txt
5	req-fields-file	Path to the required-field file	test-bed/req.json
6	output-file	Path to the output file	test-bed/op/loans
7	log-file	Path to write logs	test-bed/op/log.txt
8	diagnostics-log-file	Path to write diag-logs	test-bed/op/diag.txt
9	exchange-rate-file	Path to the exchange-rate file	test-bed/ex.txt
10	src_local_ccy	Source local currency. 🔗	INR
11	db-name	Database name where output to be loaded	ORACLE/MSSQL
12	schema-name	Schema name in the database where output to be loaded	dbo
13	connection-string	Connection credentials to connect to the database	Oracle (Username|Password|IP:PORT/Servicename) and Mssql (Server|Database|UserName|Password)
14	default-llg-code	if no rules are satisfied, then this llg code will be used	7000
15	default-gl-code	if no rules are satisfied, then this gl code will be used	8000

3.2 Non Mandatory Parameters

#	Parameters	Description	Default value	Example
1	is_consolidated	Is consolidated flag is used to define the currency type of given amount in input field. If is_consolidated flag is set, then the amount given is of consolidated type else it is in the curr input type.🔗	false	true or false
2	log_level	Level of diagnostics written to the log file.	info	error/warn/info/debug/trace/none
3	diagnostic-flag	Flag used to enable detailed logging	true	true/false
4	option	Additional parameters to be used for sqlcmd,sqlldr & sqlplus.The option parameters should be pipe seperated,containing the identification key and its value.	""	m,2|l,10

Required field file

#	Parameters	Description	Example
1	acc_num	account number	""
2	amount	amount field	net_bal
3	gl_cd	gl_code field	gl_cd
4	ccy	currency	curr

4. Output

4.1 Output file-1 : Aggregated Output

It will be uploaded in LLGReconData table.

#	Field	Description	Columns	Example
1	formatted_as_on_date	Date of operation as passed through input	As_On	26-09-2023
2	source_name	Input File name	SourceFileCd	loans
3	keys.llg	llg code generated using rules file	LLGID	8888
4	keys.gl_cd	gl_cd extracted from metadata	GLCode	1111
5	keys.ccy	currency type initialized in input	CcyID	INR
6	values.aggr_amt	if is_consolidated, then converted aggregated amount else aggregated amount	BalLCY	750000
7	conv_data.aggr_amt	if is_consolidated, then aggregated amount else converted aggregated amount	BalCCY	15000

4.2 Output file-2 : Health report

The health check report gives summary about the processed accounts such as success counts, failed counts, etc.🔗

Output derivation logic:

• aggr_amt :

    Aggregated on the basis of AggregatorKeys generated, which consists of llg, gl_cd and ccy
  
    aggr_amt = amount 
  
    Note: If fieldtype is Cashflows, aggr_amt = summation of cashflow object's principal amounts.

• converted aggr_amt :

     If is_consolidated is set to true, it converts the aggr_amt to base_currency type amount,
     else if is_consolidated is set to false, converted amount will be same as the original aggregated amount

5. Process configuration in streamdef table:

  .........
    {
      "processName": "LLG GL RECON",
      "processId": "1",
      "processBinary": "{SH_PROGRAMS}/llg_gl_recon_aggr",
      "processArguments": [
          "--input-file",
          "{SH_CFDATA}/IND/{ddmmyyyy}/gl.cf",
          "--account-metadata-file",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/CF-METADATA-FILES/gl_metadata.json",
          "--rules-file-path",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/BALM-RULE-FILES/balm_gl_rules.txt",
          "--req-fields-file",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/BALM-REQ-FIELD-FILES/balm_llg_gl_req_fields.json",
          "--default-llg-code",
          "8888",
          "--default-gl-code",
          "8000",
          "--is-consolidated",
          "false",
          "--output-file",
          "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/llg-gl-recon/gl",
          "--as-on-date",
          "{AsOnDate}",
          "--log-file",
          "{SH_LOGS}/IND/BALM/{ddmmyyyy}/balm-gl-llg-recon-log.txt",
          "--diagnostics-log-file",
          "{SH_LOGS}/IND/BALM/{ddmmyyyy}/balm-gl-llg-recon-diaglog.txt",
          "--src-local-ccy",
          "INR",
          "--db-name",
          "{DB}",
          "--schema-name",
          "{BALM_SCHEMA}",
          "--connection-string",
          "{BALM_CONN_STR}",
          "--exchange-rate-file",
          "{SH_RESOURCES}/IND/{ddmmyyyy}/exchangeRate.txt"
      ],
      "processDependencies": [
      ],
      "processReport": "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/llg-gl-recon/gl_llg_gl_recon-health-check-report.json",
      "processType": "AGGR",
      "infoLog": "{SH_LOGS}/IND/BALM/{ddmmyyyy}/balm-gl-llg-recon-log.txt",
      "errorLog": ""
    }
  .........