My Oracle Support Banner

Validation Check/Transformation Submission Fails With 'user does not have permission Modify on object' (Doc ID 2582761.1)

Last updated on SEPTEMBER 12, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4 and later
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW 2.4.8.1). when submitting the job for Validation Check the following error occurs in the job log file:


ERROR
User <user_name> does not have permission Modify on object Transformation_Execution_<N>.
Job Submission failed with error ORA-20200: *** ERROR: cdr_exe_owb_execution.startedJob: SQL error: ORA-20200: *** ERROR: A simultaneous job's updates have caused job <NNNNNNNN> to fail.

Changes

 The package linked to the Validation Check was either deleted and remained linked to the Validation Check, or it actually never existed and was wrongly referenced in the Validation Check.

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!


In this Document
Symptoms
Changes
Cause
Solution


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