Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Several jobs fail with ORA-01442

edited Aug 20, 2021 10:06AM in Install, Upgrade, Clone, Patch - EBS (MOSC) Question

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center