In oracle apex 23.2.0, getting ora exact fetch return more than requested number of rows when trying to search across one or more applications.
By searching apex_debug_messages I found two errors:
- Error: ERR-7620 Could not determine workspace for application ().
- Error: Application "" Page "" not found.