Restrict D Entry of Characters(List Column/Control)

Scenario: User is not allowed to type more than 200 characters in the Service Request Summary field.  

Solution: The length of the fields can be restricted on the application UI level with the help of the Field User Property called Text Length Override. Below is the syntax for configuring this Field User Prop:

Syntax:

Name: Text Length Override
Value: <length>

Steps:

• Login into Siebel Tools.
• Query for a Service Request Business Component and expand its child object in the object explorer.
• Select field and Query for an Abstract field.
• Expand the child object of Abstract field and select Field User Prop.
• Create a New Record and Type the following :
1. Property Name: Text Length Override
2. Value               :  200 
• Compile the changes and Test it.

Setting Local Developer in Siebel

Overview of Steps:

Sr.No	Task	Where To Performed
1	Setting Up Database Users	RDBMS (DBA Part)
2	Creating Positions	Apps – Admin User Screen
3	Associating Responsibilities	Apps – Admin User Screen
4	Setting Up Developers as  Siebel Employees	Apps – Admin User Screen
5	Setting Up Developers as Mobile Web Clients	Apps – Siebel Remote Screen
6	Generating a New Database Template	Apps – Server Config Screen
7	Extracting the Local Database	Apps – Server Config Screen
8	Initializing Each Developer's Local Database	Siebel Tools
9	Performing a Full Get	Siebel Tools
10	Perform a Repository Compilation	Siebel Tools

 

1.Setting Up Database Users
Use the following Script to Create a Database User
 •Microsoft SQL Server Script [ T-SQL ]
      Use master
              go    
             CREATE LOGIN ‘USER_NAME’ WITH password = ‘USER_NAME’,
             CHECK_POLICY = off,     DEFAULT_DATABASE = DATABASE_NAME
             go
             use DATABASE_NAME
             go
             sp_adduser ‘USER_NAME’, ‘USER_NAME’, SSE_ROLE
             go

•Oracle Database Server Script [PL SQL ]
    create user ‘USER_NAME’ identified by ‘USER_NAME’;
    grant sse_role to ‘USER_NAME’;
    alter user ‘USER_NAME’ default tablespace &&siebel_tablespace;
    alter user ‘USER_NAME’ temporary tablespace &&temp_tablespace;



2.Create the Position in Siebel Application

3.Create a New Responsibilities
4.Create a Employee in Siebel & Associate Position & Responsibility

5.Setting Up Developers as Mobile Web Clients

6.Generating a New Database Template
7.Extracting the Local Database

8.Initializing Each Developer's Local Database

9. Performing a Full Get

10. Perform a Repository Compilation

Enjoy the Post.....................


:)

Siebel EIM

Introduction to Siebel EIM

Description :

Siebel EIM is one of the activity in the Siebel CRM Application to import, export, update and delete the bulk amount of data into siebel crm database with maintaining the referential integrity. It is one of the Server component which involves in the No of Process before Inserting the new data into siebel CRM database. It uses a EIM table as staging area to provide the data directly to base or Extension tables.

With the Help of mapping from Applet Control to BC Field and Table to Column we can find the Which EIM table we should use to insert the data into Siebel Tables.

Below Image will give more clear picture of Siebel EIM mapping.

Few More Post will Upload soon on different scenarios.


Thanks & Regards,
Asif Faheem Ansari