SBL-DBC-00111, ORA-01400 and ORA-06512 - Cannot Insert Null Into Audit Trail Table (Doc ID 963803.1)

Last updated on AUGUST 01, 2017

Applies to:

Siebel Audit Trail - Version 8.0 [20405] and later
Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.

Symptoms

It was reported that when a user deleted an Opportunity record where Audit Trail had been enabled for tracking changes to the Opportunity Business Component, the following error occurs:

An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
[2] ORA-01400: cannot insert NULL into ("XXXXX"."S_AUDIT_ITEM"."ITEM_IDEN_NUM")
ORA-06512: at line 85


The same errors were also encountered with other business components.

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