Ques: While exporting we are getting more records than expected.
Ans:We got a Defect today , we are getting more records while exporting.In List applet we are having 27 records but while doing export we are getting much more than that.
So how to Resolve??
So what we found is , we have written a Script on Applet Load and that is Named Search Spec which is causing that issue.
So as per as our requirement we can't remove that as well.So how to resolve Export issue.
So to resolve this we need to write a Script on Applet_PreInvoke
Here is the Script:
function WebApplet_PreInvokeMethod (MethodName){ if (MethodName == "ExportQuery") { this.BusComp().SetNamedSearch("Activties", "") this.BusComp().SetSearchExpr("[Category] = LookupValue('TODO_TYPE', 'Document')"); } return (ContinueOperation);}
Note: The Named Search spec should be same as of Which we have in Applet Load.
if the applet Load is having other search criteria then we need to include the same in the script of PreInvoke
Issue Resolved :)
Happy Learning
Monday, October 31, 2011
Wednesday, September 21, 2011
How to Clear Cookies using batch File in Siebel
Hi All,
Requirement :How to clear cookies & Temp File in siebel.
In Siebel we are selecting a LOV value and after selecting the LOV value click on GO button then it will open a Shopping cart portal. The issue is that after adding the item your cart it will show you the Amount.But if you closed the shopping cart window and open it again it is showing the same amount this is the issue it should not show the previous amount.
Solution: We have to create a batch File with the following statement:
RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255
pause@echo off"%PROGRAMFILES%\Internet Explorer\IEXPLORE.EXE" http://www.yourshoppingportalwebsite.com
save the text file with .bat eextension. eg Test.bat
Now we have the save the file in particular Drive or Folder.For eg i saved @ C:\Test.bat
Then we have to invoke the bat file using script:
Browser Script:
var shell=new ActiveXObject("WScript.Shell");
shell.Run("C:\\Test.bat",1);
Server Script:
Clib.system("C:\\Test.bat");
Note: I tried Clib.system() in browser script but it didn't work.
Happy Learning :-)
Requirement :How to clear cookies & Temp File in siebel.
In Siebel we are selecting a LOV value and after selecting the LOV value click on GO button then it will open a Shopping cart portal. The issue is that after adding the item your cart it will show you the Amount.But if you closed the shopping cart window and open it again it is showing the same amount this is the issue it should not show the previous amount.
Solution: We have to create a batch File with the following statement:
RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255
pause@echo off"%PROGRAMFILES%\Internet Explorer\IEXPLORE.EXE" http://www.yourshoppingportalwebsite.com
save the text file with .bat eextension. eg Test.bat
Now we have the save the file in particular Drive or Folder.For eg i saved @ C:\Test.bat
Then we have to invoke the bat file using script:
Browser Script:
var shell=new ActiveXObject("WScript.Shell");
shell.Run("C:\\Test.bat",1);
Server Script:
Clib.system("C:\\Test.bat");
Note: I tried Clib.system() in browser script but it didn't work.
Happy Learning :-)
Monday, January 24, 2011
Search Ctrl+Shift+F , Search feauture is disabled in 8.0
Hi All,
Today i come across with a issue realated to search.We face this issue while upgrading from 7.8 to 8.0.
Issue: While pressing the Ctrl+Shift+ F button in siebel application we are getting an Error:
" The Responsibility of user 'SADMIN' doesnot allow accessing 'Search Looking View'.(SBL-DAT-003329)"
Now What to Do?
Resolution: The Issue was resolved when i added the Screen " Search View Dummy Screen' under the Screen Menu Item of the application that we are using.
Steps:
1) In Tools Goto the Objects :Application
2) Select you Customized Appliaction
3) Go the Screen Menu Item
4)Lock the Application
5) Create a new record under the Screen Menu Item
6)Screen: Search View Dummy Screen
7)Unlock the Objects
8) Compile it
Now you can see the difference..Its working Ctrl+Shift+F :)
Happy Learning :)
Today i come across with a issue realated to search.We face this issue while upgrading from 7.8 to 8.0.
Issue: While pressing the Ctrl+Shift+ F button in siebel application we are getting an Error:
" The Responsibility of user 'SADMIN' doesnot allow accessing 'Search Looking View'.(SBL-DAT-003329)"
Now What to Do?
Resolution: The Issue was resolved when i added the Screen " Search View Dummy Screen' under the Screen Menu Item of the application that we are using.
Steps:
1) In Tools Goto the Objects :Application
2) Select you Customized Appliaction
3) Go the Screen Menu Item
4)Lock the Application
5) Create a new record under the Screen Menu Item
6)Screen: Search View Dummy Screen
7)Unlock the Objects
8) Compile it
Now you can see the difference..Its working Ctrl+Shift+F :)
Happy Learning :)
Monday, January 3, 2011
Coming Soon.. Siebel Upgrade from 7.8 to 8.0
Hi All,
Very soon i will update this blog process of Siebel upgrade from 7.8 to 8.O.
Its not specifinc to 7.8 to 8.0..you will follow these steps in all the the upgrade from 7.5.x to 8.x.x.
Most of the thing remain same. Except few if you are upgrade from 7.5 or 7.7 to 8.x.x.
So have a eye on this blog..i will post it soon.
Thanks,
Manish Mamgain
Very soon i will update this blog process of Siebel upgrade from 7.8 to 8.O.
Its not specifinc to 7.8 to 8.0..you will follow these steps in all the the upgrade from 7.5.x to 8.x.x.
Most of the thing remain same. Except few if you are upgrade from 7.5 or 7.7 to 8.x.x.
So have a eye on this blog..i will post it soon.
Thanks,
Manish Mamgain
Wednesday, May 6, 2009
Configure a Join.
Configure a Join.
7 may 2009
It is my effort to provide an explanation on joins and step by step procedure on how to configure them in Siebel.
First of all I will try to explain what the join is.
There are two type of commonly used joins
Implicit Join
Explicit Join
Implicit Join: - Implicit Join are those which are already define in Siebel and which are internally use by the Siebel to pull the values from the other than base table.
example: - join between base table and extension table like S_OPTY and S_OPTY_X and join between S_PARTY and S_ORG_EXT
Explicit Joints: - Explicit Joints are those which are define by the developer to create the relationship between two tables.
Let’s take a real life example to understand the concept of Joins better.
We have one table of the Employee where Name, Employee Id and other information about the employee is stored.Another table stores a list of Cities.
Requirement is to know which user stays in which city. There are two ways to do it
Store city in the Employee table which will result in data redundancy.
Store Primary key of city table in the employee table and pull the values at the run time, which is more efficient and makes more sense.
To implement second approach we use joins in Siebel.
You have to follow the following five steps to have joined field on UI in Siebel
1. Identify the column to be used as Foreign key.2. Configure field which will store the primary key of join table.3. Configure a join.4. Configure join specification.5. Add a field which will be used at Applet.
An example will make things more clear.
Suppose we want to have Opportunity Name on the Quote Applet. Here is a step by step procedure with screen shots explaining how to do that.
1. Identification of Column to act as foreign key.
To configure a Join, first of all we have to find out a column in the base table where we can store primary key say (ROW_ID) of opportunity in quote which will become the basis of join.
If there is no column vacant in the base table we can use extension table for that base table e.g S_DOC_QUOTE_X for the S_DOC_QUOTE.
Note: Make sure that the column you choose is not being used by any other BC or any other field of same BC.
2. Configure Field in Business Component
Go to Business Component > Field
Create a new record
Enter the name of the field.
Enter extension table name in Join field if the column you identified belongs to extension table otherwise go to step 5
Select the Column identified in column Field.
Note: The column which you have selected must have physical Type varchar.Our Foreign key is now ready for use. Now we have to configure a joined Field which will use this foreign key
3. Configure/Create a Join
Go to Business Component > Join
Create new record.
Give name of the table with which you want create join ( S_OPTY in our case)
Give Name in Alias (New in our case).
Check the Outer join Flag (Very Important).
Go to Object List Explorer (OBLE) on the left hand side and click + sign beside join there will be two options Join Specification and Join Constraints
4. Configure Join Specification
Create New Record.
Give Name in the Name field.
Destination Column is given by default when insert a new record. You can change it if you want to.
In the Source field give the name of the source field (OptyID) which you have configured earlier to be used as Foreign Key.
5. Configure the field (Opportunity Name) which you want to display on the User Interface.
Go to Business Component > Field
Insert New Record
Give Name in the Name Field
Enter the Join Alias which you have given for the join you created.
Select the Name (for Opportunity Name) in the column field. Column name here represent the data that you want to pull from opportunity.
6. Configure the Control in the Applet (UI).
Go to Applet > Control (if Form Applet)
Go to Applet > List > List Column (if List Applet)
Create New Record.
Enter the Name
Enter the name you want to display on UI in Caption Override Field
Enter the Name of the field you created in Field column
Don’t forget to map this field in Applet. Right Click on the corresponding Applet and map it.
Now compile the entire project which you have made the changes and you will be able to see this joined field in the Quote Applet as shown in the picture below.
When you see this field in User Interface it will be read only because when the data is pull from the join table it is only read only, to make it editable you have configure Pick Applet on this field
7 may 2009
It is my effort to provide an explanation on joins and step by step procedure on how to configure them in Siebel.
First of all I will try to explain what the join is.
There are two type of commonly used joins
Implicit Join
Explicit Join
Implicit Join: - Implicit Join are those which are already define in Siebel and which are internally use by the Siebel to pull the values from the other than base table.
example: - join between base table and extension table like S_OPTY and S_OPTY_X and join between S_PARTY and S_ORG_EXT
Explicit Joints: - Explicit Joints are those which are define by the developer to create the relationship between two tables.
Let’s take a real life example to understand the concept of Joins better.
We have one table of the Employee where Name, Employee Id and other information about the employee is stored.Another table stores a list of Cities.
Requirement is to know which user stays in which city. There are two ways to do it
Store city in the Employee table which will result in data redundancy.
Store Primary key of city table in the employee table and pull the values at the run time, which is more efficient and makes more sense.
To implement second approach we use joins in Siebel.
You have to follow the following five steps to have joined field on UI in Siebel
1. Identify the column to be used as Foreign key.2. Configure field which will store the primary key of join table.3. Configure a join.4. Configure join specification.5. Add a field which will be used at Applet.
An example will make things more clear.
Suppose we want to have Opportunity Name on the Quote Applet. Here is a step by step procedure with screen shots explaining how to do that.
1. Identification of Column to act as foreign key.
To configure a Join, first of all we have to find out a column in the base table where we can store primary key say (ROW_ID) of opportunity in quote which will become the basis of join.
If there is no column vacant in the base table we can use extension table for that base table e.g S_DOC_QUOTE_X for the S_DOC_QUOTE.
Note: Make sure that the column you choose is not being used by any other BC or any other field of same BC.
2. Configure Field in Business Component
Go to Business Component > Field
Create a new record
Enter the name of the field.
Enter extension table name in Join field if the column you identified belongs to extension table otherwise go to step 5
Select the Column identified in column Field.
Note: The column which you have selected must have physical Type varchar.Our Foreign key is now ready for use. Now we have to configure a joined Field which will use this foreign key
3. Configure/Create a Join
Go to Business Component > Join
Create new record.
Give name of the table with which you want create join ( S_OPTY in our case)
Give Name in Alias (New in our case).
Check the Outer join Flag (Very Important).
Go to Object List Explorer (OBLE) on the left hand side and click + sign beside join there will be two options Join Specification and Join Constraints
4. Configure Join Specification
Create New Record.
Give Name in the Name field.
Destination Column is given by default when insert a new record. You can change it if you want to.
In the Source field give the name of the source field (OptyID) which you have configured earlier to be used as Foreign Key.
5. Configure the field (Opportunity Name) which you want to display on the User Interface.
Go to Business Component > Field
Insert New Record
Give Name in the Name Field
Enter the Join Alias which you have given for the join you created.
Select the Name (for Opportunity Name) in the column field. Column name here represent the data that you want to pull from opportunity.
6. Configure the Control in the Applet (UI).
Go to Applet > Control (if Form Applet)
Go to Applet > List > List Column (if List Applet)
Create New Record.
Enter the Name
Enter the name you want to display on UI in Caption Override Field
Enter the Name of the field you created in Field column
Don’t forget to map this field in Applet. Right Click on the corresponding Applet and map it.
Now compile the entire project which you have made the changes and you will be able to see this joined field in the Quote Applet as shown in the picture below.
When you see this field in User Interface it will be read only because when the data is pull from the join table it is only read only, to make it editable you have configure Pick Applet on this field
Thursday, February 12, 2009
veryy soon Shuttle Applet..an interesting topic to learn
Shuttle Applet B/W Contact and Opportunity( For M:M relation Ship b/w 2 Table)
1 Create a Link or use existing Link B/W Contact and Opportunity. Link must have Property i.e Inter Table , Inter Parent Column and Inter Child Column
2 Create a New Multivalue Link having properties like..i.e
Name--Test Con Opp MVL
Destination Business Component—Opportunity
Destination Link--Contact/Opportunity
Primary Id Field—
Note : Here Primary Id Field is a field that specifies the name of the field in the master business component that holds the Row ID values pointing to the primary record in the detail business component.
3 Create New MVF Under same BC with following Properties .i.e
Name--Test Con Opp
MVL--Test Con Opp MVL (use which you have created)
Field--Key Contact Id(Field exist on child BC )
4 Create New MVG Applet with the help of Wizard having diff properties like...i.e
Name--Test Con Opp MVG
Project—Contact
B.C—Opportunity(Child B.C )
Associate Applet--Test Con Opp Asso
Type—MVG
Child Object—Applet Web Template
5 Create Associate Applet by the help of wizard choosing MVG Applet and having diff properties like...i.e
Name-- Test Con Opp Asso
Project—Contact
B.C—Opportunity(Child B.C
Type— Association List
And for Applet Web template
6 In Contact--Contact form Applet ---Create new control to display Shuttle Applet
In Controls
Name-- Test Shuttle
Field-- Test Con Opp(MVF you have created)
MVG Applet--- Test Con Opp MVG(MVG applet that already created)
Now go to Edit web layout---->and place that Control that you have created
7. Compile All Changes
1 Create a Link or use existing Link B/W Contact and Opportunity. Link must have Property i.e Inter Table , Inter Parent Column and Inter Child Column
2 Create a New Multivalue Link having properties like..i.e
Name--Test Con Opp MVL
Destination Business Component—Opportunity
Destination Link--Contact/Opportunity
Primary Id Field—
Note : Here Primary Id Field is a field that specifies the name of the field in the master business component that holds the Row ID values pointing to the primary record in the detail business component.
3 Create New MVF Under same BC with following Properties .i.e
Name--Test Con Opp
MVL--Test Con Opp MVL (use which you have created)
Field--Key Contact Id(Field exist on child BC )
4 Create New MVG Applet with the help of Wizard having diff properties like...i.e
Name--Test Con Opp MVG
Project—Contact
B.C—Opportunity(Child B.C )
Associate Applet--Test Con Opp Asso
Type—MVG
Child Object—Applet Web Template
5 Create Associate Applet by the help of wizard choosing MVG Applet and having diff properties like...i.e
Name-- Test Con Opp Asso
Project—Contact
B.C—Opportunity(Child B.C
Type— Association List
And for Applet Web template
6 In Contact--Contact form Applet ---Create new control to display Shuttle Applet
In Controls
Name-- Test Shuttle
Field-- Test Con Opp(MVF you have created)
MVG Applet--- Test Con Opp MVG(MVG applet that already created)
Now go to Edit web layout---->and place that Control that you have created
7. Compile All Changes
Tuesday, February 3, 2009
Difference between Contraint PickList and Hierearchial Pickl ist
Constraint Picklist:While configuring Constraint PickList, we use two different picklist for parent and child field and both picklist should based on PickLIst Genericbusiness component
Hierarchial Picklist:while for hierarchical, both fields(parent and child) uses the same picklist and picklist is based on PickList Hierarchical Business component.E-x Country--State-District.
To Create Hierarchial picklist refer to:http://blogs.oracle.com/siebelessentials/2008/11/hierarchical_picklists_unveile.html
Hierarchial Picklist:while for hierarchical, both fields(parent and child) uses the same picklist and picklist is based on PickList Hierarchical Business component.E-x Country--State-District.
To Create Hierarchial picklist refer to:http://blogs.oracle.com/siebelessentials/2008/11/hierarchical_picklists_unveile.html
Subscribe to:
Posts (Atom)