Datapatch - ORA-65047: Object SYS.VALIDATE_APEX Is Invalid Or Compiled With Errors In Root
(Doc ID 2586483.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Application Express (APEX) - Version 5.0.4.00 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
On : APEX 5.0.4.00 version on Container Database (aka Multitenant)
When attempting to apply a patch with post-install datapatch the following error occurs:
ORA-65047: Object SYS.VALIDATE_APEX is invalid or compiled with errors in root.
The issue can be reproduced at will with the following steps:
1. Apply the patch.
2. Try to perform the after Patch steps (datapatch)
3. See the error in log
Due to this issue, users cannot patch the databases.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document