Thursday, January 29, 2009

FND Logging

Profile Options used are:FND: Debug enabledFND: Debug pathFND: Debug%ModuleFND:Debug%Level%

We can save log messages in 6 levels: statement, procedure,event,warning, error, exception

PLSQL API used to enter log messages: fnd_log.string(level, message,module)

Most advantages are :

  1. we can enable debugging, whenever we want
  2. debug messages are autonomous transactions.
  3. we can purge these messages whenever we want using standard purge program

FND table: fnd_log_messages