Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Running APEX Database Object Dependencies

Jon DixonMay 22 2025

APEX 24.2.4 running on 19c of the database on-premise.

I get the following error when using APEX Database Object Dependencies for certain Apps:

ORA-20987: APEX - ORA-01086: savepoint 'START_SCAN' never established in this session or is invalid

Use Case 1

It seems that if there are errors, records do show up in the apex_used_db% views. This app has 90 pages.

Use Case 2

If there are no errors, I get the same error message, but no records show up in the apex_used_db% views for the App when the scan completes. This app has 28 pages.

For a smaller app (5 pages), it does complete successfully.

This post has been answered by Jeff Kemp-Oracle on May 26 2025
Jump to Answer
Comments
Post Details
Added on May 22 2025
2 comments
142 views