APE 24.3 is now available for download! This version is compatible with APEX 19.2 and higher. (for APEX 18.x we ship version 22.3.1)

New features

APE Scorecard

• A new feature in the Insights section that helps you understand the size and complexity of your APEX applications and pages.

Database and ORDS Administration Reports

• The new reports can be found under the Utilities section. They include reports about your database options, schemas, tablespaces, sessions, and other information a developer or DBA may require. Everything is conveniently packed together with other valuable APEX Project Eye insights.

Builder Extensions

APE Scheduler Job Management

• New administration page to manage jobs scheduled by APE
• Manually run a job
• Enable / Disable jobs
• Change running intervals
• Inspect logs
• A new navigation bar entry will appear if scheduler jobs are running in the background.

Improvements

QA

• Rule "UC - Reporting regions should have ordering defined" now ignores badge reports.

Watchtower

• Elapsed times of sensor and scan executions are displayed in a more readable format.

Utilities

• The ER diagram object picker is enhanced with a text filter, making it easy to include only specific tables in the ER diagram.

General

• Two additional authentication schemas are available. One is for DB Accounts, and the other is for Single Sign-On. After the APE installation/upgrade, the current schema can be easily switched to a different one.

Bug Fixes

Insights

• The activity sync calculation failed in the case of background processing activities. This caused no activity data to be visible in the dashboards and all other reports based on the activity log.
• Fixed links to the Mail Queue and Log report pages, which did not include the correct Workspace if it was changed in the filter region.

Quality Assurance

• The rule "UC - Shared Component is never used" was intentionally displayed in the Navigation Bar lists as unused components.
• Transfering exceptions between standards did not transfer all exceptions.
• Live QA Assistant: Invalid HTML code in one of the region sources, resulting in corrupted positioning of buttons and other elements.
• Resolved error that occurred on older database versions during the declarative QA rule generation wizard.

Documentation

• A correct database schema for a selected application is provided in the Owner item.
• JS libraries required for displaying documentation for a selected object are included among static application files. This solves Content Security Policy issues in some environments.

Other

• Installing through script files failed if there was no open APEX session. *

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected, and a long string is translated, it might happen that the 32K limitation in the native APEX procedure that renders the interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error.

Advanced QA rules limitations The advanced rules that assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 24.2 is now available for download! This version is compatible with APEX 19.2 and higher. (for APEX 18.x we ship version 22.3.1)

Overview

This is a minor release that focuses mostly on compatibility with APEX 24.1. Make sure you use this version of APEX Project Eye when installing on APEX 24.1. New Object Utilization Reports will support you with your investigation of how database objects are referenced in your APEX application and other database objects.

New features

• Utilities
  • Object Utilization Reports - New reports to help you identify how database objects are used in your database and APEX application. This will provide you with a useful overview to assess the impact of your database object changes.

Improvements

ER Diagram

• The ER diagram in the utilities section has been extended with the option to display tables referenced by the selected tables with foreign key constraints. Either 1st or 2nd-level connections.

Technical Documentation

• Page groups are added to page titles in the printable template, which makes it possible to group the pages in the generated documentation.

Quality Assurance

• New rule in the UNITED CODES Advanced Quality Standard: UC - Hardcoded IDs in the program logic
• Improvements to the tree region in the assessment overview page

General

• Minor improvements in the license key registration process.
• Overall compatibility with APEX 24.1

APE 24.1 is now available for download! This version is compatible with APEX 19.2 and higher. (for APEX 18.x we ship version 22.3.1)

Overview

This release introduces the Utilities section, where various tools and reports will be delivered in future releases. In the first iteration, the Utilities section includes the LOB2Script utility and the UI Interface Defaults Manager.

The 24.1 release brings minor but powerful enhancements to the Entity Relationship diagram, which now takes advantage of the Database Object Dependency calculation. The Session Replay feature now gives you the ability to jump directly to errors.

New features

Manage APEX user interface attributes

• This feature helps you identify attributes with a high number of occurrences in your applications based on their name.
• It's easier to ensure their properties, like labels and format masks, are consistent in your workspace by creating APEX User Interface Defaults directly from APEX Project Eye.

LOB 2 Script

• This tool makes creating installation scripts for BLOB and CLOB attributes simple. You can even include files like AOP templates in your installation packages.

Improvements

APE Projects

• It's now easier to add and manage applications inside APE Projects
• Option to bulk add multiple applications with activity on newly created APE Project

ER Diagram

• The ER diagram now shows tables and views that are referenced by your APEX application based on APE's Object Dependency calculation. You can filter objects used for a range of Page Groups or a specific page.
• There is another version of the ER diagram in the Utilities section, where you can manually pick tables and views in your DB schema that you want to include in your ER diagram.
• If the DB schema does not have the privileges to add comments to an object, this action does not run into an error but prevents the action with a user-friendly message beforehand.

Session Flow

• A new visual representation of the steps of the session errors occurring in the replay bar.
• Jumping directly to the next or previous error in the session replay
• The "nobody" user is not represented in the session replay anymore

Translation Manager

• Export XLIFF files for single pages

Quality Assurance

• Option to hide rules in the tree view component with 0 issues when inspecting assessment results
• Copy rules directly from the report view
• Transfer all exceptions from one Quality Standard to another
• UC - Shared Component is never used rule has been adapted to exclude Template Components and the Commented out build option

Watchtower

• APE will automatically purge old Watchtower Inbox messages. You can adjust the time interval in the administration settings.

General

• The license key is now validated with a client-side REST call instead of the server-side validation.
• Missing job privileges are now validated when installing or upgrading APEX Project Eye
• APEX Project Eye alerts if the APE_APP_ID is not in sync with your APEX Project Eye application ID.

Bug Fixes

• Technical Documentation
  • Fixed the bug that prevented usernames with special characters (i.e., e-mail addresses) from running the document generation job.
  • The tree view region did not filter based on the "Use referenced objects" setting
• Quality Assurance
  • Missing AOP API key message was still displayed on the assessment results, even if the API key was registered in the administration settings
  • Layout issues on the import/export QA standards modal dialog have been resolved
  • UC - Compatibility mode is not aligned with the currently installed APEX release rule did not work correctly for recent APEX versions.

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected, and a long string is translated, it might happen that the 32K limitation in the native APEX procedure that renders the interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error.

Advanced QA rules limitations The advanced rules that assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 23.2 is now available for download! This version is compatible with APEX 19.2 and higher. (for APEX 18.x we ship APE 22.3.1)

This release includes improvements throughout the APEX Project Eye and is updated to support Oracle APEX 23.2

Improvements

APE Inbox

• The APE Inbox got a new look and feel to increase the user experience

Insights

• Object Dependency calculation includes the new Workflow component which was released in APEX 23.2

Translation Manager

• Declarative Deepl integration setup
• Preview automatic DeepL translations for your translatable text
• The translation manager now works on the autonomous database

Technical Documentation

• A new AOP template includes SQL and PL/SQL sources in regions, validations, dynamic actions and processes.

Quality Assurance

• The UNITED CODES Way of working Quality Standard is enhanced and extended with new rules.
• Export and import exception between different environments

Bug Fixes

Technical Documentation

• The process section was missing in the documentation

Quality Assurance

• Deleting a rule from a standard with an exception assigned was causing a trigger to mutate.
• Resolved some issues with the "UC - Valid SQL or PL/SQL code" rule

APE Watchtower

• It was not possible to delete an escalation channel message

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected, and a long string is translated, it might happen that the 32K limitation in the native APEX procedure that renders the interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error.

Advanced QA rules limitations The advanced rules that assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 23.1 is now available for download! This version is compatible with APEX 19.2 and higher. (for APEX 18.x we ship APE 22.3.1)

With APEX Project Eye (APE) 23.1, we have improved the database object dependency calculation enabling you to run it for all database schemas and applications throughout your workspaces.

Take complete control of the content in your technical documentation with the new Printout wizard.

APE also had a complete makeover making it more intuitive and easier to navigate.

New features

• The UI received a complete makeover. With the new navigation menu, you can access your favorite features faster.

Improvements

Object Dependency Calculation

• APE can now execute the object dependency calculation for all workspaces
• APE can now access database objects in other parsing schemas by installing an interface database package
• New tree view to view referenced database objects
• Newer APEX components are now included in the object dependency calculation
• A new, more complete approach to discovering SQL and PL/SQL code allows APE to analyze cca. 100% more code in your applications.

Technical Documentation

• The new wizard enables you to configure in detail what to include in your technical documentation printout
• You can limit your printout to include only database objects referenced by your APEX application
• Use the change management filters to include only components referenced by a ticket or which have changed in a specific time period

Quality Assurance

• The preloaded Quality Standards are enhanced and extended with new rules also inspired by the APEX advisor
• Changes in the object dependency calculation also reflect rules which assess SQL and PL/SQL code in your applications. Making it possible to validate and proof all of the program logic inside your apps.

Bug Fixes

• General
  • Fixed a bug in the page link calculation, causing an error in case of long link definitions in regional sources
  • Fixed a bug in the email log regions, causing an error in older Database versions
  • Fixed issue which prevented the Live QA Assistant from being configured on APEX 22.2

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected and a long string is translated, it might happen that the 32K limitation in the native APEX procedure that renders the interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error.

Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We know this can present an issue to some users and are working hard to ensure you will not need grants for future releases.

XLIFF manager not supported on the autonomous database: The translation manager is currently unavailable if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

Advanced QA rules limitations The advanced rules which assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 22.3.2 is now available for download. 
APE 22.3.2 is compatible with APEX 19.2 and higher. (for APEX 18.x we ship APE 22.3.1)

With APEX Project Eye (APE) 22.3.2, we are fixing some functionality not working correctly in the latest APEX version.

Bug Fixes

Quality assurance

• Progress bar behavior was not stable in the latest APEX versions.
• Live QA Assistant could not be installed on APEX 22.2

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected, and a long string is translated, it might happen that the 32K limitation in the native APEX procedure that renders the interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error.

Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We know this can present an issue to some users and are working hard to ensure you will not need grants for future releases.

XLIFF manager not supported on the autonomous database The translation manager is currently unavailable if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

Advanced QA rules limitations The advanced rules which assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 22.3.1 is now available for download.

This release contains minor fixes for the APE 22.3 release.

APE 22.3 is now available for download

With APEX Project Eye (APE) 22.3, we are introducing a new monitoring framework titled “APE Watchtower.”

New Features

APE Watchtower

• This monitoring framework allows you to prepare custom sensors based on simple SQL statements and assign them to a scan schedule. Write sensors to keep track of your applications, database, external services, and business processes.
• Set up escalation rules and methods to be notified if measurements exceed expected limits. Use your own procedures to add new ways of escalation.
• Transfer the sensors between environments in JSON format.
• Tailor the dashboard to fit your needs.
• Use the new APE Inbox to manage notifications.
• Start with the preloaded set of sensors and add your own.

Improvements

Quality Assurance

• The UNITED CODES Way of working Quality Standard is enhanced and extended with new rules.
• Access control has been extended with two new roles, "QA Manager" and "QA User," to distinguish users based on their privileges and responsibilities.

Bug Fixes

Quality assurance

• Fixed a few SQL statements in the default UNITED CODES Way of Working Quality Standards.

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected and a long string is to be translated, it might happen that the 32K limitation in the native APEX procedure that renders the Interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error

Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We are aware this can present an issue to some users and are working hard to ensure that grants will not be needed for future releases.

XLIFF manager not supported on the autonomous database: Because of the reasons above, the translation manager is currently not available if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

Advanced QA rules limitations: The advanced rules which assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 22.2.1 is now available for download.

This release contains minor fixes for the APE 22.2 release.

Fixes

• Issues for 12c databases and older
  • Error 1: ORA-00972: identifier is too long
  • Error 2: ORA-40484: invalid data type for JSON_TABLE column

APE 22.2 is now available for download

With APEX Project EYE (APE) 22.2, we have added new features to the Quality Assurance module and Translations Management module.  Activity reporting has also been improved.

New features

• Real-time quality assessments
  • Install QA components directly into your application to have real-time Quality Assessments while you build your applications. You can tailor the behavior of the feature with various settings to maximize your development experience.
• Quality assurance rule builder
  • Use the new rule builder to build your quality assurance rules declaratively. You can even choose existing components in your application from which rules are generated to ensure consistency among components of the same type
• Quality assessment scheduler
  • Schedule quality assessments to run overnight and inspect how the quality of your application is improving daily

Improvements

Quality Assurance

• We've enhanced the look and feel of the Quality Assurance Module. Once an assessment is executed, the user is presented with a progress bar indicating the status of the assessment.
• More printout options. This release comes with a standard Assessment Details Report where users can preselect the details they want to have in their report or upload and generate documents with a custom template.
• A new summary page is added to provide additional insight into your quality assessment results and provide export options
• A new log overview is added to help monitor the duration of each rule inside a single assessment
• New component types have been added.
• An option to purge all assessment history is added.
• A new preloaded UNITED CODES Way of working Quality Standard is available with over 40 rules so you can immediately assess your applications. The rules are split into a basic standard and advanced standard which include rules which help you assess the validity and security of your SQL and PL/SQL code.
• Other minor UI improvements

Translations management

• Manage your translations by integrating with DeepL and automatically translating your application

Workspace and application dashboard

• New application and page overview allows you to sort and inspect your applications or pages easier by sorting on aggregated and calculated data.

Various

•  New regions on the page overview: Activity by user, activity by saved interactive report, and activity by request type.

Bug Fixes

Quality assurance

• Removed bug which caused a unique key constraint violation if a rule was included in two different standards
• Removed bug causing the QA Standard import to fail in specific use cases

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected and a long string is to be translated, it might happen that the 32K limitation in the native APEX procedure that renders the Interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error

Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We are aware this can present an issue to some users and are working hard to ensure that grants will not be needed for future releases.

XLIFF manager not supported on the autonomous database: Because of the reasons above, the translation manager is currently not available if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

Advanced QA rules limitations: The advanced rules which assess your application SQL and PL/SQL rules do not work correctly in case of public synonyms in other database schemas.

APE 22.1 is now available for download

New features

• The first version of the Quality Assurance module
  • Define your APEX and DB Quality rules, group them in Quality Standards or use the preloaded content
  • Transfer Quality Standards between different instances
  • Run Assessments on multiple workspaces, applications, page groups, or pages
  • Review issues identified by rule, APEX component, or severity
  • Manage exceptions
  • Use the quick fix link to navigate directly to the component in the APEX Application Builder and resolve the issue
  • Try the preloaded Quality Standards prepared by the UNITED CODES team

Improvements

Translations management

• Export only strings that have not yet been translated
• Update all occurrences of the same string/text message simultaneously
• Excluded translation strings are not shown in the summary overview anymore

Various

• A new page/user matrix report was added to the application dashboard
• Option to exclude public sessions in the activity reports. With this, overall application stability is improved on high volume systems
• Option to change scheduler job intervals through the application settings

Fixes

• Activity reports
  • Database object summary report aligns on the instance and the workspace dashboard
  • Fixed the behavior of the "Hide expired sessions" filter on the error report
  • Fixed an issue in the workspace dashboard which caused the database objects to not be displayed in some cases
• Object dependency calculations
  • Chart regions are now correctly included in the object dependency reports
• APE Projects
  • Fixed issue when deleting or updating applications on projects

Known issues/limitations

32K limit in Interactive report for the translation manager: If many languages are selected and a long string is to be translated, it might happen that the 32K limitation in the native APEX procedure that renders the Interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error

Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We are aware this can present an issue to some users and are working hard to ensure that grants will not be needed for future releases.

Translation manager not supported on autonomous database Because of the reasons above the translation manager is currently not available if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

APE 21.2 is now available for download

Overview

• APEX Project Eye (APE) 21.2 includes the new translations manager to help you handle XLIFF files to translate your application.
• Some bug fixes and minor improvements for the user interface are also included in this release.

New features

Translation Manager

• Exclude translation strings you don't want to have included in your XLIFF files like queries, substitution strings, or JavaScript code.
• An overview of translation status per language is available in a pivoted report
• Quickly edit translations manually with a convenient HTML preview
• Add statuses and comments to translation strings
• Export multiple XLIFF files at once

Improvements

• Required filters on multiple pages to prevent long loading times on larger applications
• Default docx template improved: Hide empty sections, smaller margins, overall improvements to the look and feel

Fixes

• Solved issue with unhandled characters in the PL/SQL section of the documentation
• Minor bug fixes

Known issues

• 32K limit in Interactive report: If many languages are selected and a long string is to be translated, it might happen that the 32K limitation in the native APEX procedure that renders the Interactive report is hit, producing a "PL/SQL: numeric or value error: character string buffer too small" error
• Privileges needed for the translation manager: The translations manager requires the users to grant SELECT privileges to some APEX internal tables. We are aware this can present an issue to some users and are working hard to ensure that grants will not be needed for future releases.
• Translation manager not supported on autonomous database Because of the reasons above the translation manager is currently not available if the APEX instance is installed on the Autonomous Database server. We are working hard to enable this module in future releases.

Fixed a small issue in ape_utils package when installed in Oracle Database 12.x.

APE 21.1 is now available for download

Overview

• APE 21.1 includes new features that add value to your work, such as the support of PLDOC comment format in documentation generation and the management and debugging tools for application users.
• Improvements have been made to the management of data, with a new lifetime parameter for your activity and access logs.
• Includes many bug fixes and minor improvements for the user interface.

New features

• PL/SQL Documentation generation: The biggest feature in this release is the additional support for PLDOC comment format in documentation generation. APE now supports document generation and printing on the fly for PL/SQL code, commented using PLDOC coding format. A new sample package has been included to demonstrate all of the supported features.
• Custom AOP Templates: the support of custom AOP templates has been introduced in this version. Sample templates are provided, so adapting your documentation to your company's look and feel is easier than ever.
• User management and debugging: A new users tab has been added to the application dashboard. This feature provides insight into:
  • End users using the application and allows you to remotely debug sessions, manage user data, or reset passwords (while using the APEX native authentication mechanism).
  • Workspace users with an activity report and more.
• Email queue and Email log report: Two new reports have been added at the Instance, Workspace and application levels. Now checking your mail queue or mail log is easier from one central point.
• Database object summary report: A report summarizing objects in the database and a full object report have been added. These allow you to check for invalid objects and compile them.
• Table report: A report which displays the top 10 tables by size and full tables report have been added. This includes an option to gather schema statistics to improve your DB performance.
• Application / User Activity Matrix: A report showing the last activity per user, per application has been added. This report allows you to quickly identify inactive applications or users.

Improvements

• Documentation page look and feel: The design of the documentation tab has been adapted to be more readable and attractive. Code highlighting is now available for your procedural code, making it easier to understand.
• Data lifetime parameter: At an application level in a project it is now possible to define the lifetime of data in days. Access and activity data will be purged as per this lifetime. Leave empty to keep your data forever.
• Hide/Show internal workspaces parameter A new parameter was created to allow users to show or display the internal APEX workspaces.
• Link to session id from error report: The error report now includes a link to the session flow diagram, allowing you to quickly replay a session to better understand application errors.
• External JS libraries were updated to the latest versions, bringing a huge improvement to diagram load speed.

Fixes

• Date to default value to today: Default Date to value is now set to today instead of yesterday.
• Dependency calculation fails when no page 1 in application: Dependency calculation process failed as an APEX session was not created if an application did not have a page 1. This has been fixed in this release.
• Multiple schemas linked to a workspace issue: Only one schema was shown when an application had more than one schema assigned to it.
• Logo attributes not valid in applications: A column was removed from the APEX data dictionary view and causes a report to fail to render.
• Minor bug fixes

Known issues

• Dependency calculation fails without the "GRANT CREATE FUNCTION" on the user where APE is deployed. Beware when the user was created manually and not using the APEX Workspace creation wizard.

APE 20.1.3 is now available for download.

Improvements

• Multi-project assignment: A single application can now be assigned to multiple projects, allowing you to monitor an application from within different logical groups.
• Application Name in live preview: Live preview is now displaying the application being edited in application builder.

Fixes

• Session Flow/Same cookie applications: Applications sharing session cookie was previously not displayed correctly on session flow. They are now different by color. A legend was added on the filter pane.
• Replay Session: On the session flow section, the sequence is no longer used to group requests within the same page. Performance improved and CPU usage fix affecting Oracle RAC instances.
• Hidden project name: Project name was not displayed in the breadcrumb when accessed via the Top Applications & Overall Statistics report.  This has now been fixed.
• Minor bug fixes (e.g. Session Flow not showing when no login specified, aligning of objects)

APE 20.1.2 is now available and includes Session Replay!

Fixed an issue with manual registration.

AOP 20.1.1 is now available.

Updated the supporting objects to accommodate older database versions.

AOP 20.1 released: Initial Release.