My Oracle Support Banner

adudbsnGetAPPSSchemaInfo: selecting info from AD_APPL_TOPS failed (Doc ID 336300.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Application Object Library - Version 11.5.2 to 11.5.10.0 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Patch 3618299 failss while running arhdqupg.sql with the following error :

------------------------------------------------------------
  Start time for file is: Sun Sep 25 2005 01:04:44
 
  sqlplus -s APPS/***** @<AR_TOP>/patch/115/sql/arhdqupg.sql
   
  PL/SQL procedure successfully completed.
   
   
  PL/SQL procedure successfully completed.
   
  BEGIN
  *
  ERROR at line 1:
  ORA-01403: no data found
  ORA-06512: at "SYSTEM.AD_APPS_PRIVATE", line 571
  ORA-06512: at "APPS.HZ_UTILITY_V2PUB", line 1598
  ORA-06512: at "APPS.HZ_PARTY_STAGE", line 7728
  ORA-06512: at line 2
-------------------------------------------------------

And added to this ADCTRL also doesnt work , it fails with the following error

-----------------------------------------------------
 AD Controller error:
 adudbsnGetAPPSSchemaInfo: selecting info from AD_APPL_TOPS failed
      
 AD Controller error:
 ORA-01403: no data found
   
 adctrl_main(): Error while calling  adudbsnGetAPPSSchemaInfo()
--------------------------------------------------------

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.