Search Results zx_lines_summary

Overview

The ZX_LINES_SUMMARY 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 a critical performance and consolidation function by storing aggregated tax calculation results. Instead of holding every individual tax line, this table maintains summarized tax lines for transactions across multiple event classes, such as Payables, Receivables, and Purchasing. Its primary role is to optimize tax reporting and reconciliation processes by providing a pre-consolidated view of tax liabilities, recoverable amounts, and non-recoverable amounts, which is essential for generating accurate tax reports and journal entries.

Key Information Stored

The table's structure is defined by its primary key, SUMMARY_TAX_LINE_ID, which uniquely identifies each summarized tax record. Key columns include identifiers for the tax regime (TAX_REGIME_CODE), specific tax (TAX), and the applicable tax rate (TAX_RATE_ID). It holds critical financial amounts like the taxable basis (TAXABLE_BASIS_AMT), calculated tax amount (TAX_AMT), and distinguishes between recoverable and non-recoverable tax. The table also stores contextual information linking the summary to the originating transaction, including the internal organization (INTERNAL_ORGANIZATION_ID), ledger (LEDGER_ID), and application entity details (APPLICATION_ID, ENTITY_CODE). References to tax determinations like exemptions (TAX_EXEMPTION_ID) and exceptions (TAX_EXCEPTION_ID) are also maintained.

Common Use Cases and Queries

A primary use case is the generation of tax reports for statutory compliance or internal audit, where summarized data improves query performance. Another key scenario is the reconciliation of total tax calculated versus tax posted to the general ledger. Development and support tasks often involve tracing summarized tax back to detailed transaction lines for debugging purposes.

Sample Query for Tax Summary by Regime:
SELECT TAX_REGIME_CODE, SUM(TAX_AMT) TOTAL_TAX FROM ZX.ZX_LINES_SUMMARY WHERE LEDGER_ID = 1001 GROUP BY TAX_REGIME_CODE;
Linking to Detailed Lines: Joining ZX_LINES_SUMMARY to ZX_LINES on SUMMARY_TAX_LINE_ID is essential for drilling down from a summary record to its constituent detailed tax lines.
Reconciliation Check: Queries often join this table to GL import tables (via LEDGER_ID and other keys) to verify that summarized tax amounts match posted journal entry amounts.

Related Objects

The ZX_LINES_SUMMARY table is a central hub in the E-Business Tax schema, with documented foreign key relationships to numerous fundamental tables.

ZX_LINES: Detailed tax lines reference a summary line via ZX_LINES.SUMMARY_TAX_LINE_ID.
ZX_REC_NREC_DIST: Recovery/non-recovery distributions reference the summary via ZX_REC_NREC_DIST.SUMMARY_TAX_LINE_ID.
Tax Master Data: It links to tax regime (ZX_REGIMES_B), tax rate (ZX_RATES_B), jurisdiction, exemption (ZX_EXEMPTIONS), and exception (ZX_EXCEPTIONS) definitions.
Party and Organization Data: References the content owner's tax profile (ZX_PARTY_TAX_PROFILE.CONTENT_OWNER_ID), the tax provider (ZX_PARTY_TAX_PROFILE.TAX_PROVIDER_ID), and the internal organization (HR_ALL_ORGANIZATION_UNITS).
Subledger Accounting (XLA) and General Ledger: Integrates with the subledger accounting entity (XLA_ENTITY_TYPES_B) for the source, applied from, and adjusted document contexts, and links to the ledger (GL_LEDGERS).

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_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_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_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_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_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_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_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_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_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 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 ,