Is it possible to update a joined field ?

Siebel Support Web For Complete Siebel Reference

Is it possible to update a joined field ?

27 November 2009 1,431 views 16 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.

16 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