Good day!
Our problem is back

The problem is that this request returns empty (
SELECT E.[Name], EV.[Description], E.[SS_Key], 'xif' as Kind, AD.[Id] as ApplicationDefId, NULL as ESpaceId, E.[Id] as ExtensionId, @LibModuleLayerId as Layer, 1 as IsSelected, 0 as IsDeleted FROM {Extension_Version} EV Inner JOIN {Extension} E ON E.[VERSION_ID] = EV.[ID] Inner JOIN {Module} M ON M.[EXTENSION_ID] = E.[ID] Inner JOIN {App_Definition_Module} ADM ON ADM.[MODULE_ID] = M.[ID] Inner JOIN {ApplicationDef} AD ON ADM.[APPLICATION_ID] = AD.[APPLICATIONID] Left JOIN {ModuleDef} MD ON MD.[EXTENSIONID] = E.[ID] WHERE E.[IS_ACTIVE] = 1 AND AD.[ISDELETED] <> 1 AND MD.[ID] IS NULL
), so Oracle throws a constraint error:
integrity constraint (OSADMIN.OSFRK_OSUSR_MRN_MODULED2_42096) violated - parent key not found
If you comment out this block, then all assigned layers by modules and applications disappear, so this is not an option