My Oracle Support Banner

Found Missing Function 'AAI_DATASECURITY.CLEAR_SESSION' (Doc ID 2500092.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6.1.0 and later
Information in this document applies to any platform.

Goal

We see below error in nohup.out from $FIC_HOME/ficapp/common/FICServer/bin while accessing Data Entry screen

java.sql.SQLException: ORA-06550: line 1, column 40:
PLS-00201: identifier 'AAI_DATASECURITY.CLEAR_SESSION' must be declared
ORA-06550: line 1, column 30:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at com.oracle.aai.redaction.RedactionClient.clearSession(RedactionClient.java:121)
at com.iflex.fic.ficserver.services.DAC.DACConnectionProvider.getConnection(DACConnectionProvider.java:180)
at com.iflex.reveleus.defi.server.dao.dataentry.AbstractDataEntryRepository.getConnection(AbstractDataEntryRepository.java:759)
at com.iflex.reveleus.defi.server.dao.dataentry.AbstractDataEntryRepository.executeQuery(AbstractDataEntryRepository.java:90)
at com.iflex.reveleus.defi.server.DeFiServiceProviderHelper.executeQuery(DeFiServiceProviderHelper.java:52)
at com.iflex.reveleus.defi.server.DeFiServiceProvider.handleRequest(DeFiServiceProvider.java:108)
at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:298)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)
 

Solution

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
Goal
Solution
References


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