TCA HZ Tables in Oracle Receivables

TCA data model uses many tables to store the TCA information in structure way. In the below section you can understand the overview of the TCA HZ Tables in Oracle Apps R12. You can also use TCA API to insert/update data into those Oracle Receivable tables.

1. HZ_PARTIES in HZ Tables in Oracle Apps R12

This HZ Tables in Oracle Apps R12 stores basic information about all parties (Person, Organization, Relationship). The primary key of hz_parties is PARTY_ID.

• PARTY_ID: Primary identifier of hz_parties
• PARTY_NUMBER: Party Number is a unique identifier assigned by the system
• PARTY_NAME: Name of the Party as entered during creation
• PARTY_TYPE: Party Type like Person, Relationship, or Organization

2. HZ_PARTY_SITES

Links parties to locations and defines location-specific information. The primary key of hz_party_sites is PARTY_SITE_ID.

• PARTY_SITE_ID: Unique identifier for each party site
• PARTY_ID: Foreign key to HZ_PARTIES table
• LOCATION_ID: Foreign key to HZ_LOCATIONS table
• PARTY_SITE_NAME: User-defined name for the site
• STATUS: Status of the Site Active/Inactive

3. HZ_LOCATIONS

Stores address/location details used by parties and accounts. The primary key of hz_locations LOACTION_ID.

• LOCATION_ID: Unique identifier for the location
• ADDRESS1–ADDRESS4: Street address lines
• CITY: City name
• POSTAL_CODE: Postal or ZIP code
• COUNTRY: Country code
• STATE: State or province name

4. HZ_ORGANIZATION_PROFILES

Stores additional profile information for organizations only.The primary key of hz_organization_profiles is ORGANIZATION_PROFILE_ID.

• ORGANIZATION_PROFILE_ID: Unique identifier for the organization profile
• PARTY_ID: Foreign key to HZ_PARTIES table
• ORGANIZATION_NAME: Full legal name of the organization(PARTY_NAME of Party table)
• YEAR_ESTABLISHED: Indicates when the organization was founded
• EMPLOYEES_COUNT: Number of employees in the organization
• JURISDICTION_CODE: Legal jurisdiction applicable to the organization

5. HZ_CUST_ACCOUNTS in Oracle Apps R12

Represents business relationships (customer accounts). A party can have multiple accounts. The primary key of hz_cust_accounts is CUST_ACCOUNT_ID.

• CUST_ACCOUNT_ID: Unique identifier for the customer account
• PARTY_ID: Links the customer to the HZ_PARTIES table
• ACCOUNT_NUMBER: Unique customer account number
• CUSTOMER_TYPE: Indicates whether customer is internal or external
• CUSTOMER_CLASS_CODE: Groups customer based on shared characteristics

6. HZ_CUST_ACCT_SITES_ALL in Oracle Apps R12

This HZ Tables in Oracle Apps R12 stores addresses (sites) where business is conducted for customer accounts. The primary key of hz_cust_acct_sites is CUST_ACCT_SITE_ID.

• CUST_ACCT_SITE_ID: Unique identifier for customer site
• CUST_ACCOUNT_ID: Foreign key to HZ_CUST_ACCOUNTS table
• PARTY_SITE_ID: Links to HZ_PARTY_SITES
• BILL_TO_FLAG: Indicates if the site is a billing location
• SHIP_TO_FLAG: Indicates if the site is a shipping location

7. HZ_CUST_SITE_USES_ALL in Oracle Apps R12

This HZ Tables in Oracle Apps R12 defines business purposes (Bill-to, Ship-to) for customer account sites. The primary key of hz_cust_site_uses is SITE_USE_ID.

• SITE_USE_ID: Unique identifier for each site use
• CUST_ACCT_SITE_ID: Foreign key to HZ_CUST_ACCT_SITES_ALL table
• SITE_USE_CODE: Describes the site’s business function (e.g., BILL_TO, SHIP_TO)
• PRIMARY_FLAG: Y/N to designate primary site use

8. HZ_CUSTOMER_PROFILES in Oracle Apps R12

Stores credit-related attributes for a party, account, or site. The primary key of hz_customer_profiles is CUST_ACCOUNT_PROFILE_ID.

• CUST_ACCOUNT_PROFILE_ID: Unique profile identifier
• CUST_ACCOUNT_ID: Links to the Customer Account table
• PROFILE_CLASS_ID: Foreign key to HZ_CUST_PROFILE_CLASSES table
• STATUS: Indicates whether the profile is active or inactive

9. HZ_CUST_PROFILE_CLASSES in Oracle Apps R12

Defines default credit attributes across customer groups. The primary key of hz_cust_profile_classes is PROFILE_CLASS_ID.

• PROFILE_CLASS_ID: Unique identifier for the profile class
• NAME: Descriptive name for the class
• STATUS: Indicates whether the profile class is active or inactive

These tables are central to configuring, querying, and integrating TCA data effectively using HZ Tables within Oracle Apps R12 Receivables and other modules. You can also explore PO Tables and Inventory Tables as well.