OATM: ORA-25207 after running the OATM migration utility (Doc ID 300483.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After a successful migration of an Apps 11i database to the new tablespace model using OATM (Oracle Application Tablespace Migration utility), the application starst up fine, but several activities fail with the error:

ORA-25207 - enqueue failed, queue %s.%s is disabled from enqueueing

For example, some errors are:

- when updating a profile option, the error looks like:

FRM-40735: POST-UPDATE trigger raised unhandled exception ORA-25207.

- when trying to change the maintenance mode to "ENABLE" with adadmin, the error looks like:

ERROR at line 1:
ORA-20000: ORA-25207: enqueue failed, queue APPLSYS.WF_ERROR is disabled from enqueueing
ORA-25207: enqueue failed, queue APPLSYS.WF_ERROR is disabled from enqueueing
Failed to call the procedure fnd_apps_mode_util.set_to_maintenance_mode while enablin maintenance mode.
ORA-06512: at line 38

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