Hi,
apex version 5.1 and 18.1 ( and preferably future proof ).
This topic has been discussed ( more or less ) many times but I'm trying to find a solution which is 100% solid and also not based on non supported internal views.
Hope somebody from the apex dev team picks up on this .
To clearify, my end goal is to develop an application which makes it easy to detect which apex internal messages need to be translated for an application. ( I know there are downloads for this which you can upload containing 99% of the messages but the business case is more complex ).
Is there an apex supported view which contains all ( and only ) the predefined apex messages for self developed applications for the language for which you've installed the apex environment ?
So far I've come up with APEX_APPLICATION_TRANSLATIONS which contains all the apex messages for all applications ( including the standard apex dev gui ) but one issue is that that requires apex_admin_role to be able to query the 4000 to 5000 (internal) applications. Second isse is that if you are able to query that it also seems to contain much more messages than needed for translating an app.
My goal is to be able to determine for each apex version which messages need to be translated in order to have a 100% translation (and would be great if I coudl also see which are used in an application). I know there is an internal message list in the docs for each version but it is never 100% complete and I'm not able to use that list in an dynamic (translation) application, only if I copy the entire list to a table and manually add the ones missing in the docu.
If I check APEX_APPLICATION_TRANSLATIONS for application 4411 ( Oracle APEX System Messages and Native Types ) this seems to be complete but also it's overcomplete since it contains all kinds of texts which are not used in self developed apex applications but only in the development gui.
Anybody know of a supported view which contains all and only those applicable to self developed applications, maybe by setting a filter on some kind of flag field ?
Another option would be if I was able to query all apex messages for a specific self developed application but the base language of an application is not available in APEX_APPLICATION_TRANSLATIONS so maybe it's stored somewhere else ???
Thanks for your attention so far!
Cheers,
Bas