Search Results tax_account_entity_id

Overview

ZX_ACCOUNTS is a table in the ZX (E-Business Tax) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the default tax accounts that an internal organization defines for a tax jurisdiction or a tax rate. Each record represents the set of general ledger accounts that the tax engine uses to post tax-related accounting entries when a specific jurisdiction or rate is applied on a transaction. The accounts are not stored directly as segment strings; instead, ZX_ACCOUNTS stores foreign keys to GL_CODE_COMBINATIONS, meaning every posting account referenced here must already exist as a valid code combination in the ledger.

Because the table resolves relationships between a tax account entity (jurisdiction or rate), a ledger, an internal organization, and multiple general ledger accounts, the heuristic Data Vault classification provided in the metadata is link. This is a modeling suggestion only: ZX_ACCOUNTS behaves as a many-to-many style association table joining reference entities (jurisdiction, rate) to GL_CODE_COMBINATIONS and to HR_ALL_ORGANIZATION_UNITS. The inclusion of many descriptive attributes such as record type codes and audit columns means the physical table also carries satellite-like behavior, and downstream strategies should treat it as a hybrid.

Key Information Stored

The primary key of the table is ZX_ACCOUNTS_PK, defined on TAX_ACCOUNT_ENTITY_CODE, TAX_ACCOUNT_ENTITY_ID, LEDGER_ID, and INTERNAL_ORGANIZATION_ID. A unique index ZX_ACCOUNTS_U1 exists on TAX_ACCOUNT_ID, which acts as the surrogate primary key. A second unique index, ZX_ACCOUNTS_U2, mirrors the composite primary key columns and serves as the principal business-key candidate.

• TAX_ACCOUNT_ID — surrogate identifier used by the application and by any child references.
• TAX_ACCOUNT_ENTITY_CODE — indicates whether the default account set applies to a jurisdiction or to a rate.
• TAX_ACCOUNT_ENTITY_ID — the identifier of the jurisdiction or rate that owns the account set.
• LEDGER_ID — the ledger to which the tax accounts belong; tax accounting is maintained per ledger.
• INTERNAL_ORGANIZATION_ID — the internal organization (legal entity or operating unit) that defined the defaults, referencing HR_ALL_ORGANIZATION_UNITS.

The remaining columns are the account references themselves, each a foreign key into GL_CODE_COMBINATIONS: TAX_ACCOUNT_CCID for the main recoverable tax account, INTERIM_TAX_CCID for interim tax, NON_REC_ACCOUNT_CCID and its related non-recoverable variants ADJ_NON_REC_TAX_CCID, EDISC_NON_REC_TAX_CCID, UNEDISC_NON_REC_TAX_CCID, and FINCHRG_NON_REC_TAX_CCID, plus ADJ_CCID, EDISC_CCID, UNEDISC_CCID, and FINCHRG_CCID for adjustments, earned discounts, unearned discounts, and finance charges respectively. RECORD_TYPE_CODE distinguishes record variants, while CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and OBJECT_VERSION_NUMBER provide the standard audit and concurrency columns.

Common Use Cases and Queries

The most common reason to query ZX_ACCOUNTS is to trace which general ledger account the tax engine will debit or credit for a given jurisdiction or rate. A typical pattern joins the account columns back to GL_CODE_COMBINATIONS so the concatenated segment string is readable:

• Retrieve the main tax account for an entity and ledger: join on TAX_ACCOUNT_CCID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID, filtering by TAX_ACCOUNT_ENTITY_CODE, TAX_ACCOUNT_ENTITY_ID, LEDGER_ID, and INTERNAL_ORGANIZATION_ID.
• Detect configuration gaps: find jurisdictions or rates with no row in ZX_ACCOUNTS for a given ledger, which can cause tax accounting to fall back to default setups.
• Account validation reporting: verify that every CCID column resolves to an enabled, non-end-dated GL_CODE_COMBINATIONS record.
• Reconciliation: compare the tax accounts defined here against actual subledger accounting entries generated by E-Business Tax to confirm postings match the configured defaults.

Because the PK is composite and includes ledger and organization, queries should always filter on those keys to avoid cross-ledger ambiguity.

Related Objects

• GL_CODE_COMBINATIONS — referenced by ADJ_CCID, EDISC_CCID, UNEDISC_CCID, FINCHRG_CCID, TAX_ACCOUNT_CCID, INTERIM_TAX_CCID, NON_REC_ACCOUNT_CCID, ADJ_NON_REC_TAX_CCID, EDISC_NON_REC_TAX_CCID, UNEDISC_NON_REC_TAX_CCID, and FINCHRG_NON_REC_TAX_CCID.
• HR_ALL_ORGANIZATION_UNITS — referenced by INTERNAL_ORGANIZATION_ID.
• ZX_ACCOUNTS (self) — LEDGER_ID forms an internal reference linking rows to the same ledger context.
• ZX_JURISDICTIONS and ZX_RATES — the tax account entities identified by TAX_ACCOUNT_ENTITY_CODE and TAX_ACCOUNT_ENTITY_ID.
• ZX_REC_NREC_DIST — stores the calculated recoverable and non-recoverable tax distributions that these defaults feed.
• ZX_LINES and ZX_LINE_ACCOUNTS — transaction tax lines whose accounting derives from the accounts configured here.

Together these objects form the accounting chain through which E-Business Tax translates tax configuration into general ledger postings.