Interested to Buy Any Domain ? << Click Here >> for more details...
This is krishna,
I created new Table,Bc,Link,Bo,view,screen
TABLE : CX_ECB_S_TAT
BC : ECB TAT BC
Link : ECB TAT BC/Service Request
Bo : ECB TAT BO
View : ECB TAT View
Screen : ECB TAT Screen
and I created new "X_ECB_TAT_ID" Column for foregin key
relation ship in "S_SRV_REQ" Table [in colum properties I
specified Forieignkey Table-CX_ECB_S_TAT]
and I created "TAT Id Ext" Field with "X_ECB_TAT_ID" Column
in "Service Request" BC.
I created Link"ECB TAT BC/Service Request". in this link I
specified "Destination Field-TAT Id EXT".( Parent BC : ECB
TAT BC, Child BC : Service Request)
---------------------------------------------------
There is two Screens 1)ECB TAT Screen 2)Service Request
Screen
in First Screen : ECB TAT Screen
Parent BC : ECB TAT BC
Fields : Type,Area,Sub Area,TAT
I given the field values to Type,Area,Sub Area
and based on field values I given "TAT" field value.
now we will go to Second Screen : Service Request Screen
Child BC : Service Request
Fields : INS Product,INS Area,INS Sub-Area,TAT
I given same values(Parent bc Field Values) to INS
Product,INS Area,INS Sub-Area
then should be update "TAT" Field value (I mean Parent BC
same "TAT" Field vaue should be update in "TAT" Field in
Child BC)
I wrote script for above requirement in "SetFieldValue"
Event in "ECB TAT BC"
function BusComp_PreSetFieldValue (FieldName, FieldValue)
{
if(FieldName == "TAT")
{
var Bo = TheApplication().GetBusObject("ECB TAT BO");
var Bc = Bo.GetBusComp("Service Request");
this.ActivateField("Type");
this.ActivateField("Area");
this.ActivateField("Sub Area");
this.ActivateField("TAT");
var sType = this.GetFieldValue("Type");
var sArea = this.GetFieldValue("Area");
var sSubArea = this.GetFieldValue("Sub Area");
var sTAT = FieldValue; //this.GetFieldValue("TAT");
var Bc1 = Bo.GetBusComp("Service Request")
with(Bc1)
{
var exp = "[INS Product] = '" + sType + "' AND [INS Area]
= '" + sArea + "' AND [INS Sub-Area] = '" + sSubArea + "'";
ActivateField("INS Product");
ActivateField("INS Area");
ActivateField("INS Sub-Area");
ClearToQuery();
SetViewMode(AllView);
SetSearchExpr(exp);
ExecuteQuery(ForwardOnly);
var cnt = CountRecords();
ActivateField("TAT");
var fst = FirstRecord();
while(fst)
{
SetFieldValue("TAT",sTAT);
fst = NextRecord();
}
}
}
return(ContinueOperation);
}
but in "Service Request" BC "TAT" field value updating
existing records,not updating creating new necords.
I should update "TAT" field value to creating new records.
where I have to write script in which event in which BC for
this.
please post detail script for this.
from last 15 days i'm working on this.
please help me on this.
thank you so much in advance.
- 2 Answers
- 6082 Views
- Ecobank, I also Faced
- E-Mail Answers
Answer Posted / taj
Hi Krishna
Write your code in Pre Write Record Event it must works for
NEw Records.
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to run genbscript.exe?
Explain the use of detailed category in configuration?
When do we go for dynamic picklist and for pick applet?
What is user properties? Why we using the user properties?
Why do we need to create employees at the database in siebel?
Explain the difference between an organization and division in siebel?
How to do validations in escripts and in configuration?
How can you do the data cleansing in eim?
Explain what is an extension table and how is it related to base table?
How to specify a view to be displayed as aggregate view in siebel 7.7?
Hello, There is a Hierarchial Picklist when I choose India > Maharastra > Mumbai. this comes as a normal Hierarchial Picklist now my question is that when i choose Mumbai the Maharastra and India should come automatically is this possible in Siebel if yes can any one post with a good step by step procedure. thanks in advance
When do you use property sets in siebel?
What are the eim tables and base tables are required to your entities?
what is the difference between siebel 7.5 and 7.8? If we upgrade the application to 7.8 from 7.5 what are the areas we need to give importance from qa(testing) point of view?
What is the difference between vbc and ebc in siebel?
