Results for “ra_remit_tos_u1”

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

Overview

RA_REMIT_TOS_ALL is a Receivables (AR) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the remit-to address assignment rules used to default a customer's remit-to address during invoice and commitment entry. Each row links a remit-to address — referenced through ADDRESS_ID — to a country, state, and postal code range. The table is documented as VALID, owned by the AR schema, and mapped to FND Design Data AR.RA_REMIT_TOS_ALL. Physically it resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

From a Data Vault modeling perspective, the mined relationship structure suggests a link classification. The object does not carry its own descriptive history beyond standard Who columns and descriptive flexfield attributes; instead it associates an address (via ADDRESS_ID toward HZ_CUST_ACCT_SITES_ALL) with a geographic resolution key formed by COUNTRY, STATE, POSTAL_CODE_LOW, and POSTAL_CODE_HIGH. That associative role, rather than an independent hub identity, is what drives the heuristic classification.

Key Information Stored

The table contains 28 documented columns. The most operationally significant are:

• ADDRESS_ID — the foreign key to the remit-to address site; the value actually consumed by invoice and commitment defaulting logic.
• COUNTRY — remit-to country. Documented as required even though the column is null-allowed.
• STATE — remit-to state, the first column of the unique index RA_REMIT_TOS_U1.
• POSTAL_CODE_LOW / POSTAL_CODE_HIGH — the inclusive postal range that qualifies the country/state pair.
• STATUS — status flag for the remit-to address, validated against the CODE_STATUS lookup.
• ORG_ID — operating unit discriminator; present in the unique index and central to multi-org filtering.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns for audit and concurrency.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield structure definition and segments for customer-specific extensions.

The surrogate primary key is defined as RA_REMIT_TOS_PK (STATE, COUNTRY, POSTAL_CODE_LOW, POSTAL_CODE_HIGH). The unique index RA_REMIT_TOS_U1 (STATE, COUNTRY, POSTAL_CODE_LOW, POSTAL_CODE_HIGH, ORG_ID) is the stronger business-key candidate because it adds the operating unit, preventing the same geographic resolution from being duplicated across orgs.

Common Use Cases and Queries

Typical scenarios include diagnosing why a remit-to address defaults incorrectly, auditing geographic coverage by operating unit, and validating that postal ranges do not overlap within a country/state combination.

• Resolving the default address for a customer location: join RA_REMIT_TOS_ALL to HZ_CUST_ACCT_SITES_ALL on ADDRESS_ID, filtered by COUNTRY, STATE, and ORG_ID.
• Reporting active remit-to assignments: filter on STATUS and restrict by ORG_ID to respect operating unit security.
• Detecting range conflicts: group by ORG_ID, COUNTRY, and STATE and compare POSTAL_CODE_LOW/HIGH boundaries.
• Extracting descriptive flexfield content for downstream reporting via ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15.

A representative pattern resolves a remit-to address for a given postal code:

SELECT r.address_id FROM ar.ra_remit_tos_all r WHERE r.country = :country AND r.state = :state AND r.org_id = :org_id AND :postal BETWEEN r.postal_code_low AND r.postal_code_high;

Related Objects

The following objects are most significant to RA_REMIT_TOS_ALL, based on documented foreign keys and key relationships:

• HZ_CUST_ACCT_SITES_ALL — referenced through RA_REMIT_TOS_ALL.ADDRESS_ID; supplies the actual address site row.
• RA_REMIT_TOS_PK — the primary key constraint enforcing uniqueness of STATE, COUNTRY, POSTAL_CODE_LOW, and POSTAL_CODE_HIGH.
• RA_REMIT_TOS_U1 — the unique index adding ORG_ID to the business key.
• AR.RA_CUSTOMER_REMIT_TO_ADDRESSES — the related Receivables remit-to address table populated through the same setup flows.
• FND_USER — foreign key target for CREATED_BY and LAST_UPDATED_BY.
• FND_LOGINS — foreign key target for LAST_UPDATE_LOGIN.
• AR.RA_BATCH_SOURCES_ALL and AR.RA_CUSTOMERS — surrounding AutoInvoice and customer setup tables that participate in remit-to defaulting during transaction entry.

Together these objects support the setup and runtime resolution of remit-to addresses across Oracle Receivables.