Find Message Catalog Entries Missing From Your Project
When you're working on a large project in Application Designer, you can end up creating or updating a number of message catalog entries. Because this is done outside of Application Designer, there is a good chance you might end up leaving some of them out of your project.
The following SQL is my attempt to find message catalog entries that were modified in the last 14 days for a particular message set and to check whether or not they exist in your project definition. Obviously this isn't going to be accurate in all cases, but scanning through the results of the query may help you identify message catalog entries that were missed.
To use this SQL:
- Specify your message set number (you might want to check more than one message set, or even the whole message catalog?)
- Specify how far back you want to check for changes (default is 14 days)
- Specify the name of your application designer project
select MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_TEXT, LAST_UPDATE_DTTM from PSMSGCATDEFN MCD where MESSAGE_SET_NBR = 99999 and trunc(LAST_UPDATE_DTTM) >= sysdate - 14 and not exists ( select 1 from PSPROJECTITEM where PROJECTNAME = 'YOUR_APP_DESIGNER_PROJECT' and OBJECTTYPE = '25' and OBJECTVALUE1 = MCD.MESSAGE_SET_NBR and OBJECTVALUE2 = MCD.MESSAGE_NBR );