Database Objects
The summary below describes all database objects created after installing the APEX Office Edit sample application or after installing AOE as a standalone plug-in in an existing Oracle APEX application using a DDL script.
- column The plug-in describes whether an object is required for the AOE to run outside the sample application
- column Supporting object describes whether an object is required for the sample application installation
Tables
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| AOE_DEFAULT_FILES |  | | The table is used as the default source type for the most basic implementation of AOE |
| AOE_DEFAULT_VERSIONS | | | The table is used to store document versions when built-in versioning is enabled |
| AOE_REST_LOGS | | | The table is used by the AOE RESTful service module to log information about requests performed by the AOE host server to load and update document content |
| AOE_CONFIG | |  | The table is used by the sample application to provide the plug-in components settings directly in the sample application. Also, the table stores information about the AOP license key required for some integration examples. |
| AOE_CUSTOM_TBL | | | The table is used by the sample application in an example implementation using a custom table. |
| AOE_FILES_CUSTOM | | | The table is used by the sample application in an example implementation using a custom table. |
| AOE_FILES_UPLOAD | | | The table is used by the sample application to allow the uploading of end-user documents |
| AOE_API_STAGING | | | The table is used by the sample application in an example implementation using a custom table. |
| AOE_BUCKET_CONFIG | | | The table is used by the sample application in an example implementation using a custom table. |
| AOE_BUCKET_FILES | | | The table is used by the sample application in an example implementation using a custom table. |
| AOE_EXT_FILES | | | The table is used by the sample application in an example implementation using a custom table. |
Sequences
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| AOE_DEFAULT_FILES | | | Required by AOE_DEFAULT_FILES |
| AOE_DEFAULT_VERSIONS | | | Required by AOE_DEFAULT_VERSIONS |
| AOE_REST_LOGS_SEQ | | | Required by AOE_REST_LOGS |
| AOE_FILES_UPLOADED_SEQ | | | Required by AOE_FILES_UPLOAD |
| AOE_API_STAGING | | | Required by AOE_API_STAGING |
Triggers
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| BI_AOE_DEFAULT_FILES | | | Required by AOE_DEFAULT_FILES |
| BI_AOE_DEFAULT_VERSIONS | | | Required by AOE_DEFAULT_VERSIONS |
| BI_AOE_REST_LOGS | | | Required by AOE_REST_LOGS |
| AOE_CONFIG_BIU | | | Required by AOE_CONFIG |
| AOE_CUSTOM_TBL_BIU | | | Required by AOE_CUSTOM_TBL |
| BI_AOE_FILES_CUSTOM | | | Required by AOE_FILES_CUSTOM |
| BI_AOE_FILES_UPLOADED | | | Required by AOE_FILES_UPLOAD |
| AOE_API_STAGING_BIU | | | Required by AOE_API_STAGING |
| AOE_BUCKET_CONFIG_BIU | | | Required by AOE_BUCKET_CONFIG |
| AOE_BUCKET_FILES_BIU | | | Required by AOE_BUCKET_FILES |
Packages
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| PIP_CRYPTO | | | The package is used to secure the access token |
| UC_UTF7 | | | The package is used to decode document filenames from UTF7 to UTF8 |
| AOE_REST | | | The package is used by the RESTful Service handlers to handle requests performed by the AOE host server |
| UC_PLUGIN_UTIL | | | The package is used to evaluate an APEX region's read-only attribute |
| AOE_PLUGIN | | | This package implements a region-type plug-in for Oracle APEX |
| AOE_SAMPLE_APP_UTIL | | | The package is used by the sample application to handle page processes and implement custom callbacks |
| AOP_API22_PKG | | | The APEX Office Print package is used by the sample application to showcase the integration of AOP and AOE |
| AOE_APEX_CONTEXT_MENU | | | The package is used by the sample application to implement a context menu using the United Codes APEX Context Menu |
| AOE_CALLBACK_PKG | | | The package is used by the sample application to showcase the usage of the PL/SQL callbacks |
| AOE_EXT_AWS_PKG | | | The package is used by the package AOE_CUSTOM_PKG to showcase a custom PL/SQL implementation for Amazon S3 Cloud |
| AOE_EXT_FILES_PKG | | | The package is used by AOE_CUSTOM_PKG to showcase a custom PL/SQL implementation based on filesystem. |
| AOE_EXT_OCI_PKG | | | The package is used by AOE_CUSTOM_PKG to showcase s custom PL/SQL implementation for Oracle Cloud OCI |
| AOE_CUSTOM_PKG | | | The package is used by the sample application to showcase a custom PL/SQL implementation of AOE. |
| AOE_PERMISSION_PKG | | | The package is used by the sample application to show a custom PL/SQL implementation of permissions returned from a custom function. |
Indexes
| Object Name | Supporting object | The plug-in | Description |
|---|---|---|---|
| AOE_DEFAULT_FILES_TEXT_IDX | | | Oracle Text index used by the sample application to showcase searching documents for given search phrase |
| AOE_DEFAULT_VERSIONS_TEXT_IDX | | | Oracle Text index used by the sample application to showcase searching documents for given search phrase |
| AOE_FILES_CUSTOM_TEXT_IDX | | | Oracle Text index used by the sample application to showcase searching documents for given search phrase |
Other scripts
| Object Name | Type | Supporting object | The plug-in | Description |
|---|---|---|---|---|
| RESTful Service | Script | | | The script creates the APEX Office Edit RESTful Service Module, which handles all AOE operations on documents |
| AOE_PURGE_LOGS | JOB | | | The JOB is used by the sample application to purge old AOE REST logs |