I have configured my SiteMinder Policy Server to audit to an Oracle Database in the SiteMinder Management Console under the Data tab, the audit store has been created and I'm able to test the connection, but I cannot see any record in the audit table.
The following query returns 0 rows:
select * from smaccesslog4;
In this case this is the expected behavior even though you have configure the audit connection in the SiteMinder Management Console, you have not selected any event to audit.
Audit events can be enabled in the SiteMinder Management Console under the Logs Tab -> Policy Server Audit log.
The following events can be configured: