Hello APEX Community,
I'm looking for a workaround for a limitation with APEX_COLLECTIONS.
I have a modular APEX solution consisting of multiple applications within the same workspace. All applications share the same authentication scheme and session cookie, allowing users to navigate seamlessly between applications.
My requirement is to create a collection only once after the user logs in and reuse it across all applications in the workspace. The collection stores user-specific data such as roles, organizational units, permissions, and other lookup information that is used by authorization schemes, VPD, and application logic.
Unfortunately, APEX collections are scoped to a single application session, so they cannot be accessed from another application, even when the applications share the same workspace and session.
I noticed there is an Oracle APEX Ideas request (FR-253) for workspace-level collections, but it has remained on the roadmap for quite some time.
I'm wondering if anyone has implemented a clean workaround for this scenario.
Thank you!