EIM: Audit trail import in V8.0 using EIM_AUDIT_ITEM (Doc ID 859904.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 8.0.0.2 [20412] and later
Information in this document applies to any platform.

Goal

If we load the sample data for audit trail using EIM without loading any data in AUDIT_LOG column, The imported data is visible on UI and at the table level also FIELD_NAME,NEW_VAL and OLD_VAL columns data is visible.
The difference is when we are trying to create a record through UI, in S_AUDIT_ITEM table FIELD_NAME,NEW_VAL and OLD_VAL columns are populated null. The only column that gets populated is AUDIT_LOG

Document "Decoding Siebel 8.x Audit Trail data (Doc ID 796113.1)" states that for overall siebel application performance the above three columns are encrypted and loaded into AUDIT_LOG column when we create a record through UI.

Need correct approach to import Audit Trail data into S_AUDIT_ITEM using EIM_AUDIT_ITEM in V8.

Solution

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