Failure running glcal.odf as part of the R12 upgrade
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