Siebel Unleashed

Hi neel

let me know clearly about the role of odbc drivers in siebel,because I think we need to have good knoledge of these things when we are working in a development phase in siebel.
if possible plz explain what is their role and how to set these things to make a good local environment

bye
chaitanya

Hi neel

i had jst started workin on siebel.during my config of screen views,i m having an error—
“An error has occurred creating business component ‘Account -ITT’ used by business object ‘Account-ITT’. Please ask your systems administrator to check your application configuration.(SBL-DAT-00222)”—-
i was trying to create an aggregate view with parent category.

bye
Amit

Hi,
I am working on eCustomer 7.8 version. Our requirement is to provide print /export functionality so that users can directly get a copy of their records in eCustomer. I heard that, it can be done with a combination of JavaScript and custom Business Service. I tried getting information from various websites but I could not get much help. Can you provide details on how should I tackle this. What would be my methodology and logic? Any help in this regard is greatly appreciated.

Hi
Do somebody have the ppt for Siebel 8.0. or something which tell us the journey from Siebel 7.5 to 8.

thanks
Priyanka

Hi

I have created a new BC and trying to provide a attachment functionality to a record.
I configured everything for this functionality but its not working.

Error i am getting while attaching a file is:-

“The attachment applet has been misconfigured. Please make sure that file attachment name field is defined for XYZ Attachment List Applet(SBL-UIF-00440)”

Thanks,
Regard

hi folks, i have a question. Do you know of any other way to refresh an applet aside from ClearToQuery and ExecuteQuery? I’m having a problem refreshing a list applet after some process in the server side. I have also tried InvokeMethod(”RefreshRecord”) but still it didn’t work. Although i have noticed that if i hit the Query button in our UI, the applet gets refreshed of course. I understand that the Query button invokes the “NewQuery” method. I was thinking of invoking this method instead…would you know the syntax for this or any suggestion that you have for refreshing the list applet aside from those that i have already tried. I would appreciate any inputs. Thank you very much.

Hi
You can use a vanilla BS for refreshing Buscomp which is “SIS OM PMT Service”. Here you can use “Refresh Business Component” method of this BS and pass the BusComp’s name and BO name as Arguments. This BS is very interesting and since its vanilla its very effective. It has may more methods which you can explore in siebel tools which could be quite handy when you are scripting.

One catch here folks !!! This BS can be used while invoking with workflows only and not with eScript

hi guys..thanks for the inputs…though it can only be invoked through workflows, still that’s a really helpful information. i appreciate it thanks again! i will look for other options..have a nice day!

@Liz,

you can use BrowserScript ExecuteQuery method to refresh Applet in Applet_Load event.

hi guys,

i have this problem. i want to query the records under S_ESCL_REQ using escript. i tried creating a BC and use S_ESCL_REQ as a base table but to no avail. Siebel creates automatically the system columns when i did the spool such as the ROW_ID. This will create an error since the said column is invalid or non-existing.

do we have another way we could query S_ESCL_REQ rows in Busines Service without creating a Business Component?

Hi AL can you tell us why you have such requirement because the records in S_ESCL_REQ are dynamic and temporary. You may or may not find any specific record from that table based on whether monitor agent has processed that record or not.

Hi Sumit,

Thanks for the reply! I just want to set a condition in my script that would block it from executing if a certain RULE_ID exist in S_ESCL_REQ.

I have a SetFieldValue script that would cause the trigger from firing and add a record in S_ESCL_REQ with RULE_ID. I want to block that script from firing again if i see a record with the same RULE_ID in S_ESCL_REQ. In other words, i dont want to create a new record in S_ESCL_REQ if the RULE_ID is still pending in the monitor.

Hey everyone, I have been working with javascript on a siebel applet. I have been executing various methods including NewQuery with this javascript:
App().InvokeControlMethod(”, (Applet Name Here)’, ‘NewQuery’);
Our applet has an export method which exports the data currently in the list. It opens a pop-up with various options. I need to invoke the Export method via similar above code but I have no idea what the method is called or how to do it. I’ve been playing around but have had no success and I have no application-specific documentation. Does anyone have any ideas?
Thanks,
-Steve

Hi Friends,

I believe I will get a solution for my problem. Recently there were some changes in our siebel application. As part of it, we ran the Assignment rules (Batch)for a country and it seems it messed up the records. Is it possible to undo those changes in any way?.

The primary sales person on those records need to be changed to one who was before to the execution of Batch assignment.

Thanks
Praveen

hello here i have one doubt that i need to set the primary address for contact i need to populate PR_ADDR_ID so i am unable to find the EIM column for this can anybody give me solution

thanks in advance

Hi Neel,
I am having an issue in Send Mail Functionality.
Recipients field (To:) not populating for Microsoft Outlook client.

We are using siebel 8.0.0.2

We have a customized Business Component, and we want to send email from a form applet based on this Business Component, using the F9 button. The Business component is based on S_OPTY,
and we have 3 fields on this BC as
Contact Email Addr mapped to S_OPTY_X.Attrib_46
Contact First Name mapped to S_CONTACT.FST_NAME
Contact Last Name mapped to S_CONTACT.LAST_NAME
Contact Id mapped to PR_CON_ID

in the BC user Properties I have
Recipient Email Address Field value as Contact Email Addr
Recipient First Name Field value as Contact First Name
Recipient Last Name Field value as Contact Last Name

When I click on ‘Send Mail’ button the form applet,it opens up a Comm Template Pick Applet and I select a template and click ok and then it opens up ‘MS outlook’.
It has to automatically populate the Contact Email Address in the ‘To’ field

But it was not working in Siebel 8.0.0.2
The same configuration was working fine in Siebel 7.5.3.15
Do you have any idea? Please let me know if you need any more details

Thanks

Hi neel
I am a new visitor of ur site and i found it really interesting….i got lots of my issues solved…i want to know about web methods and web services…plz throw some light on these topics..

Hi

I am configuring the Shipping functionalty so want to understand the significance of the Billing Address ,Shipping Address and Receiving Address on the “FS Inventory Location Form Applet”.
Can anybody explain?

Thanks in advance.

Hi All,

Just need to ask a very small but challenging thing…My question is that how can we identify activities (records in S_EVT_ACT table) created by autogenerated process like workflows that are older than 13 months.

After lots of R&D i found the foll two condition to somehow satisfy the above..

created_by=updated_by
and Sysdate-upd_date > 13 months.

Not sure this is a right method….Pls hv some comments on it

Hi,

Could any body tell us what issues will make the server/component to crash. Please tell the steps to investigate/restore.

Thanks
vivek

This is to answer the query by venkateshwarlu ON May 8th, 2008 at 9:41 am
***********************
hello here i have one doubt that i need to set the primary address for contact i need to populate PR_ADDR_ID so i am unable to find the EIM column for this can anybody give me solution
************************
For Primary Contact Address, we need set Address ID in “PR_PER_ADDR_ID” that is Primary Personal Address Id. I am assuming that you are refering to the same point. You will have to use “EIM_CONTACT” table. If you go to EIM Table Mapping, then you will see that there S_ADDR_PER table which will have child as Explicit Primary mapping in which we have 3 entries. Out of that we will have to set TRUE for the IF Column CON_PR_PER_ADDR. ONce data in other columns like city, street address etc. is poulated. Contact data will remain same in EIM_CONTACT for each entry of the address. This is in brief.

Hi
I have found this site 1 week before.It’s really good for providing solutions of the questions for all people.I am learning Siebel right now so have one doubt that is
Can we create an extension table with an intersection table?and if it’s possible what’s the processing?Please let me know.

Hi Neel,
I have a question.I am trying to install siebel 8.0 tools on my home PC.
I have installed it and copied the local database from work and when I tried to login to tools -> local with the username and pwd that I use at work it is saying
An internal error has occured within the authentication subsystem - SBL-DAT-00565 .
I copied the tools.cfg also from work.The same cfg file that was working at work is not working on my home PC
Could you please let me know what could be wrong with that .
.
Here is the local section of cfg.
We have DockConnString and EnterpriseServer name parameters with our original server names

[Local]
Docked = FALSE
ConnectString = c:\Siebel\8.0\Tools\local\sse_data.dbf -q -m -x NONE -gp 4096 -c256m -ch256m
TableOwner = SIEBEL
DockedDBFilename = CHANGE_ME
DLL = sscdw9.dll
SqlStyle = Watcom
MaxCachedCursors = 16
MaxCachedDataSets = 16
ReverseFillThreshold = 100
CaseInsensitive = FALSE
InsensitivityFactor = 2
DockTxnsPerCommit = 500
DockConnString =
AutoStopDB = TRUE
EnterpriseServer =
DSDockEncryptDB=TRUE
DSHashUserPwd=TRUE
DSHashAlgorithm=RSASHA1

Hi, would you know how to limit a field to only have 3 decimal places without using escript? i would appreciate your help. Thanks.

Nevermind this I forgot that putting 3 to the Scale Property of the field will do the trick. thanks nwayz!

Hi,

I want to know details on SARM product.

Can someone help.

NS

Hi Neelmani,

I am on 7.8, and have configured Links for a responsibility. These are supposed to appear in My Tasks applet on the homepage. But this Applet doesnt appear!
I have tried the “edit layout” on the application homepage, but do not see My Tasks applets. Where did i go wrong?

Thanks
Rahul

Hi Lakshmi,

To restrict field to 3 decimal places you can use List Column or Control property called “Display Format”
Syntax: #.###