In Oracle R12, there is a huge change in maintaining Customer Master records, we have a new centralized module called TCA(Trading Community Architecture) which will take care of maintaining customer related information.
All tables are stored in HZ module with table names starting in HZ%.
HZ tables are all related and architecture of the TCA module is,
HZ_PARTIES (party-person,organization) <--->> HZ_CUST_ACCOUNTS (customer accounts)
A party may contain one or more customer accounts related to it.
HZ_PARTIES.PARTY_ID = HZ_CUST_ACCOUNTS.PARTY_ID
jh
HZ_CUST_ACCOUNTS <--->> HZ_CUST_ACCT_SITES_ALL
Linking column: CUST_ACCT_SITE_ID
HZ_CUST_ACCT_SITES_ALL <---> HZ_PARTY_SITES_ALL
Linking column: PARTY_SITE_ID
HZ_CUST_SITE_USES_ALL <---> HZ_CUST_ACCT_SITES_ALL
Linking column: CUST_ACCT_SITE_ID
Below query explains the link and how we fetch info from HZ tables.
select hz.party_name customer_name, hca.account_number customer_number,
hps.party_site_number site_number, hcsu.location loc_number
from hz_cust_site_uses_all hcsu,
hz_cust_accounts hca,
hz_parties hp
hz_cust_acct_sites_all hcas,
hz_party_sites hps
where hcas.cust_account_id = hca.cust_account_id
and hcsu.cust_acct_site_id = hcas.cust_acct_site_id
and hcas.party_site_id = hps.party_site_id
and hp.party_id = hca.party_id
and hcsu.location = :3
and hca.account_number = :1
and hps.party_site_number = :2
There are many APIs to create/update/delete HZ parties, customers, site and location information.
Pls refer these packages,
HZ_CUST_ACCOUNT_SITE_V2PUB - To update customer sites
HZ_CUST_ACCOUNT_V2PUB - To update customers
hz_party_v2pub - To update Parties
HZ_CUSTOMER_PROFILE_V2PUB - To update customer profiles
More information can be found in Oracle TCA technical implementation user guides and also lot of samples found in Metalink when you search any of the above package names.
TCA is also used by lot of other modules include,
- TeleSales
- CRM
In R12, all TCA front end screens are in OA framework.
Leave a comment