Peoplesoft Message Catalog Table

Navigation of Peoplesoft Message Catalog Table: PeopleTools > Utilities > Administration > Message Catalog

By default language

Step 1. input Message Set Number, description and description short

Message Set Number store in a table: PSMSGSETDEFN

Using SQL for select data by this syntax

SELECT * FROM PSMSGSETDEFN ORDER BY MESSAGE_SET_NBR

/* Related Language Record */ 
SELECT * FROM PSMSGSETLANG ORDER BY MESSAGE_SET_NBR

SELECT * FROM PSMSGSETDEFN ORDER BY MESSAGE_SET_NBR

/* Related Language Record */

SELECT * FROM PSMSGSETLANG ORDER BY MESSAGE_SET_NBR

Step 2. input Message Number and detail

Message Number store in a table: PSMSGCATDEFN

Using SQL for select Detail of message catalog and message number

SELECT * FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

/* Related Language Record */ 
SELECT * FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

SELECT * FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

/* Related Language Record */

SELECT * FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

By owner language

select message catalog and detail by PSMSGSETLANG

SELECT * FROM PSMSGSETLANG ORDER BY MESSAGE_SET_NBR

1	SELECT * FROM PSMSGSETLANG ORDER BY MESSAGE_SET_NBR

select detail in message number of message catalog by PSMSGCATLANG

SELECT * FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

1	SELECT * FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR ='29000' AND MESSAGE_NBR ='1'

You can using this message catalog in peoplesoft for store html, sql, dynamic sql, description, bind variables and use data in page or scroll area or grid of each requirements by using select sql of catalog table or use function in peoplesoft such as msggettext or msggetexplaintext in peoplecode language.

More learning at How to use MsgGet, MsgGetText and MsgGetExplainText by Peoplecode Function of Peoplesoft