Workflow is filling up FND_LOG_MESSAGES

This is a problem I have posted about previously, but since I just presented some of this information during my session at COLLABORATE, I think the new post on MOS "Workflow Messages Are Filling Up FND_LOG_MESSAGES" via article ID 2006609.1 comes along at exactly the right time for EBS Support personnel!  Find out what else you need to be looking for, besides the profile options to get logging turned off for this table!

EBS R12 Security Issue: FND_LOG_MESSAGES

Were you aware that when you upgrade to E-Business Suite R12 one of the changes introduces a very serious security issue?  Read this note from CERT to find out what happened to the FND_LOG_MESSAGES table with the upgrade to R12 and why it is the root cause for the issue I shared at the beginning of the year about the volume growth for FND_LOG_MESSAGES!

R12: Workflow Agent Listener Service logging

Yesterday I posted the what of our problem with FND_LOG_MESSAGES, but I never explained the WHY of it.  I'll rectify that right now!

In the course of our investigation we found MOS note 741087.1 which suggested that our settings for the Workflow Agent Listener Service were set wrong.  Guess what?  They were!  This note is good to review as well to confirm the settings are correct for the FND: Debug Log profile options in your EBS application.

R12: FND_LOG_MESSAGES

Along the lines of my presentation, and published article, I bring you new details of another vector you need to verify to not bloat your database.  Looking into the space consumption of our database post R12 upgrade, the DBAs found that the table FND_LOG_MESSAGES was taking up 13% of our space in PROD so they found My Oracle Support document 735138.1 which details how to purge this information.  Why is this related to R12 you ask?  Based on some of the data analysis scripts in my article, I substituted in FND_LOG_MESSAGES and found that prior to R12 our monthly total in this table was just under 3.5 million rows added back in 2010.  Yet, the largest volume of data added to this table was in October when we went to R12 of over 320 million rows.  Okay, sure the system churn and processing might be excessive when installed so let's look at the next highest month that's been completed; in November we more than 233 million rows added to FND_LOG_MESSAGES, which is an increase over 67 times between our previous high and the following month after R12 was installed!

I have a few more nuggets of information to share with you about this situation, so stay tuned the next few days if you're interested by this!

EDIT: I realized I forgot to add in the links to my other articles last night!