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
    );
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License