ORA-00955 and ORA-06512 Running an Allocation when the Sequence Name Exists Already

(Doc ID 277914.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Profitability Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)

Checked for relevance on 11-Feb-2015.
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In OFSA 4.5 when running an Performance Analyzer Allocation, the following error message is found:

ofspa.####

Oracle Performance Analyzer
Version 4.5.39
Copyright (c) Oracle Corporation, 1995-2000
All rights reserved worldwide.

Connection to database demo453 successful
Running allocations with: 103735, 0, OWNER, 06/30/2004, 0.
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-00955: name is already used by an existing object
ORA-06512: at "OWNER.OFSA_DBA", line 1293
ORA-06512: at "OWNER.OFSA_DBA", line 2380
ORA-06512: at "OWNER.OFSA_SQL", line 475
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: declare begin OFSA_SQL.CREATE_SEQUENCE ('OWNER', 'OFSA_JOB####_ERR_SEQ INCREMENT BY 1');end; done.

Changes

Users may have performed routine maintenance on OFSA_REQUEST_QUEUE_SEQ sequence. You may have re-incremented this sequence using a start number that conflicts (or will conflict) with an existing sequence in the database.

Users may also notice sequences and public synonyms in ALL_OBJECTS with the naming convention of OFSA_JOB####_ERROR_SEQ (where #### corresponds to the job_num column on ofsa OFSA_REQUEST_QUEUE table.

Cause

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms