Is it possible to update a joined field ?

27 November 2009 10,722 views 21 Comments

I was trying hard to get user input regularly but readers were not providing their feedback and response. Now we have come up with an idea of putting open post for answers , where we will discuss over commonly asked Siebel interview questions. these open post will be kept under “Siebel Interview Question” tag. The answer will get concluded after 30 days of creation.

Today’s question.

Question: Is it possible to update a joined field ?

Let’s discuss.

Hint: A joined field is a read only field, it cannot be updated .What iff it is implicit joined field.

Readers who viewed this page, also viewed:

(2 votes, average: 2.50 out of 5)

Loading ...

21 Comments »

Jasmeet said:

Nice way of forcing the readers to give their comment and sharing their knowledge.
My answer — a BIG NO.
we cant update a joined field.
A joined field is a read only field, it cannot be updated!

# 27 November 2009 at 1:43 pm

Ashish Kumar said:

Jasmeet, Thanks for reply. I guess you have missed my hint in above post.

# 27 November 2009 at 1:45 pm

David said:

By updating the foreign key that the join uses, the joined field will be updated.

# 28 November 2009 at 3:01 am

Axel said:

We do it a lot of times with s_contact that is joined to s_party. Even one step deeper with s_contact_x that is joined to s_contact, that is joined to s_party… But these are all implicit joins. I say No to other joins than implicit joins. Does anyone know if there is a possibility to create implicit joins: for example to create a new table cx_contact_x, that is implicitely joined to s_conact_x ?

# 29 November 2009 at 3:22 pm

David said:

@Axel: If you create an 1:M link on both tables, pointing to each other, you will be exposing an implicit join.

# 30 November 2009 at 9:53 am

Satish said:

Using picklists and MVGs. MVGs require join field and link as prerequisites unlike picklists where just a join is enough.

# 2 December 2009 at 1:47 pm

Kirill said:

Well, first point of view: classical configuration.
Note: we only considering Single-Value Fields (SVF), because MVF fields are not called joined, since they don’t use Join as a primary means of relationship. In case of SVF you can only update joined field using implicit join (like S_CONTACT’s field in a BC based on S_PARTY), otherwise joined field will be read-only.
Second point of view: other options.
Lots of possibilities in this field for an experienced Sibeloid. To name a few:
1) Runtime Event/Business Service/Workflow (especially for async update)
2) PreSetFieldValue/PreWriteRecord
3) Denarmalized table column/Denormalization Path column property (useful in some cases)

# 6 December 2009 at 4:21 pm

Ajith said:

You can update not just an implicit join field but an explicit join field too. Just have a Picklist in the field property. This works on Calculated Fields too. Have a Pick List on the Calculated field with a Pickmap and that becomes editable too.

# 10 December 2009 at 9:59 pm

Priya said:

Dynamic Picklist is used to update a joined fields

# 9 February 2010 at 2:10 pm

Mirza said:

Join filed can be update by pick applet.

# 21 February 2010 at 4:34 pm

sainni said:

Hey,
we can update Join field by using dynamic pick list.

Thanks..,
Sainni

# 18 March 2010 at 10:03 pm

Anil said:

Hi every body,

join fileds are updated by using Dynamic picklist.The join filed is noramlly read only filed.Dyanmic picklist is based on child business component. the value property of Dynamic picklist is Null i.e it doesnt contain any value.

# 25 June 2010 at 12:56 am

varma said:

you cant update a joined field,its in read only field.its like view in SQL,u cant update or modify views in SQL,in siebel also u cant update joined field ,u can just view the field

# 29 August 2010 at 4:19 am

Steve Brockman said:

I'm sorry to say, but you are wrong. Joined fields in a BC can be updated. A perfect example is the Account BC which is based on S_PARTY and only has 5 fields from S_PARTY with the rest either calculated, linked, or joined from other tables. If you are referring to linked fields instead of joined fields then I would agree that you cannot update them in the instance of the main BC, but you can still update linked fields through various methods like script or shuttle applets.

# 1 September 2010 at 9:53 pm

Tjip Zigterman said:

Isn't the update option only available for fields based on implicit joins?
(Lots of those in the Party Model.)

I do remember vaguely that there was some talk a year or two ago about enabling updating over any join but I haven't found anything recent about that yet.

# 1 September 2010 at 9:55 pm

Saket Shukla said:

The update through direct entry of value (Without choosing values from any applet like Pick or MVG) is avaliable for fields having Implicit join (Join dilivered with the packege and not created by developers) while the join fields (for explicit join fields) can be updated by using Pick applets,MVgs or through scripts.

# 1 September 2010 at 9:57 pm

Jhonny said:

See how one can update JOIN FIELD…
UPDATE (SELECT BONUS FROM EMPLOYEE_BONUS B INNER JOIN EMPLOYEES E ON B.EMPLOYEE_ID = E.EMPLOYEE_ID WHERE E.BONUS_ELIGIBLE = 'N') T SET T.BONUS = 0

# 6 March 2011 at 1:42 am

Alexey Gerassimov said:

It is easy: to explitict joins (joines that you have defined) use picklist and pickmaps.
For implicit joins (1:1 std. extension and intersection tables on child BCs of association) just populate the field with its value.

# 7 March 2011 at 9:55 pm

Naresh said:

Joined Field can be Updated ny Updating the foreign Key Field.This can be done using Dynamic Pick Lists

# 3 June 2011 at 7:18 pm

aMIT said:

Joined Fields can be updated using dynamic picklist

# 7 July 2011 at 2:22 pm

sant said:

Hi every one ,
my openion is forget about inner joins as every one know those are all updatable like normal field in BC.the issue is about the outer joins ….isn't it?
i feel we can update by directly by DPL or by Making Admin Mode Flag is True.as indirectly by updating the original field which is in other BC (Parent BC) ,
i know for that we should know the actual name of the field and BC.

hope u got my point ….let me know if there is any issues ………

# 12 October 2011 at 3:39 pm

Leave your response!

Most Commented

Most Viewed

Siebel High Interactivity Framework - 83,366 views
Siebel Pricing – Component Based Pricing - 74,365 views
Siebel Interview Questions - 45,811 views
Siebel Standard Interactivity & High Interactivity - 40,090 views
Business Component User Properties - 23,133 views