Search Results ra_site_uses_all




Overview
Explore in AI Chat

Overview

The RA_SITE_USES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module, specifically in versions 12.1.1 and 12.2.2. It defines the business purpose of a customer address, enabling a single physical location to serve multiple transactional functions. This table is fundamental to the Trading Community Architecture (TCA) model, where a customer address (stored in RA_ADDRESSES_ALL) can have multiple "site uses," such as Bill-To, Ship-To, or Statement locations. Its primary role is to categorize how a specific customer address is utilized across the Order-to-Cash cycle and other financial operations, providing the granularity needed for complex customer relationships and transaction processing.

Key Information Stored

The table stores metadata that qualifies an address for specific business processes. Its primary key is SITE_USE_ID, a unique identifier for each site use record. Critical columns include ADDRESS_ID, which links to the RA_ADDRESSES_ALL table, and SITE_USE_CODE, which defines the purpose (e.g., BILL_TO, SHIP_TO). Other significant foreign key columns establish relationships with other master data, such as PAYMENT_TERM_ID (linking to RA_TERMS_B), PRICE_LIST_ID (linking to SO_PRICE_LISTS_B), and TERRITORY_ID (linking to RA_TERRITORIES). The BILL_TO_SITE_USE_ID column supports hierarchical relationships, allowing a Ship-To site to be associated with its governing Bill-To site. The table also includes standard WHO columns for auditing and a STATUS column to track active or inactive uses.

Common Use Cases and Queries

This table is central to configuring customer transaction points. Common use cases include determining valid Bill-To addresses for invoicing, identifying Ship-To locations for order fulfillment, and setting up statement cycles. A frequent reporting requirement is to list all active site uses for a customer. A typical query pattern joins RA_SITE_USES_ALL with RA_ADDRESSES_ALL and HZ_CUST_ACCT_SITES_ALL (the TCA customer account site entity) to retrieve a comprehensive customer location profile. For technical troubleshooting or data validation, queries often check for site uses missing critical dependencies, such as a Bill-To site without a defined payment term. The table is also pivotal in interfaces where transactional data must be validated against a customer's valid site uses before processing.

Related Objects

RA_SITE_USES_ALL has extensive relationships across EBS modules, as indicated by its foreign key constraints. Direct parent tables include:

  • RA_ADDRESSES_ALL: The physical address record.
  • RA_TERMS_B: For payment terms.
  • SO_ORDER_TYPES_115_ALL and SO_PRICE_LISTS_B: For Order Management defaults.
It is a critical parent table for numerous child objects, including: This wide integration underscores its role as a master data hub for customer site functionality.