Search Results hz_party_sites
The HZ_PARTY_SITES
table is a fundamental component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Trading Community Architecture (TCA) module. This table serves as a repository for storing physical locations associated with parties (organizations, individuals, or groups) in the system. It acts as a bridge between the HZ_PARTIES
table (which stores party information) and the HZ_LOCATIONS
table (which stores address details), enabling comprehensive management of party-site relationships.
Key Features and Structure
TheHZ_PARTY_SITES
table contains several critical columns that define the relationship between parties and their locations:
- PARTY_SITE_ID: Primary key, uniquely identifying each party-site record.
- PARTY_ID: Foreign key referencing
HZ_PARTIES
, linking the site to a specific party. - LOCATION_ID: Foreign key referencing
HZ_LOCATIONS
, associating the party with a physical address. - PARTY_SITE_NUMBER: A user-assigned identifier for the party-site relationship.
- STATUS: Indicates whether the party-site record is active (A) or inactive (I).
- START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the party-site relationship.
- IDENTIFYING_ADDRESS_FLAG: Marks the primary or default address for the party.
Functional Role in Oracle EBS
TheHZ_PARTY_SITES
table plays a pivotal role in multiple Oracle EBS modules, including:
- Order Management: Determines shipping and billing addresses for customers.
- Accounts Receivable: Stores customer remit-to and statement addresses.
- Procurement: Maintains supplier ship-to and bill-to locations.
- Customer Relationship Management: Tracks contact points for marketing and service purposes.
Integration with Other TCA Tables
The table maintains intricate relationships with other TCA entities:- One-to-many relationship with
HZ_PARTIES
(a party can have multiple sites). - Many-to-one relationship with
HZ_LOCATIONS
(multiple parties can share a location). - Parent table for
HZ_CUST_ACCT_SITES_ALL
andHZ_SUPPLIER_SITES
, which extend functionality for specific business purposes.
Data Management Considerations
When working withHZ_PARTY_SITES
, several technical aspects require attention:
- Data Integrity: The table enforces referential integrity through foreign key constraints.
- Performance: Proper indexing on
PARTY_ID
andLOCATION_ID
is crucial for query performance. - Audit Trail: Changes are tracked through the
HZ_PARTY_SITES
audit table (HZ_PARTY_SITES_A
). - Data Security: Access is controlled through TCA's VPD (Virtual Private Database) policies in later versions.
Customization and Extension Points
The table supports several extension mechanisms:- Attribute columns (
ATTRIBUTE1-20
) for custom data storage. - Flexfields integration for industry-specific or organization-specific data capture.
- Hook points in the TCA API for custom validation logic.
Version-Specific Considerations
Between EBS 12.1.1 and 12.2.2, the table structure remained largely consistent, with minor enhancements in 12.2.2:- Improved performance through additional indexes.
- Enhanced data security features.
- Better integration with Oracle Fusion Middleware components.
Best Practices
When implementing solutions involvingHZ_PARTY_SITES
:
- Always use TCA APIs (
HZ_PARTY_SITE_PUB
) for data modifications. - Implement proper error handling for duplicate address scenarios.
- Consider batch processing for large data volumes to avoid performance degradation.
- Regularly purge obsolete records to maintain system performance.
HZ_PARTY_SITES
table remains a cornerstone of address management in Oracle EBS, providing the flexibility needed to support complex business scenarios while maintaining data integrity across the application suite.
-
Table: HZ_PARTY_SITES
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
-
Table: HZ_PARTY_SITES
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
-
APPS.OE_BULK_TAX_UTIL dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.CSTPOMLD dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OKS_MISC_UTIL_WEB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.ZX_TEST_API dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.PV_ORDER_MGMT_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MATCH_RULE_60 dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.JTF_RS_PARTY_MERGE_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.JTF_TASKS_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.MTL_RELATED_ITEMS_PKG1 dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.ARP_TRX_DEFAULTS_3 dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IBY_PAYGROUP_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IBY_PAYMENTCARD_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IBE_ORDER_SAVE_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.FTE_TL_CACHE dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MERGE_UTIL dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OZF_SCHEDULE_DENORM_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.JTF_RS_RESOURCE_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_PARTY_SITE_BO_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IGF_SL_GEN dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OE_XML_PROCESS_UTIL dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.MST_AGG_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.CSR_SCHEDULER_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MATCH_RULE_39 dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.JTF_TTY_NA_TERRGP dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IGS_AD_PRC_TAC_OFFER dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OE_HEADER_UTIL dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.CAC_VIEW_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.OZF_SD_REQUEST_PUB dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.LNS_REP_UTILS dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.ASO_PARTY_INT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MOSR_VALIDATE_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.ARH_DQM_TREE dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.AS_SALES_LEADS_PVT dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.ZX_AR_POPULATE_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MIGRATE_MOSR_REFERENCES dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.HZ_MATCH_RULE_3 dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.AR_PURGE dependencies on HZ_PARTY_SITES
12.1.1
-
APPS.IGS_GE_GEN_002 dependencies on HZ_PARTY_SITES
12.1.1