BI Publisher11g OBIEE Datasource Report Auditing Is Not Working And DB Table IAU_BASE Is not Updated Due To 'java.lang.NumberFormatException.forInputString' Errors

(Doc ID 2085513.1)

Last updated on JULY 20, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version to [Release 11.1]
Information in this document applies to any platform.


BI Publisher is integrated with OBIEE BIEE. After setting up 11g OBIEE datasource auditing, the IAU_BASE table is empty.

Analytics does successfully populate the S_NQ_ACCT DB table.

The audit details are only written into $DOMAIN_HOME/servers/bi_server1/logs/auditlogs/xmlpserver/audit.log, and not written into DB. No error messages are received.

The following setup documentation was used:

<Note 1939128.1> - OBIEE 11g - How To Configure Audit Datasource


Administrator's Guide for Oracle Business Intelligence Publisher


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms