How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship
- 2 Answers
- 7168 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you resolve foreign key in eim?
What is detailed category and what is its use in configuration?
How do you assign responsibilities to employees in Siebel?
What is the deployment options used for load balancing with netscaler?
What is eapps.cfg file?
Where you involved in the design phase and what did you do?
How to Get the MultiValueFields in Workflow
what is client business service?
Explain where you will drop the constraints?
What is the use of virtual bc?
what is the link specification?
What are the differences between siebel 7.8 and 8.0?
What difference between join specification and join definition?
Explain how to create extension table to an interface table in siebel?
What is detail applet and association applet?
