A-1060 Try to assign applications to an application group.

Severity Info Check + SQL-based Test Free New

APEX_APPLICATIONS

Rule Details

SonarQube Severity: Minor
Quality Area: Maintainability
Fixing Time: 1 min Local-easy
Database Support: OracleDB (v7.3.4 +)
Profile: Aggressive
Available Since: Oct 5, 2026

Reason

Application groups organise the application list of a workspace. Once a workspace holds more than a handful of applications, ungrouped apps make it hard to find the right one and to apply group-wide conventions. Assign each application to a group under Application Properties › Application Group.

Small workspaces do not need groups; the check only applies from the number of applications set in ApexMinAppsForGroups.

Example

Non-Compliant Example

app CUSTOMERS (
    // ...
    // no applicationGroup
)

Compliant Solution - ★★★★★

app CUSTOMERS (
    // ...
    group: Sales
)

Tests

Test SQL query

select aa.workspace || '.' || aa.alias as identifier,
       'App ' || aa.alias || ' in ' || aa.workspace || ' is not assigned to an application group.' as message
  from apex_applications aa
 where aa.workspace in (#ApexWorkspaces#)
   and aa.application_group is null
   and #ApexMinAppsForGroups# <= (select count(*)
                                    from apex_applications a2
                                   where a2.workspace = aa.workspace)

Test results

Identifier	Message	Migration
WORKSPACE.CUSTOMERS	App CUSTOMERS in WORKSPACE is not assigned to an application group.	-

Parameters

Use parameters to customize the rule to your needs.

Parameter	Description	Default Value
ApexMinAppsForGroups	Minimum amount of apps in a Workspace to require apps to be in groups	5
ApexWorkspaces	Comma-separated List of APEX workspaces owning APEX applications to check.	dblinter, dbl_gui

References

same as UC-1060