Several jobs fail with ORA-01442
Hi, I'm upgrading from 11.5.9.2 to 12.1.1. While running the merged upgrade driver (6678700), several jobs are failing with ORA-1442. This is happening mainly with ICX scripts: icx_regions.xdf, icx_page_plugs.xdf, icx_pages.xdf, icx_questions.xdf and icx_pages_tl.xdf. Another file that's failing is pa_projects_all.xdf.
All of these scripts are trying to define NOT NULL constraints, but the columns already are NOT NULL:
Executing statement
ALTER TABLE ICX.ICX_REGIONS MODIFY ( LAST_UPDATED_BY NOT NULL )
Start time for statement above is Tue Jul 08 00:27:49 EST 2014
End time for statement above is Tue Jul 08 00:27:49 EST 2014