thanks I will have a look. Mostly it works - though I had some fringe issues
If you have any problem again, we are here to help.
I do have one issue. I went to use this database for R12.2 upgrade test and found I could not enable patch mode. Got this error:
ERROR at line 1:
ORA-20000: ORA-24033: no recipients for message Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
ORA-06512: at line 38
I set the patch mode manually (with an update statement) and started patching. Early in the upgrade patch process all workers failed with ORA-24033 related to WF_EVENT, all with no recipients messages.
I did find ML document 337294.1 which had a list of scripts to run. There were some errors - but the 24033 errors went away.
The question is what can I do to prevent the issue? Are the errors in the "repair" script going to cause issues later?