Account Activity Transaction is Displaying Error - "The system has encountered an error while processing the request" after Filling the Search Criteria.
(Doc ID 2665394.1)
Last updated on APRIL 23, 2021
Applies to:
Oracle FLEXCUBE Direct Banking - Version DB 12.0.2 to DB 12.0.3 [Release DB 12]Information in this document applies to any platform.
Symptoms
When attempting to perform ''Account Activity'' transaction, the following error occurs.
ERROR
-----------------------
On screen - The system has encountered an error while processing the request.
In FCDB Server Error logs:
java.sql.SQLException: ORA-01502: index 'IX02_PCTB_CONTRACT_MASTER' or partition of such index is in unusable state
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
at weblogic.jdbc.wrappeaar.PreparedStatement.executeQuery(PreparedStatement.java:135)
at com.iflex.fcat.xjava.jdbc.JDBCEngine.executeQuery(JDBCEngine.java:1057)
at com.iflex.fcat.site.nbe.services.fcc.hostinterface.FCUBSAccountActivityAdapter.processRequest(FCUBSAccountActivityAdapter.java:331)
at com.iflex.fcat.services.hostinterface.HostAdapterManager.processRequest(HostAdapterManager.java:428)
at com.iflex.fcat.services.apps.endpoints.AccountActivityService.inquireAccountActivity(AccountActivityService.java:428)
at com.iflex.fcat.services.apps.endpoints.AccountActivityService.inquireListOfTransaction(AccountActivityService.java:355)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to FCDB application.
2. Navigate to ''Operative Account Activity'' -> Search.
Host Application - Oracle FCUBS (Flexcube Universal Banking System).
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 |