My Oracle Support Banner

PROBLEM:CL:Salary Hold Release Not In Order (Doc ID 2682800.1)

Last updated on JULY 05, 2020

Applies to:

Oracle FLEXCUBE Universal Banking - Version 12.0.3 and later
Information in this document applies to any platform.


When salary is credited twice such that during first salary credit, it was insufficient to completely block upcoming EMI schedule and during second credit, remaining EMI amount is blocked. This will create two records of salary block for same component in CLTB_AMTBLK_SALARY_MAP table.

Suppose EMI amount is 1460 AED.with PRINCIPAL - 1000 AED and PROFIT - 460 AED.
During first salary credit of 220 AED is credited. This will block 220 AED for PROFIT component.
During second salary credit of 700 AED, 240 AED is used for blocking remaining PROFIT component and remaining 460 AED will be blocked against PRINCIPAL component.Now run EOD - CIDBATCH. This released and settled PRINCIPAL component correctly as there is single record in salary block table but while releasing PROFIT, it settled only 220 AED.


The issue can be reproduced at will with the following steps:
1. Do salary credit on account with loan EMI scheduled within salary block days (Maintained in account class) such that amount is insufficient to EMI amount.
2. Do another salary credit on same day to suffice remaining EMI amount. Now two rows for same component should be inserted in CLTB_AMTBLK_SALARY_MAP table.
3. Run EOD btach CIDBATCH.

It releases the salary blocks in CLTB_AMTBLK_SALARY_MAP but incompletely settled.

The issue has the following business impact:
Due to this issue, settlement of EMI is not settled correctly as per salary blocked amount.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.