Saturday, December 26, 2015

Organization Structure in Siebel

Organization Structure in Siebel is defined as following:
1. Define Currencies
2. Define Organization
3. Define Divisions
4. Define Position
5. Define Responsibility
6. Setup Employees
1. Define Currencies:
To define currencies we need to navigate to Site Map --> Admin Application --> Currencies --> Create a currency here.
2. Define Organization: 
To define Organization we need to navigate to Site Map --> Admin Group --> Organization --> Create an Organization here.
3. Define Division:
To define Division we need to navigate to Site Map --> Admin Group --> Divisions --> Create a Division here.
4. Define Position:
To define Position we need to navigate to Site Map --> Admin Group --> Position --> Create a position here.
5. Define Responsibility: 
To define position we need to navigate to Site Map --> Admin Application -->  Responsibilities --> define the responsibility here.
Position :
Position determines Access to Data in Siebel application.
Responsibility: Responsibility determines Access to View in Siebel application.
We group set of views as a responsibility and we will assign this responsibility to the employee.
6. Setup Employee: 
Creating an Employee in Siebel is a two way process, we need to create the Employee at the application level and also at the DB level. As Siebel does not maintain passwords at the application level we need to setup the USER ID at application level and again User ID and Password at DB level.
Create the Employee at Application Level: 
To Create an Employee at Application level we need to navigate to Site Map --> Admin User --> Employees --> Create an Employee
Create the Employee User ID & Password at the db Level: 
Navigate to Siebel Installation folder -- >  Web Client --> Bin --> search for "dbisqlc" and double click on the 'dbisqlc'  and provide the below details,
User ID: DBA
Password: SQL
After giving the user ID and password, --> Click on Database Tab Option, Keep the file on the database file option and browse of the db file i.e., your dbf file path.
Ex: siebel\webclient\Sample\UTF8\sse_samp.dbf
Navigate to SQL Window and execute the below command.
SP_ADDLOGIN<User Name>, <Password>
Ex: SP_ADDLOGIN TOM, XYZ
SP_ADDUSER<User Name>, <Password>, SSE_ROLE
Ex SP_ADDLOGIN TOM, XYZ, SSE_ROLE
Note: In Siebel Data model Employees and Responsibilities are M:M relationship and employees and positions are M:M relationship positions and responsibilities are not directly related.









Seed Data

Seed Data is the data that is required to run any SIEBEL application and this data by default comes with our SIEBEL installation.
Example: Default Organization, Siebel Administrator position etc.,