My Oracle Support Banner

Invalid sequence identifier error while posting swift messages in TF (Doc ID 2737851.1)

Last updated on MAY 16, 2023

Applies to:

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

Symptoms

User encountered invalid identifier error while posting swift messages

Steps to reproduce :

Step 1 : Post the new swift message using JSP

Step 2 : Check in rtiserver.log for the errors.

Expected behavior : 

The message must be posted successfully and alert must be created for the payments if the match is present.

Actual behavior : 

The message is not posted and encountered below error in RTIserver.log.

Error message :

[sourceEntityListener-5] aai - com.oracle.ofss.sanctions.preProcess.DAOImpl.MessageTagsDAOImpl Exception occured in method persistMessageTagsValues with Message = ORA-00904: "V_SEQUENCE_I_IDENTIFIER": invalid identifier

java.sql.BatchUpdateException: ORA-00904: "V_SEQUENCE_I_IDENTIFIER": invalid identifier

Changes

80813 CS patch has been applied recently on top of 80811 TF patch

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
Changes
Cause
Solution


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