My Oracle Support Banner

SEPATFLT ISO20022 Message Posted In Sanction.jsp And Did Not Generate Alerts. (Doc ID 3028597.1)

Last updated on JUNE 17, 2024

Applies to:

Oracle Financial Services Transaction Filtering - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

SEPATFLT ISO20022 message posted in Sanction.jsp and did not generate alerts.

Access the sanctions.jsp

post a messsage

Expected result:
Alert should be generated 

Actual result:
The alert is not generated

 

Error encountered:

[ERROR] 2024-06-06 13:04:04.615 [sourceEntityListener-4] aai - Missing IN or OUT parameter at index:: 26
java.sql.SQLException: Missing IN or OUT parameter at index:: 26
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1937) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:9361) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.addBatch(OraclePreparedStatementWrapper.java:1069) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.addBatch(Unknown Source) ~[CodeGenerator.class:12.2.1.4]

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns3:FeedbackResponse xmlns:ns2=http://oracle.com/ofsaai/realtime/feedback xmlns:ns3=http://oracle.com/ofsaai/realtime><responseCode>001</responseCode><responseDesc>Feedback processed</responseDesc></ns3:FeedbackResponse>
Line 59428: [DEBUG] 2024-06-06 13:04:04.667 [sourceEntityListener-4] aai - feedbackMessage :::: {"GROUP MESSAGE ID":"50285","MESSAGE REFERENCE":"2413001362013000","ERROR MESSAGE":"Screening Service not responding.Please wait for response in HOLD Queue","STATUS":"ERROR","EXTERNAL DATA":{"Message Direction":"OUTBOUND"}}
Line 59430: com.ofs.aai.inline.error.BaseRTIException: TFLT103 : Error Code not found : {"GROUP MESSAGE ID":"50285","MESSAGE REFERENCE":"2413001362013000","ERROR MESSAGE":"Screening Service not responding.Please wait for response in HOLD Queue","STATUS":"ERROR","EXTERNAL DATA":{"Message Direction":"OUTBOUND"}}

Cause

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
Symptoms
Cause
Solution
References


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