Search Results zx_rec_nrec_dist

Overview

The ZX_REC_NREC_DIST table is a core data repository within the Oracle E-Business Tax (ZX) module for Oracle E-Business Suite releases 12.1.1 and 12.2.2. It serves as the definitive ledger for all tax distribution lines generated by the system, categorizing each tax amount as either recoverable or non-recoverable. This distinction is critical for financial accounting, as recoverable taxes (like Value-Added Tax) are tracked as assets for future reclamation, while non-recoverable taxes represent a final expense. The table is central to the tax calculation and posting processes, capturing the detailed outcome of tax determinations for transactions across the E-Business Suite, including those from Projects (PA), Payables, and Receivables.

Key Information Stored

Each record in ZX_REC_NREC_DIST represents a single tax distribution line. The primary identifier is the REC_NREC_TAX_DIST_ID. Key columns define the tax's context, amount, and accounting treatment. These include the TAX_REGIME_CODE, TAX_ID, and TAX_RATE_ID, which identify the specific tax rule applied. The TAX_STATUS_ID indicates the applicable tax status code. Financial attributes such as the TAX_AMOUNT, TRX_CURRENCY_CODE, and the critical ACCOUNT_CCID (the code combination ID for the General Ledger account) are stored. For project-related transactions, the PROJECT_ID, TASK_ID, and EXPENDITURE_ORGANIZATION_ID link the tax line to the Projects module. The SUMMARY_TAX_LINE_ID column provides a foreign key relationship to the ZX_LINES_SUMMARY table for aggregated tax reporting.

Common Use Cases and Queries

A primary use case is tracing the detailed tax accounting for a specific invoice or transaction. Analysts often query this table to reconcile tax amounts between subledgers and the general ledger or to audit tax recovery claims. For project costing, queries join to PA_PROJECTS_ALL and PA_TASKS to allocate tax costs accurately. A typical audit query might retrieve all recoverable tax distributions for a given project and period:

• SELECT d.tax_amount, d.account_ccid, p.segment1 project_number
  FROM zx_rec_nrec_dist d, pa_projects_all p
  WHERE d.project_id = p.project_id
  AND d.expenditure_organization_id = :org_id
  AND d.recovery_type_id IS NOT NULL
  AND TRUNC(d.created_by_date) BETWEEN :date_from AND :date_to;

Another common scenario involves investigating tax adjustments or reversals, utilizing the ADJUSTED_DOC_TAX_DIST_ID and REVERSED_TAX_DIST_ID columns to follow correction chains.

Related Objects

The ZX_REC_NREC_DIST table is a central hub with extensive foreign key relationships to master and transactional tables across the EBS tax and financial architecture. Key documented relationships include:

• ZX_LINES_SUMMARY: Joined via SUMMARY_TAX_LINE_ID for summarized tax line data.
• ZX_REGIMES_B, ZX_TAXES_B, ZX_RATES_B, ZX_STATUS_B: For tax regime, tax, rate, and status master data.
• GL_CODE_COMBINATIONS: Joined via ACCOUNT_CCID for the general ledger account.
• PA_PROJECTS_ALL: Joined via PROJECT_ID for project details.
• PA_TASKS: Joined via TASK_ID for task details.
• PA_EXP_ORGS_IT: Joined via EXPENDITURE_ORGANIZATION_ID, as noted in the user's search, for the project expenditure organization.
• FND_CURRENCIES: Joined via TRX_CURRENCY_CODE for currency information.
• ZX_PROCESS_RESULTS: Joined via APPLICABILITY_RESULT_ID for detailed tax determination results.
• ZX_RECOVERY_TYPES_B: Joined via RECOVERY_TYPE_ID for recoverable tax type definitions.