My Oracle Support Banner

Unable to add fields in Goods Screening Service under swift configuration admin screen (Doc ID 2852656.1)

Last updated on MARCH 07, 2022

Applies to:

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

Symptoms

Issue when trying to add fields in Goods Screening Service under swift configuration admin screen

Steps to reproduce:
Step1: Login using TF Admin
Step2: Go to Swift Configuration Admin
Step3: Select MT700
Step4: click on next (>) button till Screening webservice screen
Step5: Select Goods screening from drop down list
Step6: select the appropriate tags, jurisdiction, message direction and fields
Step7: click on Add

Expected Behavior:
Fields should be added in the screen once we click on Add button

Actual Behavior:
No fields are shown in the screen after clicking on Add button. Error is recorded in OFSAAErr.log

Issue Encountered:
[ERROR] [WEB] [OFSADMN] [NA] [ SANCTIONS ]Exception occured while executeBatchData Query
Missing IN or OUT parameter at index:: 8
java.sql.SQLException: Missing IN or OUT parameter at index:: 8
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]
at com.oracle.ofss.sanctions.swiftadmin.db.SQLUtility.executeBatchData(SQLUtility.java:683) ~[swiftService.jar:?]
at com.oracle.ofss.sanctions.swiftadmin.impl.GoodsWebServiceDAOImpl.addMatchWebServiceConfigurationDetails(GoodsWebServiceDAOImpl.java:124) ~[swiftService.jar:?]
at com.oracle.ofss.sanctions.swiftadmin.services.GoodsWebService.addMatchWebServiceConfiguration(GoodsWebService.java:79) ~[swiftService.jar:?]

Changes

 Recently cloned the lower environment and using it for testing

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.