OATM: ORA-25207 after running the OATM migration utility
Last updated on JANUARY 12, 2016
Applies to:Oracle Application Object Library - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
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
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