Got A Problem?

What does the information represent in Help>>About Visible Views? On which table is this information stored ? I want to know about the License Column .. On which table is it stored ?

Does anyone know what SCW stand for?

Neel,

what are the other ways that Siebel would integrate with other components except using the MQ and were can i find information regarding this?




Thanks,
Siddharth

HI Neel,
Is there any way to dynamically control the PDQs listed based on the view selected in the drop-down?
for eg: if the view selected is 'My Opportunities' then only the PDQs relevant to this view are dispplayed.

thanks
Satyam

Hi All,

Can some one tell me "How to Post a Query"?

I tried doing the same in Forum >> Help >> Posting. But click on POST button was not submitting my query :(

Cheers,
Eswar

Hi Neel,

Sub: ActiveBusObject Vs GetBusObject

can you describe me why i am facing the below issue?

I wrote a script at BC level in PreSet Event:
scenario 1: I used Active BusObject to Initialize Objects:

with a Search Expr: SearchExpr = ("[Invitee Status Code] = 'Participated' OR [Invitee Status Code] = 'Cancelled'")
when Executed it works Fine.
But,
scenario 2: I used Get BusObject to Initialize Objects:
with the same Search Expr i am finding the below Error Message.

"An error has occurred preparing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108)

ORA-00904: "SIEBEL"."S_ME_EVT_INV_LS"."INV_STAT_CD": invalid identifier "

Note: column for the field Invitee Status Code is "INV_STAT_CD" coming from "S_ME_EVT_INV_LS".

Please let me know if there are any queries.

Eswar

Hi all,

I am having a problem with Siebel 6 (siebel 2000) Tools. The problem is the "Edit layout" function randomly fails when I want to edit a web template for an SCW applet. What I do is: find the applet, select it, go to its web templates, select the template I want to edit and right-click above it. In the contextual menu, I select "Edit Layout" and sometimes it works, but many times what I get is a white screen, so I have to close it and try again until it works. This is a waste of time...

Please, could you help me?

Thank you for your help.

hi!
I am working on dynamic assignment.Facing a problem,whenever the workflowpolicy is fired,rows are inserted in S_ESCL_REQ.But then assignment manager is not invoked.The error log says-'SBL-TXR-00024: Error: unable to get dock status for TxnProc.'

Do let me know if you can help me out!

shwet.shekhar@gmail.com

Thanks

Problem Description: We are getting "Invalid User Name and Password" error. With the same user we can log in to Oracle Web Client as well as to the database but logging is failing in the PDA device.

Hi,

We are planning to load position hierarchy through EIM on daily or weekly basis.

Support web insists on executing 'Generate Reporting relationship' after importing position hierarchy (any hierarchy)through EIM. They also say that it is going cause lot of transactions for remote users. But in our case none of the managers have remote client, they just use web client. Only their subordinates have remote client. So I'm not sure whether this process of executing 'Generate Reporting relationship' method is going to cause any major transactions for remote client.
Please let me know if any of you have come across similar scenario.

Additional info:
Siebel life science 7.7
SQL server
remote clients :2000
Position records: 3000-5000


Thanks in advance
Prats

hi,
i have a requirement to prevent record with same sequence number. Following code is allowing the sequence number to be updated even if it is already existing. Can anybody help me out....
if u don't mind u can mail me at bhakti.janave@gmail.com
Thanks in advance

function BusComp_PreWriteRecord ()
{
try
{
var iSeq;
iSeq= this.GetFieldValue("Sequence number");
var count;

this.SetViewMode(AllView);
this.ClearToQuery();
this.ActivateField("Sequence number");
this.SetSearchSpec("Sequence number",iSeq);
this.ExecuteQuery(ForwardOnly);
count = this.CountRecords();
if(count>1)
{
TheApplication().RaiseErrorText("Sequence Repeated");
//this.UndoRecord();
return (CancelOperation);
}
else
{
return (ContinueOperation);
}

}

catch(e)
{
throw(e.toString());
}

finally
{
//iSeq = null;
//count = null;
}

}

Does any body have any idea about about configuring the recipint group for email functionality...

the joined abd nonjoined recipients please let me know...

regards always..

Hi,

Can any body tell how to edit an element of a XMl document.In fact I am using one Business service PRM ANI Utility to create an empmty property set,then I want to set values in the elements of the XML.I tried usingof echo method of Workflow Utility with the dot notation like "SiebelMessage.ListOfAccount.Account.AccountStatus = Active" in the workflow, but could not able to set the values.For your information I passed my IO to the input PRM ANI Utility.

Can any body help me with the solution of this.if you don not mind you can contact me through my mail also:- roysudipta123@gmail.com

Ekta as you requested for webmethods and webservices from Neel.If u get any information on this please forward me.My mail Id: sunny458[at]gmail[dot]com

I am beginner for webmethods.
I want to know how webmethods are used in Siebel EAI concept.
If you ppl. have any tutorial or links please forward me.

Hello,
We are facing this problem in workflow, version is 7.8.2
Its a simplest of WF, the erorr comes on Siebel operation step we are updating severity field of SR to some value. While simulating it says:

Error updating business component at step 'OPERATION'.(SBL-BPR-00187)
--
This error is returned when the workflow is executing the Siebel Operation business service.(SBL-BPR-00100)
--
The XML Document cannot be converted to an XML Hierarchy.(SBL-EAI-04110)
--
XML Hierarchy Converter error - empty input message, expecting an XML document in of input arguments(SBL-UNU-00246)

I checkted the business service "Workflow Siebel Operation" there are no methods listed!! is that normal?

IS this a bug?

i have tried creating the local DB using a new DB Extract. doesnt work either.

All sugestions welcome
Thanks
Rahul

I am invoking the BS SIS OM PMT Service's InvokeProdSvc
from a button in Asset Mgmt - Asset (Order Mgmt) .This creates a new Order from Assets.
I want to retain one value from the Previous Order Header to the newly created Order.

I have added user property at SIS OM PMT Service as follows

SIS OM Asset.Line Item:SIS OM Order.Header
and this is not working.(Order to Asset Mapping is working fine.)

I also tried mapping from Asset Header to Order Header which is also not working

Pleaese let me know what could have gone wrong.:(

Thanks

The best place to ask this question will be on siebelunleashed forum.

I will suggest you to put your question there and somebody will surely answer it

Hello Experts,

Iam pretty new to siebel iam using siebel essentials to get familiar with siebel i had done database extract and after that i have creating a custom repository file for abc but when i click abc client it gives error as "unable to load configuration file 'D:\Sea77\WEBCL1~1\bin\ENU\abc.cfg" plz help me solving this problem

Thanks
qeet

Hineel,

we want to import Records by using Import option in menu items. Can you pls explain what is the difference between Import menu option and EIM. Do we face any problems in future because of using import option to import records.


Thanks,
Kiran

Hi,

I am facing a problem. I want to retrive hierarchical data of postion through EAI siebel adapter Query.
For this I have made some changes in "Position" BC. I have put "Parent Position Id" in "Hierarchy Parent Field" in the BC.

Now I have created a IO through wizard which is based on this BC.
using this IO if I make a query on a data structure like following

Postion1
|
|-----position2
|
|--------Position3

if I query with id of the Id of "Position3" , it returns a blanks o/p. similarly with position2
but if I query with position1... it is retriving only the data relavant to "position1" not the complete hierarchy.
I am a bit confused if I am doing some thing wrong in the config or some where else.
Can somebody please help me out over here.

Thanks,
Ujjyal

I am Not able to add new view under Siebel responsibity.
The new button is disabled when i want to add my view under Siebel responsibity.
Suggestion in google
*Copy the record of Siebel Responsibility.
*edit seed data.
Please let me know if any solid answer.

hi All,

I want to know where is the siebel licences for the specific entities like Quotes etc stored. I belive it is no siebel_app_key..I can open tools but my client fails to open sayng Unable to load licensed options configuration.

Please contact your systems administrator.
Is it a problem with the installation or something else..If someone can throw some light..it will be great..Thanks in advance..

NS

Hi Neel,
I am trying to post few questions that I have in my mind.Please answer them at your convenience.
What is Symbolic Strings?Why are they used for?
What are the advantages and disadvantages of smart scripts?Any indepth tutorial on smart scripts?
Some time back in July you said ,you got trained in Siebel 8.0 and would like to share your experience on that ..I don't see any postings specific to siebel 8.0..When are you going to start?

Thanks in advance

i have integrated QTP with siebel by provinding the license key and configuration changes in siebel.cfg file but i am not able to see the process named SiebelAx_Test_A. could u please let me know what is the problem

Hey guys,

Can somebody post more containt about the state model.
what I have learnt till now is you add the rules in Administrator-> application-> State Model.

We can configure it for any of the BusComp & any of the field.
we can activate it & expire it here.
There are list of valid states, also one state is marked as default.
There are transitions, which suggests that one can only change the states from states mentioned in From State to To state.
the state model can be used through workflows & offcourse through scripts. (but can we use it some where in the tools)

Please tell me if my above understanding is correct. If not please correct it.

Hi Praveent,

I have seen the above Query & I think its too late for reply to that as it was written in May, but for the benefit of other users, unfortunately, we can't undo any changes, done by assignement manager :(

Thanks!

Hi Radha,

This indicates a fundamental access problem, which may be difficult to resolve because the HTTP protocol allows the Web server to give this response without providing any reason at all. So the 403 error is equivalent to a blank 'NO' by your Web server - with no further discussion allowed.

If you can tell some details regarding which web server site you wants to access might be someone able to help you more precisely.

Hi Neel,
I am not able to access the website.I am getting HTTP 403(Forbidden) error.
Please let me know what should I do.

Thanks
Radha

Hi Lakshmi,

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

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,

I want to know details on SARM product.

Can someone help.

NS

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

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

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
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.

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,

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

Thanks
vivek

so your codition with be like

created_by = 'SADMIN'
and Sysdate-upd_date > 13 months

"created_by=updated_by" might not work in case if user has gone and changed something on that record then updated by will be changed to his UserId and created_by will remain with SADMIN

if the autogenerated activities are created by policy or asynchronous process then another condition can be added that is created by 'SADMIN' or whatever your admin user is.

When you create any record through UI or BS synchornously then created and updated by populated with the current user id.

but when created or updated asynchronoulsy then it is populated with 'SADMIN' or similar user that you might have setup for that

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

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 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 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

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 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

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 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.

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 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?

@Liz,

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

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!

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

Really good information sumit..

thanks for sharing it with us.. will definately like to look at the details of this BS

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.

to invoke any BC method you can use

this.BusComp().InvokeMethod("MethodName")

you can try with this

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

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

Ammu,

Not sure if I understand your problem correctly.
You need to export it as a file somewhere or is this problem related to integration with another application. Provide more details so that we can have better understanding of the problem.

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 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.

Amit I believe this post will answer your question

http://siebelunleashed.com/an-error-has-occurre...

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 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