ORA-00955 and ORA-06512 Running an Allocation when the Sequence Name Exists Already
(Doc ID 277914.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Profitability Manager - Version 4.5 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |