Search Results ar_loc_combinations_old




Overview
Explore in AI Chat

Overview

The AR_LOC_COMBINATIONS_OLD table is a legacy data object within Oracle E-Business Suite Receivables (AR) modules, specifically versions 12.1.1 and 12.2.2. Its core purpose is to define and store records for each distinct tax authority. This table serves as a foundational repository for tax jurisdiction information, which is critical for accurate sales tax calculation and reporting. While its name suggests it is an older structure, it remains a valid and referenced table in the schema, indicating its data may be retained for historical integrity or referenced by certain legacy processes. Its primary role is to act as a master source for location-based tax identifiers.

Key Information Stored

The primary data element stored in this table is the unique identifier for a tax location. The documented structure centers on the primary key column, LOCATION_ID, which uniquely defines each tax authority record. While the full column list is not detailed in the provided metadata, the existence of a primary key constraint (AR_LOCATION_COMBINATIONS_PK) on LOCATION_ID confirms its central role. Typically, such a table would also contain descriptive columns for the tax authority, such as name, jurisdiction code, and potentially effective date ranges, though these are inferred based on standard EBS design patterns for master reference data.

Common Use Cases and Queries

The primary use case for this table is supporting tax determination logic. When generating an invoice or transaction in Receivables, the system references tax location data to ascertain the correct taxing authority. Common queries involve joining this table to transaction lines or customer tax profiles. A fundamental reporting use case is listing all defined tax authorities. A sample SQL pattern to retrieve the core data would be:

  • SELECT location_id FROM ar.ar_loc_combinations_old ORDER BY location_id;

For troubleshooting or data validation, a join to the related AR_SALES_TAX table is common to verify which tax rates are associated with a given location:

  • SELECT ast.* FROM ar.ar_sales_tax ast WHERE ast.location_id = <specific_id>;

Related Objects

The AR_LOC_COMBINATIONS_OLD table maintains documented foreign key relationships with other critical EBS tables, confirming its integration into the application's data model. The provided metadata specifies two key relationships where this table is referenced as a parent:

  • AR_SALES_TAX: The AR_SALES_TAX.LOCATION_ID column references AR_LOC_COMBINATIONS_OLD.LOCATION_ID. This links tax rate definitions to their governing authority.
  • HZ_LOC_ASSIGNMENTS_OBS: The HZ_LOC_ASSIGNMENTS_OBS.LOC_ID column references AR_LOC_COMBINATIONS_OLD.LOCATION_ID. This ties customer location assignments from the Trading Community Architecture (TCA) model to the specific tax authority.

These relationships are governed by the primary key constraint AR_LOCATION_COMBINATIONS_PK on the LOCATION_ID column, ensuring referential integrity for all dependent data.