An offshoot of the issue in DBUA which I reported in my previous post was invalid objects in ORDSYS schema. Two objects ORDAUDIO and ORDVIDEO were reported as invalid. Even after running catupgrd.sql manually, these did not get resolved. A search in metalink revealed bug 6830609:
When an initial attempt to upgrade intermedia from 9.2 to 10.2 fails, subsequent upgrade attempts will fail due to the ORDIMAGE, ORDAUDIO and ORDVIDEO types being invalid. Attempts to compile these types individually also fail.
Could not duplicate the initial failure. After Catupgrd.sql completes interMedia is listed as invalid.
After running imchk.sql there are the following invalid interMedia objects.
ORDAUDIO Type Body INVALID
ORDIMAGE Type Body INVALID
ORDVIDEO Type Body INVALID
Since intermedia was not used in this case, a drop and rebuild of the objects was sufficient.
Connected as a sysdba user:
drop type ordsys.ordaudio force;
drop type ordsys.ordvideo force;
drop type ordsys.ordimage force;
connect sys as sysdba
alter session set current_schema=ORDSYS;
The above steps resolved those invalids.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps