Search Results hz_cust_site_uses_all
The HZ_CUST_SITE_USES_ALL
table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically in the context of the Trading Community Architecture (TCA) module. This table serves as a repository for storing detailed information about the various uses assigned to customer sites, enabling organizations to manage and track the functional purposes of customer locations effectively. Below is a detailed exploration of its structure, functionality, and significance in Oracle EBS implementations.
Table Overview
The HZ_CUST_SITE_USES_ALL
table is part of the Oracle TCA data model, which provides a unified framework for managing customer and partner information. It stores records that define the specific purposes (or "uses") associated with customer sites, such as billing, shipping, marketing, or legal purposes. Each record in this table links a customer site (HZ_CUST_ACCT_SITES_ALL
) to a site use type, facilitating granular control over site functionalities.
Key Columns and Relationships
The table includes several critical columns:
- SITE_USE_ID: Primary key uniquely identifying each site use record.
- CUST_ACCT_SITE_ID: Foreign key referencing
HZ_CUST_ACCT_SITES_ALL
, linking the use to a customer site. - SITE_USE_CODE: Defines the purpose (e.g., 'BILL_TO', 'SHIP_TO', 'MARKETING').
- PRIMARY_FLAG: Indicates if the site use is the primary purpose for the location.
- STATUS: Tracks active ('A') or inactive ('I') status.
- LOCATION: Optional field for additional location details.
- START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the site use.
The table integrates with other TCA entities like HZ_CUST_ACCOUNTS
(customer accounts) and HZ_PARTIES
(party information), ensuring data consistency across the customer hierarchy.
Functional Significance
In Oracle EBS, HZ_CUST_SITE_USES_ALL
plays a pivotal role in:
- Order Management: Distinguishes between shipping and billing sites for sales orders.
- Accounts Receivable: Identifies billing sites for invoicing and payment processing.
- Logistics: Manages shipping and receiving locations for inventory and procurement.
- Compliance: Tracks legal or regulatory site uses for audit purposes.
The SITE_USE_CODE
drives business logic in modules like Order-to-Cash (O2C) and Procure-to-Pay (P2P), ensuring transactions reference the correct site purpose.
Multi-Org and Security
As an _ALL
table, HZ_CUST_SITE_USES_ALL
supports multi-org access control. The ORG_ID
column enables data partitioning by operating unit, ensuring users only access records relevant to their organization. This design aligns with Oracle's Multi-Org architecture, critical for global deployments with shared instances.
Integration and Customization
The table is accessed via TCA APIs (e.g., HZ_CUST_ACCOUNT_SITE_V2PUB
) to maintain data integrity. Customizations often extend the table's functionality by:
- Adding descriptive flexfields (DFFs) for industry-specific attributes.
- Creating triggers or workflows based on site use changes.
- Integrating with third-party systems via Oracle Integration Bus (OIC).
Conclusion
The HZ_CUST_SITE_USES_ALL
table is foundational to customer site management in Oracle EBS 12.1.1 and 12.2.2. Its design supports complex business processes while maintaining flexibility for customization. By understanding its structure and relationships, implementers can optimize customer data workflows, ensuring accurate and efficient operations across financial, logistical, and sales modules.
-
Table: HZ_CUST_SITE_USES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
-
Table: HZ_CUST_SITE_USES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
-
APPS.IBE_ATP_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_TPA_SELECTOR_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.INV_MGD_MVT_SO_MDTR dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_ARINTF_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.RLM_FORECAST_SV dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_TCM_CONTROL_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_PURCHASE_RELEASE_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_TXS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_ITORD_UTIL dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKS_TAX_UTIL_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_EXTERNAL_CREDIT_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.FUN_XML_REPORT_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_ITORD_PUB dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSL_CSP_LOCATIONS_ACC_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.JA_JAINPLA_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.INV_MGD_MVT_UTILS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_DSNO dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_VTX_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_UPG_INSTALL_DETAILS dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_PROCESS_INTERFACED_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.CSP_PART_SEARCH_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.JAI_AR_TRX_HEADERS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.WSH_OTM_OUTBOUND dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.WSH_LOCATIONS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.2.2