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:

Symptoms

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

Changes

Cause

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