Portal User asked a question.
Oracle audit user script
The Oracle audit script in this KB -
still references these EBS tables -
APPS.AP_INVOICES_ALL
APPS.RA_CUSTOMER_TRX_ALL
APPS.RA_CUSTOMER_TRX_LINES_ALL
The queries that Flexera uses to read these invoice tables can potentially take a long time to finish. From what I can tell the data that they collect are written to dbo.ServiceProviderApplicationUsagePerMonth in the IM database, however it doesn't appear that the compliance import even scans this table during the compliance import. Is it OK if we remove these entries from the audit user script?
Peter:
I am not sure of the impact of removing access to these tables in the create User audit script. If the current FlexNet Agent DB scan is selecting from these tables and the audit user does not have access, then it is possible that the agent scan will fail and no Oracle DB inventory would be collected.