Audit Trail Causing ORA-01704: String Literal Too Long (Doc ID 1952692.1)

Last updated on MAY 01, 2017

Applies to:

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

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