Most of the time, running the code below from PL/SQL Developer (or any other tool) works fine. An Apex session is created if needed, and a collection is either created or truncated.
Every once in a while however, I get "ORA-02291: Integrity constraint (APEX_230200.WWV_FLOW_COLLECTIONS_FK) violated - parent key not found".
I have seen this on Apex 23.2, so this may a bug that has been fixed since.

begin -- Create an Apex session if needed if v('APP_SESSION') is null then wwv_flow_api.set_security_group_id(p_security_group_id => apex_util.find_security_group_id('TEDSTRUIK')); apex_session.create_session(p_app_id => 25384, p_page_id => 1, p_username => 'USER'); end if; -- Create or truncate collection apex_collection.create_or_truncate_collection(p_collection_name => 'SOME_COLLECTION_NAME'); end; Solutions that usually work: database log off / log on, starting a new instance of PL/SQL Developer, or running it using the debugger.