How to Recreate Missing Advanced Queues ? auque2.sql Shows : "ORA-24010: QUEUE SYSTEM.DEF$_AQCALL does not exist" and "ORA-24010: QUEUE SYSTEM.DEF$_AQERROR does not exist"
(Doc ID 2954121.1)
Last updated on JUNE 13, 2023
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Database for Application Technology
Some advanced queues don't exist after export/import to 19c.
Following document "Export/Import Process for Oracle E-Business Suite Release 12.1 Database Instances Using Oracle Database 19c (Doc ID 2615617.1)". Exporting from 18.104.22.168 and imported into 19.17 database of E-Business Suite version 12.1.3. As part of step 7.1 to reset the Advanced Queues, ran script auque2.sql and found the below errors in the log file stating that the advanced queues "SYSTEM.DEF$_AQCALL" and "SYSTEM.DEF$_AQERROR" does not exist.
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