Audit Trail Causing ORA-01704: String Literal Too Long

(Doc ID 1952692.1)

Last updated on MAY 01, 2017

Applies to:

Siebel CRM - Version 8.2.2.4 SIA [23030] and later
Information in this document applies to any platform.
**Checked for Relevance on 15 Nov 2016**

Symptoms

Customer Statement:
--------------------
A custom business component contains a significant number of custom fields. Audit Trail is enabled for this custom business component, including auditing delete operations.

The business component is also a child BC of another BC, and the Link between the two has the Cascade Delete property set to Delete.

Issue:
Given a parent record with one or more child records, then when deleting a record from the parent BC, Audit Trail fails to audit the Delete action for the child BC. The database raises an ORA-01704 message.

What works:
When inactivating some of the custom fields, the error messages do not occur anymore.

Environment:
--------------------
Siebel 8.2.2.4 SIA [23030] on IBM AIX 7.1 on POWER Systems (64-bit) & Oracle DB 


Error Messages:
--------------------
SBL-DBC-00111: An error has occurred writing to a record.
SBL-DAT-00236: An error has occurred while deleting the record.
SBL-BPR-00100: This error is returned when the workflow/task is executing the Siebel Operation business service.
SBL-BPR-00187: Error updating business component at step 'Delete'.
ORA-01704: string literal too long


Steps:
--------------------

By following these steps the issue can be reproduced:

1. Delete a record on the affected business component.



Cause

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