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.

Table: ZX_REC_NREC_DIST 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REC_NREC_DIST, object_name:ZX_REC_NREC_DIST, status:VALID, product: ZX - E-Business Tax , description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. , implementation_dba_data: ZX.ZX_REC_NREC_DIST ,
Table: ZX_REC_NREC_DIST 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REC_NREC_DIST, object_name:ZX_REC_NREC_DIST, status:VALID, product: ZX - E-Business Tax , description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. , implementation_dba_data: ZX.ZX_REC_NREC_DIST ,
Table: ZX_RATES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RATES_B, object_name:ZX_RATES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction. , implementation_dba_data: ZX.ZX_RATES_B ,
Table: ZX_RATES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RATES_B, object_name:ZX_RATES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction. , implementation_dba_data: ZX.ZX_RATES_B ,
Table: ZX_RECOVERY_TYPES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RECOVERY_TYPES_B, object_name:ZX_RECOVERY_TYPES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. , implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B ,
Table: ZX_STATUS_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_STATUS_B, object_name:ZX_STATUS_B, status:VALID, product: ZX - E-Business Tax , description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. , implementation_dba_data: ZX.ZX_STATUS_B ,
Table: ZX_RECOVERY_TYPES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RECOVERY_TYPES_B, object_name:ZX_RECOVERY_TYPES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. , implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B ,
Table: ZX_EVENT_CLASSES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVENT_CLASSES_B, object_name:ZX_EVENT_CLASSES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores tax event classes. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVENT_CLASSES_B ,
Table: ZX_STATUS_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_STATUS_B, object_name:ZX_STATUS_B, status:VALID, product: ZX - E-Business Tax , description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. , implementation_dba_data: ZX.ZX_STATUS_B ,
Table: ZX_EVENT_CLASSES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVENT_CLASSES_B, object_name:ZX_EVENT_CLASSES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores tax event classes. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVENT_CLASSES_B ,
Table: ZX_EVNT_TYP_MAPPINGS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS, object_name:ZX_EVNT_TYP_MAPPINGS, status:VALID, product: ZX - E-Business Tax , description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS ,
Table: ZX_LINES_SUMMARY 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES_SUMMARY, object_name:ZX_LINES_SUMMARY, status:VALID, product: ZX - E-Business Tax , description: This table stores the summarized tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES_SUMMARY ,
Table: ZX_TAXES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_TAXES_B, object_name:ZX_TAXES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. , implementation_dba_data: ZX.ZX_TAXES_B ,
Table: ZX_EVNT_TYP_MAPPINGS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS, object_name:ZX_EVNT_TYP_MAPPINGS, status:VALID, product: ZX - E-Business Tax , description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS ,
Table: ZX_TAXES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_TAXES_B, object_name:ZX_TAXES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. , implementation_dba_data: ZX.ZX_TAXES_B ,
Table: ZX_LINES_SUMMARY 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES_SUMMARY, object_name:ZX_LINES_SUMMARY, status:VALID, product: ZX - E-Business Tax , description: This table stores the summarized tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES_SUMMARY ,
Table: ZX_PROCESS_RESULTS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PROCESS_RESULTS, object_name:ZX_PROCESS_RESULTS, status:VALID, product: ZX - E-Business Tax , description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. , implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,
Table: ZX_PROCESS_RESULTS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PROCESS_RESULTS, object_name:ZX_PROCESS_RESULTS, status:VALID, product: ZX - E-Business Tax , description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. , implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,
Table: ZX_REGIMES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REGIMES_B, object_name:ZX_REGIMES_B, status:VALID, product: ZX - E-Business Tax , description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. , implementation_dba_data: ZX.ZX_REGIMES_B ,
Table: ZX_REGIMES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REGIMES_B, object_name:ZX_REGIMES_B, status:VALID, product: ZX - E-Business Tax , description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. , implementation_dba_data: ZX.ZX_REGIMES_B ,
Table: ZX_PARTY_TAX_PROFILE 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE, object_name:ZX_PARTY_TAX_PROFILE, status:VALID, product: ZX - E-Business Tax , description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. , implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,
Table: ZX_PARTY_TAX_PROFILE 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE, object_name:ZX_PARTY_TAX_PROFILE, status:VALID, product: ZX - E-Business Tax , description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. , implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,