My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

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.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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