Hi everyone,
We are running 16 APEX applications on version 24.2, all of which function normally.
However, when we try to use the utility Database Object Dependencies with the options Full Scan and Application, the process fails for some applications and no report is produced. The error returned is:
ORA-20987: APEX - ORA-06592: CASE not found while executing CASE statement
From our testing, the issue appears to occur only when the scanned application has active working copies. Applications without working copies are scanned successfully and the utility works as expected.
Does anyone know of a possible workaround? We need to analyze the impact of significant database structure changes, but we cannot pause the ongoing work being done in active working copies.
Best regards,
Dan