Showing posts with label Siebel. Show all posts
Showing posts with label Siebel. Show all posts
Wednesday, January 7, 2009
How to relate a contact whit their accounts
Contact accounts can be found in S_PARTY_PER intersection table. This table relates person_id column (par_row_id from s_contact) with party_id column (par_row_id from s_org_ext). Both person_id and party_id are foreign keys from s_party.
Labels:
Siebel
S_POSTN_CON : Description
This table associates a contact with positions that can acess it. This relation is suported by column con_id (par_row_id from s_contact) and postn_id (row_id from s_postn).
This is a many-to-many relationship : A contact can have more than one position associated, and a position can be related with multiple contacts.
Keep in mind that con_id is foreign key from s_party.
This is a many-to-many relationship : A contact can have more than one position associated, and a position can be related with multiple contacts.
Keep in mind that con_id is foreign key from s_party.
Labels:
Siebel
Debugging in http://localhost:8082
Today I've made my first siebel project compilation, all my environment is brand new and well configured.
I've enabled 'Auto-start web client' feature and hit the road. IExplorer browses http://localhost:8082/ and inherent error. Why in God's name is this happening?
The answer is simple, (If my friend Alexandre didn't help me, it wouldn't be so simple), my Firewall is enabled.
After I disabled that, my debug can go on!!
I've enabled 'Auto-start web client' feature and hit the road. IExplorer browses http://localhost:8082/ and inherent error. Why in God's name is this happening?
The answer is simple, (If my friend Alexandre didn't help me, it wouldn't be so simple), my Firewall is enabled.
After I disabled that, my debug can go on!!
Subscribe to:
Posts (Atom)
Archive
-
▼
2009
(21)
-
▼
January
(21)
- How to deploy files in a remote server?
- Oracle : Reduce your parsing times
- Oracle : SQLCODE and SQLERRM in Inserts
- SQL * Plus Tip - 1
- Oracle : Reducing join execution time
- PL/SQL Tip - 1
- PL/SQL : Show locked objects
- PL/SQL : How to update using select
- EIM : Shell execution order
- PL/SQL : Scripting for table drop
- EIM : DUP_RECORD_EXISTS after Update
- Localcooling . com
- How to relate a contact whit their accounts
- PL/SQL : Check script for object owners
- SQL Navigator : Code Templates
- S_POSTN_CON : Description
- Joins : Please talk ANSI SQL with me.
- WHy MINUS does NOT EXISTs in our queries?
- Get last file version
- Debugging in http://localhost:8082
- Error 452: Match column X not found in Y
-
▼
January
(21)
Translation by Google
Subscription Free
Categories
- ANSI SQL
- Back to Basics
- Best Practices
- Case Study
- cfg File
- Check In -Check Out
- Configuration
- Copy
- Debug
- Ecology
- EIM
- eScript
- Files
- Firewall
- Harvest
- How - To
- I Wish I Knew
- List of Values
- Logging
- Mapping
- Oracle
- PL/SQL
- Remote Server
- Siebel
- Siebel CRM
- Siebel Logs
- Siebel Tools
- Signals
- SQL Plus
- SQLNavigator
- Tunning
- Web Services
- Workflows