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

MOSC Banner

Failure running glcal.odf as part of the R12 upgrade

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

Hi, I'm upgrading from 11.5.9.2 to 12.1.1.  While running the upgrade driver (6678700 merged with preinstall patches), one of the jobs fails while running file glcal.odf:

*******************************************************
In table GL_PERIOD_STATUSES, the column QUARTER_NUM
   is nullable when it should be not null.

Updating the column using the default value :

'SELECT p.quarter_num FROM   gl_periods p, gl_sets_of_books sob WHERE
p.period_name = GL_PERIOD_STATUSES.period_name AND    p.period_set_name =
sob.period_set_name AND    sob.set_of_books_id =
GL_PERIOD_STATUSES.set_of_books_id '


The fetch statement is:
SELECT ROWID FROM GL.GL_PERIOD_STATUSES WHERE QUARTER_NUM is null

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