My Oracle Support Banner

IBAN STRUCTURE AND IBAN PLUS File Uploads Causing Issue (Doc ID 2629243.1)

Last updated on DECEMBER 18, 2020

Applies to:

Oracle Banking Payments - Version 14.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.3.0.0.0 version, Implementation Support

 The IBAN STRUCTURE AND IBAN PLUS File Uploads are using the TRUNCATE TABLE commands in the Application layer which is causing the below error in Bank Environment:
Caused by: Error : 1031, Position : 15, Sql = TRUNCATE TABLE ISTB_ISIBAN_DIRECTORY, OriginalSql = TRUNCATE TABLE ISTB_ISIBAN_DIRECTORY, Error Msg = ORA-01031: insufficient privileges
Error Code: 1031
Call: TRUNCATE TABLE ISTB_IBAN_PLUS_TEMP
Query: DataModifyQuery(sql="TRUNCATE TABLE ISTB_IBAN_PLUS_TEMP")
at org.eclipsse.persistence.exceptions.DatabaseException.sqlE
ERROR
-----------------------
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Take IBAN Structure File
2. Upload the same
3. Check whether its successful

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload IBAN structure file and IBAN Plus File.

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


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