Siebel Admin: Enabling Find on 8.0.0.2

1. Below Tools changes

Add following business object components list for Business Object = "Search Execution"

1. List Mgmt Prospective Contact

2. ERM Employee

3. Order Entry - Orders

4. Product Defect

5. Consumer

6. Campaign Members

7. Opportunity

8. Service Request

9. Account

2. Run this command connecting to the db:

SELECT

T1.CONFLICT_ID,

CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),

CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),

T1.LAST_UPD_BY,

T1.CREATED_BY,

T1.MODIFICATION_NUM,

T1.ROW_ID,

T1.FIND_NAME,

T1.INACTIVE_FLG,

T1.NAME,

T1.APPLICATION_ID,

T2.NAME,

T2.PROJECT_ID,

T3.LOCKED_FLG,

T3.LOCKED_BY,

T3.NAME,

T3.UIFREEZE_FLG,

T3.UIFREEZE_BY,

T1.REPOSITORY_ID,

T2.OBJ_LOCKED_LANG,

T2.OBJ_LOCKED_FLG,

T2.OBJ_LOCKED_BY,

T2.MODULE_NAME

FROM

dbo.S_APPL_FIND T1

INNER JOIN dbo.S_APPLICATION T2 ON T1.APPLICATION_ID = T2.ROW_ID

LEFT OUTER JOIN dbo.S_PROJECT T3 ON T2.PROJECT_ID = T3.ROW_ID

WHERE

(T2.NAME = 'Siebel Universal Agent' AND T1.INACTIVE_FLG != 'Y')

ORDER BY

T1.NAME

3. You will get a update ID say 'xyz'. Run the below command:

update dbo.S_APPL_FIND set INACTIVE_FLG = 'N' where APPLICATION_ID ='42-8VT-LGY'

4. Lock Application = Siebel Universal Agent

Under 'Siebel Universal Agent' Application, Add Application Find = Service Request. Likewise add other Buscomps that need to be activated.

Compile 'Siebel Universal Agent' Application (Complile Selected Object) & Restart the services.

5. Install DB Server to get the seed_find.dat & seed_find.inp files to be imported.

Copied the content to the local drive and modify the file siebel.ini. Set:

OverwriteConfig = yes

6. Imported seed data changes [using the seed_find.dat & seed_find.inp files got after step 5 (located in //20412/SES/dbsrvr/ENU Folder) ] by running the below command:

For Windows: dataimp /u SADMIN /p SADMIN /c "siebel_DSN" /f "d:/../seed_find.dat" /i "d:/../seed_find.inp" /d ora03102 /Z Y /L logimp.log

For Solaris: dataimp /u sadmin /p sadmin /c "siebel_DSN" /f "/export/home/qa3/seed_find.dat" /i "/export/home/qa3/seed_find.inp" /d dbo /Z Y /L logimp.log

7. Import FindAttach_80.sif:

a. Install siebel Tools.

b. Locate the file in TOOLS/REPPATCH/FindAttach_80.sif

c. In tools.cfg, set SymStrPrefix = SBL_ instead of X_

e. Open Tools [SADMIN/MSSQL]. Lock projects: Fast Search, Service, Siebel Universal Agent [Fast Search OR Service OR Siebel Universal Agent]

f. Import FindAttach_80.sif

g. compile the imported changes to the siebel srf

8. Put the SSC_Config File location Information in Search Admin > Search Engine Settings.

9. Started Siebel Services.

***Tools changes that need to made for Find Results available in Buscomp View:

Connect to Tools, navigate to Applet in Object Explorer. Query for Applet Name = "Find Applet", Choose Applet User prop -> GotoView and set the value to empty to display the results directly in the view and if we set the User prop GotoView value to "Find Results View", the results will be displayed in the same page where we have the find categories

***To make a field available for Find in Search Applet, Goto Find (query for the Bus Obj Comp) and under it check 'Display In Entry' for required fields. Compile the changes.