Prior to upgrading to APEX 26.1, we were using APEX 24.2.13. Since upgrading to APEX 26.1, I have not been able to deploy code using SQLcl Project. I'm receiving the following error when trying to deploy:
SQL> project deploy -file artifact/FESSCA-sprint32-1.zip -verbose
Check database connection…
Extract the file name: FESSCA-sprint32-1
Artifact decompression in progress…
Artifact decompressed: /var/folders/87/lvs5ppdn57g06t63zt0fvcxm0000gq/T/cb8eb405-f901-4252-b496-679729297b7d11134589812036187803
Starting the migration…
Installing/updating schemas
--Starting Liquibase at 2026-07-09T10:02:01.395078 using Java 20.0.2 (version 4.30.0 #0 built at 2025-04-01 10:24+0000)
Running Changeset: releases/apex/f165/f165.xml::INSTALL_165::SQLCL-Generated
Migration failed, error reported:
PL/SQL procedure successfully completed.
--application/set_environment
APPLICATION 165 - FESSCA
--application/delete_application
--application/create_application
--workspace/credentials/social_fessca
--workspace/credentials/credentials_for_harvard_open_ai
--workspace/credentials/fessca_gmas
--workspace/credentials/okta_fessca
--workspace/remote_servers/go_apis_huit_harvard_edu
--workspace/remote_servers/harvard_open_ai
--application/shared_components/plugins/dynamic_action/pl_sebastiancichosz_floating_scrollbar
--application/shared_components/plugins/dynamic_action/mho_redirect
--application/shared_components/plugins/dynamic_action/com_oracle_apex_ftr_comments_da
--application/shared_components/plugins/dynamic_action/com_talan_set_dialog_title_ss
--application/shared_components/plugins/dynamic_action/be_apexrnd_aop_convert_da
begin
*
ERROR at line 1:
ORA-20987: APEX - Plug-in with APEXlang Name "ucApexOfficePrintAopConvertDa" can not be found in the application 109. Please ensure a plug-in with the same APEXlang Name exists in the master application and try again.
Alternatively, you can set the "Subscription Mode" as "Ignore Errors", to ignore invalid master component references.
ORA-06512: at "APEX_260100.WWV_FLOW_ERROR", line 1186
ORA-06512: at "APEX_260100.WWV_FLOW_ERROR", line 1251
ORA-06512: at "APEX_260100.WWV_IMP_UTIL_INT", line 3008
ORA-06512: at "APEX_260100.WWV_IMP_UTIL", line 87
ORA-06512: at line 2
https://docs.oracle.com/error-help/db/ora-20987/
Migration failed, error reported:
PL/SQL procedure successfully completed.
--application/set_environment
APPLICATION 165 - FESSCA
--application/delete_application
--application/create_application
--workspace/credentials/social_fessca
--workspace/credentials/credentials_for_harvard_open_ai
--workspace/credentials/fessca_gmas
--workspace/credentials/okta_fessca
--workspace/remote_servers/go_apis_huit_harvard_edu
--workspace/remote_servers/harvard_open_ai
--application/shared_components/plugins/dynamic_action/pl_sebastiancichosz_floating_scrollbar
--application/shared_components/plugins/dynamic_action/mho_redirect
--application/shared_components/plugins/dynamic_action/com_oracle_apex_ftr_comments_da
--application/shared_components/plugins/dynamic_action/com_talan_set_dialog_title_ss
--application/shared_components/plugins/dynamic_action/be_apexrnd_aop_convert_da
begin
*
ERROR at line 1:
ORA-20987: APEX - Plug-in with APEXlang Name "ucApexOfficePrintAopConvertDa" can not be found in the application 109. Please ensure a plug-in with the same APEXlang Name exists in the master application and try again.
Alternatively, you can set the "Subscription Mode" as "Ignore Errors", to ignore invalid master component references.
ORA-06512: at "APEX_260100.WWV_FLOW_ERROR", line 1186
ORA-06512: at "APEX_260100.WWV_FLOW_ERROR", line 1251
ORA-06512: at "APEX_260100.WWV_IMP_UTIL_INT", line 3008
ORA-06512: at "APEX_260100.WWV_IMP_UTIL", line 87
ORA-06512: at line 2
https://docs.oracle.com/error-help/db/ora-20987/
Unable to rollback Scripts automatically, taking no action.
Unable to rollback Scripts automatically, taking no action.
UPDATE SUMMARY
Run: 0
Previously run: 59
Filtered out: 0
-------------------------------
Total change sets: 76
ERROR: Exception Details
ERROR: Exception Primary Class: DatabaseException
ERROR: Exception Primary Reason: Error occurred and failonerror set to true, stopping execution.
ERROR: Exception Primary Source: 4.30.0
Please review automatically generated error log:
sqlcl-lb-error1783616532857.log
For additional information run using -debug and/or -log parameters.
An error has occurred:
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset releases/apex/f165/f165.xml::INSTALL_165::SQLCL-Generated:
Reason: liquibase.exception.DatabaseException: Error occurred and failonerror set to true, stopping execution.
Error occurred and failonerror set to true, stopping execution.
Enabling APEX automations
PL/SQL procedure successfully completed.
Log file(s) location: /Users/michaelfollansbee/Documents/Harvard/AuroraFaculty/aurora-faculty-fessca
Removing the decompressed artifact: /var/folders/87/lvs5ppdn57g06t63zt0fvcxm0000gq/T/cb8eb405-f901-4252-b496-679729297b7d11134589812036187803...
SQL>
We have a Master Plug-in app in our Development environment that contains all the plug-ins that we use. In App 165, the app that I'm trying to deploy to our Test environment, this is one of the plug-ins that we subscribe to from the Master Plug-in app.
The Master Plug-in app is only in our Development environment.
If I look at the same plug-in in our Test environment, this is what I see:
All of our plug-ins in our non-development environments look the same.
I tried setting set_subscription_mode to c_subscription_ignore and c_subscription_remove, but I get the same errors.
begin
apex_application_install.clear_all;
apex_application_install.set_workspace('ATSAPEX');
apex_application_install.set_subscription_mode(p_mode => apex_application_install.c_subscription_ignore );
end;
/
Is this the correct way to set_subscription_mode?
I'm on APEX 26.1.1, and I'm using SQLcl 25.3.2.0. Should I be using SQLcl 26.x?
Any help would be greatly appreciated.