Extensibility

One of the major advantages of APEX Document Management over other third-party-systems is its extensibility. As it runs inside your Oracle DB you can just query the tables and build your own automations around it via PL/SQL.

Data model

All tables and columns use comments. Feel free to explore the data model and understand the relationships between different entities.

For example it can make sense to store a reference to a folder or document ID in your own tables to link them together.

Hooks

This functionality allows you to hook into various events within the APEX Document Management system. You can create your own PL/SQL procedures that will be executed when specific events occur, such as document creation, updates, or deletions.

You can use this to implement custom business logic, enforce security policies (aborting actions), or integrate with other systems.

In the administration section you can specify which of your own PL/SQL procedures should be executed for which event. The configuration page also gives you an example on the required procedure structure.

What not to touch

If you want to still get support and be able to install patches and updates, please follow these rules:

• Do not modify
  • ADM database objects (tables, views, packages, etc.)
  • The APEX app
• Do not add referential constraints to ADM database objects that are not on delete cascade or on delete set null
• Do not directly insert into adm_tables. Use the documented PL/SQL APIs instead.