Thursday, February 14, 2013

Date Error Message Customization

During a recent OBIEE 11g project the user requested a more "descriptive" date format error; huh; how did they get to that. After some Q&A with the user found out that they put in 2123/2013 as the date under a date prompt at that OBIEE sent a nice red error back stating "2123/2013 is not a valid date value" user issue was it didn't say what was acceptable. So my job was to make that more descriptive. So I found that in the following path: "OracleBIHome"\OracleBI_1\bifoundation\web\msgdb\l_en\messages\uicmsgs that there is a file called obiprp.propmtcomponents.xml which houses several of the messages around Date/Time errors. I modified (after taking a backup of the original file) in particular the WebMessage named "kmsgPromptRunTimeInvalidDateErrorMsgFormatStr" to a more descriptive error with a suggested format, saved the file, restarted the BI Suite and The message was more to the user's liking. There are several other messages based on Date/Time within this file as well so if you need to change a differnt one that is where I would start.