Search Results ar_location_accounts_all




Overview
Explore in AI Chat

Overview

AR_LOCATION_ACCOUNTS_ALL is a Receivables (AR) module table that stores the tax accounting information associated with a location segment. In Oracle E-Business Suite 12.1.1 and 12.2.2, the table acts as a repository linking a location segment to the full set of General Ledger (GL) accounting code combinations required for tax-related receivable processing. It serves as the accounting configuration authority for tax accounts, interim tax accounts, adjustment accounts, earned and unearned discount accounts, and finance charge accounts, including their non-recoverable tax counterparts.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table behaves primarily as a descriptive attribute store attached to a core business entity (the location segment), rather than as an independent hub or a pure relationship link. Analysts designing a dimensional or Data Vault model should treat AR_LOCATION_ACCOUNTS_ALL as the descriptive satellite of the location segment hub, keyed on the location segment identifier and organization context.

Key Information Stored

The surrogate primary key is LOCATION_VALUE_ACCOUNT_ID, enforced by the unique index AR_LOCATION_ACCOUNTS_PK. Because a second unique index, AR_LOCATION_ACCOUNTS_U2, exists on the combination of LOCATION_SEGMENT_ID and ORG_ID, that pair serves as the business-key candidate — meaning a location segment may have only one accounting configuration per operating unit. The LOCATION_SEGMENT_ID column is also the documented foreign key reference point back to the location segment entity.

The most significant accounting columns are the GL code combination identifiers that drive tax posting: TAX_ACCOUNT_CCID (the standard tax account), INTERIM_TAX_CCID (interim tax holding account), ADJ_CCID, EDISC_CCID, UNEDISC_CCID, and FINCHRG_CCID, which respectively hold the adjustment, earned discount, unearned discount, and finance charge accounts. A parallel family of non-recoverable tax accounts is stored in ADJ_NON_REC_TAX_CCID, EDISC_NON_REC_TAX_CCID, UNEDISC_NON_REC_TAX_CCID, and FINCHRG_NON_REC_TAX_CCID.

Standard EBS audit and concurrency columns are present, including CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. Concurrent program lineage is captured through REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE. Multi-organization access is governed by ORG_ID, while ATTRIBUTE_CATEGORY and the fifteen ATTRIBUTE1..15 descriptive flexfield columns provide extensibility. The table contains 38 columns in total.

Common Use Cases and Queries

Typical usage centers on resolving which GL accounts will be applied when tax, discount, and finance charge activity is posted for receivables tied to a given location. Report developers frequently join this table to transaction and location data to validate accounting setups and to troubleshoot posting discrepancies.

  • Retrieving the full accounting configuration for a location segment and operating unit:
    SELECT location_value_account_id, tax_account_ccid, interim_tax_ccid, adj_ccid, edisc_ccid, unedisc_ccid, finchrg_ccid FROM ar_location_accounts_all WHERE location_segment_id = :p_segment AND org_id = :p_org;
  • Auditing records lacking a recoverable tax account or populated only with non-recoverable accounts.
  • Comparing earned versus unearned discount account assignments across organizations.
  • Reconciliation of concurrent program loads using REQUEST_ID and PROGRAM_UPDATE_DATE to track when accounting configurations were last refreshed.
  • Feeding downstream GL posting validation queries by resolving *_CCID values against GL_CODE_COMBINATIONS.

Related Objects

The documented foreign key establishes the principal relationship from AR_LOCATION_ACCOUNTS_ALL.LOCATION_SEGMENT_ID to the location segment entity. The *_CCID columns reference GL_CODE_COMBINATIONS, which resolves each identifier to its chart-of-accounts segments. Because the table carries ORG_ID, it is associated with the multi-organization architecture governed by HR_OPERATING_UNITS and organization security. Location segment definitions are maintained through the Receivables location segment setup, and the accounting assignments here are consumed during AutoAccounting and tax calculation for transactions referencing the affected location, linking indirectly to the transaction distributions in AR_DISTRIBUTIONS_ALL and the tax lines in AR_LINES_ALL.