Search Results zx_lines

Overview

The ZX_LINES table is a core transactional data repository within the Oracle E-Business Tax (ZX) module for Oracle EBS releases 12.1.1 and 12.2.2. It serves as the central table for storing detailed, line-level tax calculations resulting from the tax determination engine. Every tax calculated for a transaction line—such as an invoice line, order line, or receipt line—is recorded as a distinct record in this table. Its role is critical for maintaining a granular, auditable history of all tax calculations, adjustments, and applications across the enterprise's financial and supply chain transactions.

Key Information Stored

Each record in ZX_LINES represents a single calculated tax line. The table's primary key is TAX_LINE_ID. Key columns store the calculated tax amount, the tax determination logic used, and references to the source transaction. Important columns include TAX_AMT (the calculated tax amount), TRX_LINE_ID and TRX_ID (linking to the source transaction line and header), and APPLICATION_ID and ENTITY_CODE (identifying the originating EBS module, such as Payables or Receivables). Crucially, the table holds foreign keys to the core E-Business Tax setup tables, including TAX_REGIME_CODE, TAX_ID, TAX_STATUS_ID, and TAX_RATE_ID, which define the specific tax rule applied. Other significant columns manage adjustments, summarization, and multi-currency reporting.

Common Use Cases and Queries

This table is essential for tax reporting, reconciliation, and audit inquiries. Common use cases include analyzing tax amounts by jurisdiction for a specific invoice batch, reconciling the tax general ledger accounts, and debugging tax calculation issues. A typical query joins ZX_LINES to transaction tables and tax setup tables to retrieve a comprehensive tax report. For example, to analyze tax lines for Payables invoices, one might use a pattern similar to:

SELECT zl.tax_line_id, zl.trx_id, zl.tax_amt, ztr.tax_regime_code, zt.tax
FROM zx_lines zl
JOIN zx_taxes_b zt ON zl.tax_id = zt.tax_id
JOIN zx_regimes_b ztr ON zl.tax_regime_code = ztr.tax_regime_code
WHERE zl.application_id = 200
AND zl.entity_code = 'AP_INVOICES'
AND zl.trx_id = :p_invoice_id;

Direct data manipulation (DML) on this table is strongly discouraged, as all modifications should occur through the standard E-Business Tax public APIs.

Related Objects

ZX_LINES has extensive relationships with other E-Business Tax objects, primarily through foreign key constraints. Key documented relationships include:

ZX_TAXES_B, ZX_RATES_B, ZX_STATUS_B, ZX_REGIMES_B: Links to the core tax setup definitions (TAX_ID, TAX_RATE_ID, TAX_STATUS_ID, TAX_REGIME_CODE).
ZX_PROCESS_RESULTS: Linked via multiple columns (e.g., CALC_RESULT_ID, TAX_DATE_RULE_ID) to store detailed outputs of various tax determination processes.
ZX_LINES_SUMMARY: Linked via SUMMARY_TAX_LINE_ID for summarization of detailed tax lines.
ZX_LINES (Self-Referential): Linked via columns like OFFSET_LINK_TO_TAX_LINE_ID, ADJUSTED_DOC_TAX_LINE_ID, and REVERSED_TAX_LINE_ID to manage adjustments, reversals, and links between tax lines.
ZX_PARTY_TAX_PROFILE: Linked via multiple columns (e.g., CONTENT_OWNER_ID, TAX_PROVIDER_ID) for party-specific tax profile information.
FND_CURRENCIES: Linked for transaction and reporting currency codes (TRX_CURRENCY_CODE, REPORTING_CURRENCY_CODE).
ZX_EXCEPTIONS, ZX_REGISTRATIONS: Linked for tax exception and registration data.

Table: ZX_LINES 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES, object_name:ZX_LINES, status:VALID, product: ZX - E-Business Tax , description: This table stores detail tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES ,
Table: ZX_LINES 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES, object_name:ZX_LINES, status:VALID, product: ZX - E-Business Tax , description: This table stores detail tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES ,
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_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 ,
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_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_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_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_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_REGISTRATIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REGISTRATIONS, object_name:ZX_REGISTRATIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax registrations. , implementation_dba_data: ZX.ZX_REGISTRATIONS ,
Table: ZX_REGISTRATIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REGISTRATIONS, object_name:ZX_REGISTRATIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax registrations. , implementation_dba_data: ZX.ZX_REGISTRATIONS ,
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_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_EXEMPTIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXEMPTIONS, object_name:ZX_EXEMPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for a party, party site or an item. , implementation_dba_data: ZX.ZX_EXEMPTIONS ,
Table: ZX_EVNT_CLS_TYPS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_TYPS, object_name:ZX_EVNT_CLS_TYPS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS ,
Table: ZX_EXEMPTIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXEMPTIONS, object_name:ZX_EXEMPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for a party, party site or an item. , implementation_dba_data: ZX.ZX_EXEMPTIONS ,
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_EVNT_CLS_TYPS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_TYPS, object_name:ZX_EVNT_CLS_TYPS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. , implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS ,
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_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_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_EXCEPTIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXCEPTIONS, object_name:ZX_EXCEPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation. , implementation_dba_data: ZX.ZX_EXCEPTIONS ,
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_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_EXCEPTIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXCEPTIONS, object_name:ZX_EXCEPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation. , implementation_dba_data: ZX.ZX_EXCEPTIONS ,
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_LINES_DET_FACTORS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES_DET_FACTORS, object_name:ZX_LINES_DET_FACTORS, status:VALID, product: ZX - E-Business Tax , description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. , implementation_dba_data: ZX.ZX_LINES_DET_FACTORS ,
Table: ZX_LINES_DET_FACTORS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES_DET_FACTORS, object_name:ZX_LINES_DET_FACTORS, status:VALID, product: ZX - E-Business Tax , description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. , implementation_dba_data: ZX.ZX_LINES_DET_FACTORS ,