OAM Audting Data is not populated

We enabled OAM auditing through ,

http://docs.oracle.com/cd/E37115_01/admin.1112/e27239/audit.htm#BABHAJCB

In the service instance specified in the domain file ($DOMAIN_HOME/config/fmwconfig/jps-config.xml), enable database auditing by changing the value of the property audit.loader.repositoryType to DB

Infact we can use OAM 11g : How To Configure OAM Audit Configuration (Doc ID 1492681.1)

In spite of all these settings IAU_* tables are not populated with any data.

I found these in logs.

 [ecid: 597cbd9ac221c087:2466da57:1459486cc99:-8000-00000000000008d0,0] [APP: oam_server#11.1.2.0.0] Read configuration parameter Port = 11,598.
[2014-04-24T10:18:11.169-06:00] [wls_oam1] [NOTIFICATION] [OAM-04003] [oracle.oam.proxy.oam] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 597cbd9ac221c087:2466da57:1459486cc99:-8000-00000000000008d0,0] [APP: oam_server#11.1.2.0.0] OAM proxy started. Listening on port 11598.

<Apr 29, 2014 12:15:48 PM MDT> <Error> <oracle.security.audit.logger> <BEA-000000> <IAU:Unable to write Audit Event for Type: OAM>
<Apr 29, 2014 12:15:48 PM MDT> <Error> <oracle.security.audit.logger> <BEA-000000> <IAU:Unable to prepare statement:INSERT INTO IAU_BASE COLUMNS ( IAU_ID, IAU_ComponentType, IAU_InstanceId, IAU_HostId, IAU_HostNwaddr, IAU_ModuleId, IAU_ProcessId, IAU_OracleHome, IAU_HomeInstance, IAU_ECID, IAU_RID, IAU_ContextFields, IAU_SessionId, IAU_TargetComponentType, IAU_ApplicationName, IAU_EventType, IAU_EventCategory, IAU_EventStatus, IAU_TstzOriginating, IAU_ThreadId, IAU_ComponentName, IAU_Initiator, IAU_MessageText, IAU_FailureCode, IAU_RemoteIP, IAU_Target, IAU_Resource, IAU_Roles, IAU_DomainName, IAU_ComponentData, IAU_AuditUser, IAU_TenantId, IAU_TransactionId, IAU_UserTenantId, IAU_AuthenticationMethod ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) >

Also the OAM version was,

    <Setting Name="ProductRelease" Type="xsd:string">11.1.2.1.0</Setting>

The issue is due to a known bug.

Bug 18120234 : OAM 11.1.2.1.0 : IAU:UNABLE TO WRITE AUDIT EVENT FOR TYPE: OAM

The fix is,

SQL> alter table iau_base add (IAU_USERTENANTID VARCHAR2(255));

Table altered.

SQL> alter table iau_base add (IAU_TENANTID VARCHAR2(255));

Table altered.

SQL> alter table iau_base add (IAU_AUDITUSER VARCHAR2(255));

Table altered.

The table structure doesnot have these columns,