While viewing site uses in OCO (Oracle Customer Online) for a particular customer i'm able to view data for party sites.
Which tables are used in this ?(only hz_party_sites?)
also in party sites table there is data for two sites (bill to/ship to) but no corresponding data is there in hz_cust_acct_sites_all and hz_cust_site_uses_all for this party.
How to propagate these party sites in tables hz_cust_acct_sites_all,hz_cust_site_uses_all ?
Edited by: user540130 on Sep 23, 2010 9:50 PM
HZ_PARTY_SITES are the link between HZ_PARTIES and HZ_LOCATIONS. The uses are defined in HZ_PARTY_SITE_USES.
Understand that a party is not the same thing as a customer account (which will be in HZ_CUST_ACCOUNTS). Does the party you refer to have a customer account? If so, add a site to that account (it will connect to the party site or create a new party site) and then create the uses related to the account site.
This can be done using API or GUI, se TCA Tech Impl. Guide (e.g. for 11.5.10 -> http://download-uk.oracle.com/docs/cd/B16981_04/current/acrobat/115hztig.pdf )
What you are referring to is a Party Site Use and they are independent from Account Site Uses. When you create an Account Site Use, Party Site Use gets created often times depending upon the UI used. But the reverse is not true. You can add as many Party Site uses as you like, and this will not have any bearing on Account Site Uses. Same is true when it comes to maintaining Site Uses at Party Level and Account level. They can be maintained independently.
The story is different when it comes to Sites. If you inactivate a Party Site, all Account Sites that are tied to it gets inactivated. If inactivate an Account Site, the underlying Party Site gets inactivated, which in turn triggers the inactivation of all Account Sites that are tied to the Party Site.
There are several good presentations on TCA, CDH, MDM and Best Practices are posted at http://www.rhaptech.com/resources.html that you might want to take a look at.