Results for “ra_site_uses_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RA_SITE_USES_ALL is the Receivables (AR) table that stores the business purpose of a customer address. Each row associates a specific address (held in RA_ADDRESSES_ALL) with a site use code such as BILL_TO, SHIP_TO, STATEMENT, DUNNING, or LEGAL, thereby defining how an address may be used in transactions and reports. The "_ALL" suffix indicates that rows are partitioned by operating unit through the ORG_ID column, so the same physical customer site may exist independently for multiple organizations within a multi-org deployment. The table is owned by the AR schema and is VALID in both EBS 12.1.1 and 12.2.2.

The documented ETRM column count is 114, and the primary key is RA_SITE_USES_PK, defined on SITE_USE_ID. In addition, the metadata lists the unique index RA_SITE_USES_UK1 on (ADDRESS_ID, SITE_USE_CODE), and a unique index RA_SITE_USES_U1 on SITE_USE_ID. Heuristic Data Vault classification mined from the foreign-key structure is hub-leaning, which suggests modeling RA_SITE_USES_ALL as a hub keyed by SITE_USE_ID with satellites for the descriptive attributes such as terms, freight, tax, and GL defaults. This classification is a modeling suggestion, not a mandated design.

Key Information Stored

The most operationally significant columns include:

• SITE_USE_ID — surrogate primary key (RA_SITE_USES_PK); referenced widely by downstream tables.
• ADDRESS_ID — foreign key to RA_ADDRESSES_ALL; combines with SITE_USE_CODE in RA_SITE_USES_UK1.
• SITE_USE_CODE — the business purpose of the site (BILL_TO, SHIP_TO, etc.).
• PRIMARY_FLAG — indicates the primary site use for its purpose.
• STATUS — active/inactive state of the site use.
• ORG_ID — operating unit discriminator for multi-org partitioning.
• CONTACT_ID, BILL_TO_SITE_USE_ID — links to contact and to a related bill-to site use.
• PAYMENT_TERM_ID, PRICE_LIST_ID, ORDER_TYPE_ID, TERRITORY_ID — commercial defaults sourced from RA_TERMS_B, SO_PRICE_LISTS_B, SO_ORDER_TYPES_115_ALL, and RA_TERRITORIES.
• SHIP_VIA, FOB_POINT, FREIGHT_TERM, WAREHOUSE_ID — shipping and fulfillment attributes.
• TAX_CODE, TAX_CLASSIFICATION, TAX_EXEMPT, TAX_REFERENCE — tax determination attributes.
• GL_ID_REC, GL_ID_REV, GL_ID_TAX, GL_ID_FREIGHT — accounting flexfield defaults.
• LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATED_BY, CREATED_BY — standard WHO audit columns.

The surrogate key (SITE_USE_ID) is distinct from the business-key candidate (ADDRESS_ID, SITE_USE_CODE) defined by RA_SITE_USES_UK1.

Common Use Cases and Queries

Typical reporting scenarios include listing all active bill-to sites for a customer, reconciling ship-to sites against open order lines, and verifying tax and payment-term defaults before invoice generation. A representative query joins site uses to addresses:

• SELECT su.site_use_id, su.site_use_code, su.primary_flag, a.address1, a.city FROM ra_site_uses_all su JOIN ra_addresses_all a ON a.address_id = su.address_id WHERE su.org_id = :org AND su.status = 'A';
• Filtering by SITE_USE_CODE = 'SHIP_TO' and STATUS = 'A' to drive shipping and delivery reporting.
• Joining RA_CUSTOMERS on DUNNING_SITE_USE_ID or STATEMENT_SITE_USE_ID to identify dunning and statement recipients.
• Auditing GL_ID_* defaults and PAYMENT_TERM_ID for AutoInvoice validation and exception handling.
• Reconciling SO_HEADERS_ALL.INVOICE_TO_SITE_USE_ID and SHIP_TO_SITE_USE_ID to site use attributes for order and invoicing reports.

Related Objects

RA_SITE_USES_ALL participates in a dense web of foreign-key relationships across Receivables, Order Management, Purchasing, and Shipping:

• RA_ADDRESSES_ALL (ADDRESS_ID) — parent address entity.
• RA_TERMS_B (PAYMENT_TERM_ID), SO_PRICE_LISTS_B (PRICE_LIST_ID), SO_ORDER_TYPES_115_ALL (ORDER_TYPE_ID), RA_TERRITORIES (TERRITORY_ID) — commercial default lookups.
• RA_CUSTOMERS (DUNNING_SITE_USE_ID, STATEMENT_SITE_USE_ID) — dunning and statement site references.
• SO_HEADERS_ALL (INVOICE_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID) and SO_LINES_ALL (SHIP_TO_SITE_USE_ID) — order and line site references.
• WSH_DELIVERIES (ULTIMATE_SHIP_TO_ID, INTERMEDIATE_SHIP_TO_ID) — shipping destination references.
• AR_CUSTOMER_PROFILES (SITE_USE_ID) and AR_CUSTOMER_PROFILE_AMOUNTS (CUSTOMER_SITE_USE_ID) — profile and amount rules linked to the site use.
• PO_LOCATION_ASSOCIATIONS and MTL_INTERCOMPANY_PARAMETERS (CUSTOMER_SITE_ID) — procurement and intercompany usage.
• RA_SITE_USES_ALL (BILL_TO_SITE_USE_ID) — self-referencing relationship linking a site use to its bill-to site use.

These relationships make RA_SITE_USES_ALL the central hub for customer site usage across the AR, OM, PO, and WSH modules.