Skip to Main Content

Release History

  • Team APE 19-AUG-2024

    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
  • Team APE 06-JUN-2024

    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.

  • Team APE 01-DEC-2023

    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.

  • Team APE 20-JUN-2023

    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.

  • Team APE 06-MAR-2023

    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.

  • Team APE 29-NOV-2022

    APE 22.3.1 is now available for download.

     

    This release contains minor fixes for the APE 22.3 release.

     

  • Team APE 08-NOV-2022

    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.


     

  • Team APE 11-JUL-2022

    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
  • Team APE 29-JUN-2022

    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.


     

  • Team APE 21-JAN-2022

    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.

     


     

  • Team APE 23-JUL-2021

    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.
  • Team APE 06-MAY-2021

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

  • Team APE 15-MAR-2021

    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.
  • Team APE 17-NOV-2020

    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)
  • Team APE 13-JUN-2020

    APE 20.1.2 is now available and includes Session Replay!

    Fixed an issue with manual registration.

  • Team APE 31-MAY-2020

    AOP 20.1.1 is now available.

    Updated the supporting objects to accommodate older database versions.

  • Team APE 13-MAY-2020

    AOP 20.1 released: Initial Release.