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).