My Oracle Support Banner

Missing Base Sequences For Base TXN_DETAIL Tables (Doc ID 2660152.1)

Last updated on APRIL 17, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version

The base sequences for CI_TXN_DETAIL and CI_TXN_HEADER tables is missing.

ERROR
----------
'weblogic.kernel.Default (self-tuning)'] ERROR (support.sql.PreparedStatementImpl) Error executing iterate for rawSQL:
select RMB_CI_TXN_DETAIL_SEQ.NEXTVAL as sequence from DUAL /* SQL for Zone 'C1-NEXTSEQ' */ /* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */
java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

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
References


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