How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship

Answers were Sorted based on User's Feedback



How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / madhuri motwani

Hello,
I assume that 1: M in this case is 1 account linked to many
opptys. and the reason you would be need a PRIMARY pty
becuase opportunity would be an MVG on Account applets

You can use any column to create a PFK column. Use any
unused field in S_ORG_EXT or S_ORG_EXT_X to create a
field "Primary Opportunity Id"

On the table level, on S_ORG_EXT, set the Foreign Key Table
as S_OPTY for the chosen field

On the BC,
1. Create a new field "primary Oppty id"
2. create a link between the two BCs and set the Primary Id
field as above

Is This Answer Correct ?    2 Yes 1 No

How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / shankar

it is not possible to create in account for opty. the reason
is you were not aware of the entities (say what is contact,
opty,account,activity) Opty is a lead through which we
generate income. account is an organization it can be
internal or external. You are trying reversal that is not
possible

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Siebel Interview Questions

By what way do you control Visibility in Siebel ?

2 Answers   Siebel Systems,


When do we go for dynamic picklist and for pick applet?

0 Answers  


In Siebel after you Generate a Bill, how will you come to know that whether a Bill is been sent to the customer or not.

1 Answers   IBM,


How to create Drilldown in Form applet?

11 Answers  


What is user properties?

0 Answers  






what is all mode sort?

0 Answers  


Explain what is the use of virtual bc?

0 Answers  


Explain the steps required to implement the load balancer on siebel servers.

0 Answers  


What is the difference between links and multi value links?

0 Answers  


What do you mean by virtual business comp in Siebel?

5 Answers   Siebel Systems,


What is virtual bc?

0 Answers  


Tell me what does install.ksh and imprep.ksh files do?

0 Answers  


Categories