ORA-03113 on Trigger update

Changes to trigger of template, linked to couple thousand of hosts results in:

SQL error ORA-03113: end-of-file on communication channel

Trigger has >=9 functions within the expression.
Different trigger updates with 1-2 functions succeeds.

Error and query attached as file: error

Oracle support suggests fragmenting monolith query and feeding it with smaller chunks.
And explains that extensive size queries will be dropped by backend DB.

Issue found on zabbix v 5.4, but probably all current LTS versions are affected also.