No Response in JMS Hold Queue when the Alert of type MT950 is released (Doc ID 2819903.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Symptoms

The response for the swift MT950 message is not received in the JMS hold queue when the alert is released .

Error in OFSAA.log :

[ERROR] [WEB] [TFANALYST] [NA] [ SANCTIONS]Exception occurred while executing QueryList Numeric Overflow
java.sql.SQLException: Numeric Overflow at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4139) ~[ojdbc8.jar:19.3.0.0.0]
at
oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:125)~[ojdbc8.jar:19.3.0.0.0]
at
com.oracle.ofss.sanctions.investigation.impl.AutoAssignMatchConfigMapper.mapListRow(AutoAssignMatchConfigMapper.java:30) ~[TFLTService.jar:?]
at
com.oracle.ofss.sanctions.investigation.db.SQLUtility.executeQueryList(SQLUtility.java:76) [TFLTService.jar:?]
at
com.oracle.ofss.sanctions.investigation.impl.AlertsNotificationActionDAOImpl.decrementCurrentCapacityAsPerCondition(AlertsNotificationActionDAOImpl.java:631) [TFLTService.jar:?]

Steps to Reproduce:
1) Post the given message MT950
2) Alert is created
3) Check the JMS hold queue for hold status
4) Release the alert in TF alert summary
5) Check the JMS hold queue for release status – no response is received
6) Release any existing alert of any MT type.
7) Check the JMS hold queue for release --- response is received

Cause

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