Search Results unedisc_ccid

Overview

The ZX_JRNL_ACCOUNTS_EXTRACT_V view is an Oracle E-Business Suite database object owned by the APPS schema. It is registered under the FND – Application Object Library product, though its contents are tightly bound to the E-Business Tax (ZX) module. The view exposes a consolidated, accounting-ready projection of tax-related accounting flexfield combinations (CCIDs) for tax lines. Its central purpose is to resolve which accounting code combination applies for each tax accounting event — the tax account, interim tax account, non-recoverable account, adjustment account, early-payment discount account, unearned discount account, finance charge account, and their non-recoverable variants.

The defining characteristic of the view is the priority logic implemented through nested DECODE expressions. For every accounting role, the view determines whether a jurisdiction-specific or rate-specific accounting override (TAX_ACCOUNT_ENTITY_ID) has been configured. If the override is null, the standard account from the tax or jurisdiction configuration is returned; otherwise the override account is returned. This makes the view a reliable single source for journal generation and downstream tax accounting extracts, ensuring that the correct CCID is surfaced for each line regardless of which configuration table supplied it.

Underlying Base Objects

The view is defined over the following base objects, all referenced through APPS synonyms: ZX_ACCOUNTS, ZX_JURISDICTIONS_B, ZX_LINES, ZX_RATES_B, and ZX_TAXES_B. These are the core E-Business Tax configuration and transaction tables.

• ZX_LINES supplies the transaction-level tax line rows, including TAX_LINE_ID and INTERNAL_ORGANIZATION_ID.
• ZX_JURISDICTIONS_B provides jurisdiction-level accounting defaults, aliased in the view as the jurisdiction accounts source.
• ZX_RATES_B provides rate-level accounting defaults, aliased as the rate accounts source.
• ZX_TAXES_B provides tax-level accounting defaults.
• ZX_ACCOUNTS stores the accounting setups and overrides keyed to a tax account entity, which drives the TAX_ACCOUNT_ENTITY_ID resolution.

The view joins these sources so that jurisdiction-level and rate-level configurations take precedence where they exist, with tax-level configurations serving as the fallback.

Key Columns

• TAX_LINE_ID — the unique identifier of the tax line from ZX_LINES; the join key to the transaction.
• INTERNAL_ORGANIZATION_ID — the operating unit or organization context for the tax line.
• TAX_ACCOUNT_ENTITY_ID — the identifier that determines whether a jurisdiction or rate accounting override exists. This is the column most commonly searched when troubleshooting tax account derivation.
• TAX_ACCOUNT_CCID — the account combination for the primary tax liability.
• INTERIM_TAX_CCID — the interim (accrual) tax account.
• NON_REC_ACCOUNT_CCID — the non-recoverable tax account.
• ADJ_CCID and ADJ_NON_REC_TAX_CCID — adjustment accounts and their non-recoverable counterparts.
• EDISC_CCID / EDISC_NON_REC_TAX_CCID — early-payment discount accounts.
• UNEDISC_CCID / UNEDISC_NON_REC_TAX_CCID — unearned discount accounts.
• FINCHRG_CCID / FINCHRG_NON_REC_TAX_CCID — finance charge accounts.

Common Use Cases and Queries

The view is typically used to diagnose tax account derivation and to feed journal extraction routines. A common query retrieves the resolved accounts for a given tax line:

• SELECT tax_line_id, internal_organization_id, tax_account_ccid, interim_tax_ccid FROM zx_jrnl_accounts_extract_v WHERE tax_line_id = :p_tax_line_id;
• To locate lines with a jurisdiction or rate override, filter on the entity column: WHERE tax_account_entity_id IS NOT NULL;
• To join resolved CCIDs to GL_CODE_COMBINATIONS for reporting: SELECT v.tax_line_id, g.segment1||'.'||g.segment2||'.'||g.segment3 account FROM zx_jrnl_accounts_extract_v v, gl_code_combinations g WHERE v.tax_account_ccid = g.code_combination_id;

Because the view already encapsulates the override precedence logic, it is preferred over querying ZX_ACCOUNTS, ZX_JURISDICTIONS_B, and ZX_RATES_B separately, reducing the risk of inconsistent account resolution in custom reports.