My Oracle Support Banner

New session id is generated at database level whenever new record is inserted through Open UI Account Contact List Applet (Doc ID 2324785.1)

Last updated on APRIL 02, 2019

Applies to:

Siebel CRM - Version 16.5 [IP2016] and later
Information in this document applies to any platform.

Symptoms

New session id is generated at database level whenever new record is inserted through Open UI Account Contact List Applet.

Reproducible Steps:

1. Login to Siebel Application OM

2. Run the following SQL query in Oracle SQL Developer:

select sql_id,status,username,machine,sid,serial# from v$session where username='SADMIN';

This will return the corresponding session id at database level for the new Siebel Session.

3. In Siebel Application navigate to Accounts > Accounts Home > click on any Recent Record > Contacts.

Under Screen: Accounts Screen, View: Account Detail - Contacts View, Business Object: Account
Applets: Applet[0]: SIS Account Entry Applet; Applet[1]: Account Contact List Applet;

click on Contacts:New (++) in order to add and activate a new Contact record. Save the new record.

4. Immediately after the saving of the record a new SID is generated at DB level. Check again the v$session and you will see that a second session is generated.

If under the same Siebel session the user create multiple Contacts only one additional SID is created at database level.

Changes

 No changes has been performed.

Cause

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
Symptoms
Changes
Cause
Solution
References


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