Hi,
I created a procedure to delete OSB reporting instances in the dev_soainfra schema.
This procedure needs to be run daily.
I created a Job Definition in ESS for this procedure. I selected the procedure and all the other properties are default.
After this I select Submit Job Request, select the Job and press OK
Then I get this error:
Caused By: java.sql.SQLException: ORA-20257: cannot determine Oracle Scheduler job owner for request 208. request mode: 1
In the documentation there is mentioned that you need to add some grants and synonyms:
GRANT EXECUTE ON dev_ess.ess_runtime to dev_soainfra;
create or replace synonym dev_soainfra.ess_runtime for dev_ess.ess_runtime;
GRANT EXECUTE ON dev_ess.ESS_JOB to dev_soainfra;
CREATE OR REPLACE SYNONYM dev_soainfra.ESS_JOB for dev_ess.ESS_JOB;
GRANT EXECUTE ON dev_soainfra.purge_osb_instanties to dev_ess;
GRANT EXECUTE ON dev_ess.ESS_SCHJOB_PROC to dev_soainfra;
After this I run the job again, with the same error.
What do I have to do to execute the procedure from ESS succesfully?
The environment I use is Fusion Middleware 12.2 with OSB, SOA Suite, ESS and BAM. The database is 12.1 Enterprise Edition
Kind regards,
Herman