Getting ORA-06564 With AD_ZD_TABLE.UPGRADE On External Table
Last updated on SEPTEMBER 25, 2017
Applies to:Oracle Applications DBA - Version 12.2.2 to 12.2.4 [Release 12.2Cloud]
Information in this document applies to any platform.
Getting error ORA-06564 when running ad_zd_table.upgrade on EXTERNAL TABLE to register the table during an upgrade.
This can be reproduced with the following steps:
1. Attempt to register the custom table:
2. The following error occurs:
ORA-06512: at "APPS.AD_ZD_TABLE", line 1100
ORA-06512: at "APPS.AD_ZD_TABLE", line 1213
ORA-06512: at line 1
00000 - "object %s does not exist"
*Cause: The named object could not be found. Either it does not exist
or you do not have permission to access it.
*Action: Create the object or get permission to access it.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms