My Learning

Define audit group Security>Audittrail>Groups see documentation for more info Note: When you first create the audit group the group status will be 'Enable Requested'  this will automatically be changed to 'Enabled' once th e  AuditTrail Update Tables concurrent request is run Define columns to be audited Security > AuditTrail>Tables Enable auditing for schema owners Security > Audittrail>install Enable ‘AuditTrail Activate’ profile option Submit the AuditTrail Update Tables concurrent request If Request fails with   “Fatal error in fdasql, quitting Fatal error in fdacv, quitting Fatal error in fdaupc, quitting “ check this out  Fatal error in fdasql

While running  AuditTrail Update Tables concurrent request on e-business suite R12(12.1.3) as part of audittrail enable process the request completed with  Fatal error in fdasql, quitting.... Fatal error in fdacv, quitting.... Fatal error in fdaupc, quitting  error.     To fix the issue Check if you have enabled auditing for  APPLSYS,APPS and the application schema owner you want to audit, if not enable the auditing for the schema you wish to audit. And also check the logfile to see if its failing at View AP_SYSTEM_PARAMETERS_ALL_AC1,  If so change the group status for the Audit Group AP_SYSTEM_PARAMETERS_ALL to disable – purge table   Now submit the   AuditTrail Update Tables program again