A-0950

🆓

Warning

Always follow naming conventions for application items.

Naming APEX All APEX versions APEX_APPLICATION_ITEMS • Check and SQL-based Test

Rule Details

Severity Level: Minor
Quality Area: Maintainability
Fixing times: 10 mins

Local-high
Database Support: OracleDB (v7.3.4 +)

Reason

Application items should follow a consistent naming convention so they are easy to recognise in shared components and page logic.

Rename non-conforming items under Shared Components → Application Items and update all references.

Example

Non-Compliant Example

appItem APP_DEBUG (
  // ...
)

Compliant Solution - ★★★★★

appItem AI_APP_DEBUG (
  // ...
)

Tests

Test SQL query

select aa.workspace || '.' || aa.alias || '.' || ai.item_name as identifier,
       'Application item ' || ai.item_name || ' of app ' || aa.alias || ' in ' 
       || aa.workspace || ' does not match '#ApexAppItemPattern#'.' as message
  from apex_application_items ai
  join apex_applications aa   
    on aa.application_id = ai.application_id
       and aa.workspace = ai.workspace
 where not regexp_like(ai.item_name, #ApexAppItemPattern#)
   and ai.workspace in (#ApexWorkspaces#)

Test results

Identifier	Message	Migration
WORKSPACE.CUSTOMERS.APP_DEBUG	Application item APP_DEBUG of app CUSTOMERS in WORKSPACE does not match '^AI_.+$'.	-

Parameters

Use parameters to customize the rule to your needs.

Parameter	Description	Default Value
ApexAppItemPattern	Case-sensitive regular expression pattern for APEX application items.	^AI_.+$
ApexWorkspaces	Comma-separated List of APEX workspaces owning APEX applications to check.	dblinter, dbl_gui

References

same as UC-0950