Issue with Space Character in AUDIT_LOG Column From S_AUDIT_ITEM Table (Doc ID 3018471.1)

Last updated on APRIL 29, 2024

Applies to:

Symptoms

AUDIT_LOG Column in S_AUDIT_ITEM table is having space character when performing Associate or Disassociate operations on Audit Trail Buscomp

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

1. Login to Siebel Application
2. Go to Sitemap--Administration-Audit Trail
3. Create new record with below values
   • BusComp: CUT Address
   • Base Table: S_ADDR_PER
   • Set Update, New, Delete, Assoc properties to True
4. From the Field View Tab, create below fields
   • Street Address
   • Address Name
   • Country
5. Connect to the Data base
6. Execute the below query
   • SELECT * FROM SIEBEL.S_AUDIT_ITEM WHERE BUSCOMP_NAME='Audit Trail Buscomp' AND OPERATION_CD='Associate' ORDER BY CREATED DESC;
7. Select the record which is having empty value in UDIT_LOG column
8. From the 'View Value' window, copy the empty value
9. We can see space character is being copied even the column value is empty.

Note: Due to the space character in the column (the column value is displaying as empty. But when we copy the value from the column, then space value is copied) validations are failing at the Batch jobs for the downstream systems.

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.