ORA-02289: Sequence Does Not Exist Error Running SCD on User Defined Dimension (Doc ID 1399569.1)

Last updated on MARCH 10, 2023

Applies to:

Symptoms

For Oracle Financial Services Profitability Analytics (PFTBI) 5.6 or Asset Liability Management Analytics (ALMBI) 5.6, when you run the Slowly Changing Dimension (SCD) process for a user defined dimension / leaf, the SCD fails and the following error message is listed in the SCD log in /<ftpshare>/<Infodom>/logs:

Type I Update statement:
End of Cursor
OCI_NO_DATA
Error Msg :->
Error Msg :-> ORA-02289: sequence does not exist

Error in ClsUDBOperations::insertUsingPlaceHolders: could not commit
1 *ORA-02289: sequence does not exist

Statement for dimension delete updates: update DIM_<dimension> set DIM_<dimension>.F_LATEST_RECORD_INDICATOR = 'N' where ( N_<dimension>_ID ) in ( select N_<dimension>_ID from DIM_<dimension> where N_<dimension>_SKEY not in (0, -1) and DIM_<dimension>.F_LATEST_RECORD_INDICATOR = 'Y' minus select DIM_<dimension>_V.N_<dimension>_ID from DIM_<dimension>_V) and N_<dimension>_SKEY not in (0, -1) and DIM_<dimension>.F_LATEST_RECORD_INDICATOR = 'Y'

New records inserted ...0
Type II records inserted ...0
Type I updates...0
Dimension delete updates ...0

The error prevents rows from being inserted in the target DIM_<dimension> table by the SCD process.

Users already inserted all required data for the user defined dimension into SYS_TBL_MASTER, SYS_STG_JOIN_MASTER, and SETUP_MASTER.  Data exists in the DIM_<dimension>_V view.  Users cannot find any instructions in the PFTBI or ALMBI User Guide for creating a sequence.

Changes

Cause

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