Search Results ar_sales_tax




Overview
Explore in AI Chat

Overview

The AR_SALES_TAX table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for sales tax rate information, defining the tax jurisdiction and applicable rates for specific geographic areas and date ranges. Its primary role is to provide the tax calculation engine with the necessary rules to determine the correct sales tax amount for transaction lines during invoice creation. The integrity of tax calculations in Receivables is fundamentally dependent on the accurate configuration and maintenance of records within this table.

Key Information Stored

The table stores granular tax authority data, with its structure enforcing uniqueness through a composite primary key. The critical columns include LOCATION_ID, which links to a tax location defined in AR_LOC_COMBINATIONS_OLD, establishing the tax jurisdiction. The FROM_POSTAL_CODE and TO_POSTAL_CODE columns define the precise postal code range to which the tax rate applies, enabling location-based tax accuracy. The START_DATE and END_DATE columns control the effective date range of the tax rate, allowing for historical tracking and future rate changes. The ENABLED_FLAG acts as a control to activate or deactivate a specific tax rule. A separate unique key is maintained on the SALES_TAX_ID column, which serves as the primary foreign key reference for transaction lines.

Common Use Cases and Queries

A primary use case is troubleshooting tax calculation errors on invoices. Analysts often query this table to verify the active tax rate for a customer's ship-to postal code on a given transaction date. Common reporting needs include listing all configured tax rates for a specific location or identifying rates that will become effective on a future date. Sample SQL to find the applicable tax rate for a postal code would involve filtering on the postal code range, the transaction date falling between START_DATE and END_DATE, and the ENABLED_FLAG being set to 'Y'. Another critical operational query is to identify all transaction lines (in RA_CUSTOMER_TRX_LINES_ALL) that used a specific sales tax rate, which is essential for audit purposes or mass adjustments following a tax rule correction.

Related Objects

  • AR_LOC_COMBINATIONS_OLD: This table is referenced by AR_SALES_TAX via the foreign key on LOCATION_ID. It provides the tax location definition (e.g., state, county, city) to which the sales tax rate is attached.
  • RA_CUSTOMER_TRX_LINES_ALL: This core transaction lines table holds a foreign key reference (SALES_TAX_ID) to AR_SALES_TAX. This link stores which specific tax rate was applied to each invoice line, creating the audit trail from the configured tax rule to the calculated tax amount on the transaction.