My Oracle Support Banner

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


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