Inserting a Record into a Table S_AUDIT_ITEM Without Bind Variables
Last updated on APRIL 27, 2018
Applies to:Siebel CRM - Version 188.8.131.52 [IP2014] and later
Information in this document applies to any platform.
It was reported that when merging / deleting contacts application is inserting a record into a table S_AUDIT_ITEM without bind variables
The behavior was reproduced in the latest versions of the applications 16.18 and 17.4
Insert statements in S_AUDIT_ITEM table should use bind variables, the query without bind variables affects database shared_pool memory usage and performance.
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