My Oracle Support Banner

EIM Exports CLOB Columns Such as S_AUDIT_ITEM.S_AUDIT_LOG as NULL (Doc ID 2757600.1)

Last updated on JUNE 12, 2023

Applies to:

Siebel CRM - Version 20.2 and later
Information in this document applies to any platform.


When EIM exports CLOB columns such as S_AUDIT_ITEM.AUDIT_LOG the corresponding column in the EIM table, EIM_AUDIT_ITEM.AUDIT_LOG , is always NULL.

This is not restrict to audit table. Any CLOB column is exported as NULL.

The issue can be reproduced at will with the following steps:

1. Run an EIM export job to export data from S_AUDIT_ITEM into EIM_AUDIT_ITEM

2. Confirm records are created in EIM_AUDIT_ITEM

3. But no data is available in AUDIT_LOG column




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.