CASA | Not Able To Perform DE Transaction On CASA Having Sufficient Limit (Doc ID 3003540.1)

Last updated on FEBRUARY 14, 2024

Applies to:

Symptoms

On : 14.6.0.5.0 version, Implementation Support

CASA | Not able to Perform DE transaction on CASA having Sufficient limit

For a CASA Account, Facility is attached with sufficient limit (100,000,000.00) Hence the Total available limit is 99,400,308.29 (100,000,000.00-599,691.71)
User performs a DE transaction 1,000,000.00 to debit the CASA account.
During the transaction, system is throwing the error message "Transaction cannot be processed due to insufficient funds in the account - ST-FUS-029"

ERROR
-----------------------
Transaction cannot be processed due to insufficient funds in the account - ST-FUS-029

STEPS
-----
1. Have CASA account with Current Balance in Debit (Dr)
2. Create a Facility with sufficient limit and link it to CASA
3. Validate if Total Available Balance is updated (Should be Limit Amount - Dr Balance)
4. Navigate to DEDJNLON and perform a transaction to debit the CASA account (amount should be less than total available balance)
5. Save the Transaction

BUSINESS IMPACT
---------------
Due to this issue, users can't able to save the transaction in DEDJNLON.

Changes

Fix :- OUT parameter changed to IN OUT parameter as part of Hooks
Components Affected
-------------------
ifpks_limit_service_cluster.spc;ifpks_limit_service_cluster.sql;ifpks_limit_service_custom.spc;ifpks_limit_service_custom.sql;stpks_limit_acc_service_cluster.spc;stpks_limit_acc_service_cluster.sql;

stpks_limit_acc_service_custom.spc;stpks_limit_acc_service_custom.sql;

Cause

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