search cancel

Getting this error: ORA-12012: error on auto execute of job 9


Article ID: 4243


Updated On:


CA Business Service Insight


You start to get this error:

ORA-12012: error on auto execute of job 9 

ORA-02289: sequence does not exist 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 16 

ORA-06512: at "OBLICORE.PART_MNG_PKG", line 440 

ORA-02289: sequence does not exist 

ORA-01403: no data found 



Component: OBLCRE


It’s trying to run one of the scheduled jobs and the job is not created properly. Normally this gets created during the install as long as the Oracle job scheduling service is installed. It may be that they only added the service after the fact or something went wrong during the job creation.


You should be able to recreate it from the installation media (it’s a simple job that then reads a table for what to clear, but the job is always there).


Run: Select * from user_jobs;

To see the job.

Please make sure:

1. The database package Part_Mng_Pkg is compiled.

2. The raw data job exists, scheduled and unbroken


The job can be recognized by What= Part_Mng_Pkg.G_TABLE_NAME :='T_RAW_DATA';Part_Mng_Pkg.raw_data_purge;

Additional Information

The Part_Mng_Pkg.sql can be found under the DVD: