Search Results zx_lines




The ZX_LINES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Tax Engine (eTax), which handles tax calculation, validation, and reporting. This table stores transactional tax line details, serving as a foundation for tax determination, accrual, and reconciliation processes. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Overview of ZX_LINES

The ZX_LINES table is part of the ZX (Tax Module) schema in Oracle EBS. It captures tax line-level data generated during transactions (e.g., invoices, receipts, journal entries). Each record represents a tax line associated with a transaction, including calculated tax amounts, tax rates, jurisdictions, and tax registration details. Key attributes include:

  • TAX_LINE_ID: Primary key, uniquely identifying each tax line.
  • APPLICATION_ID: Module generating the tax line (e.g., 200 for Payables, 222 for Receivables).
  • ENTITY_CODE: Transaction type (e.g., 'AP_INVOICES' for Payables).
  • EVENT_CLASS_CODE: Tax event category (e.g., 'INVOICE', 'PAYMENT').
  • TAX_AMT: Calculated tax amount.
  • TAX_RATE: Applied tax rate.
  • TAX_JURISDICTION_CODE: Jurisdiction imposing the tax.
  • TAX_REGISTRATION_NUMBER: Tax ID of the legal entity.
  • TAX_DATE: Date triggering tax calculation.

Functional Role in Oracle EBS

The ZX_LINES table supports:

  1. Tax Calculation: Stores real-time tax determinations based on rules defined in ZX_RATES_B, ZX_JURISDICTIONS_B, and ZX_REGISTRATIONS.
  2. Tax Reporting: Provides data for statutory reports (e.g., VAT, GST) via Oracle E-Business Tax Reporting.
  3. Audit & Compliance: Maintains a granular audit trail for tax authorities.
  4. Integration: Links to transactional tables (e.g., AP_INVOICE_LINES, AR_ADJUSTMENTS) via TRX_LINE_ID and TRX_ID.

Key Relationships

The table integrates with other ZX tables:

  • ZX_LINES_SUMMARY: Aggregates tax lines for reporting.
  • ZX_REC_NREC_DIST: Tracks recoverable/non-recoverable tax splits.
  • ZX_TRANSACTION_LINES: Parent table for transactional context.

Technical Considerations

In EBS 12.2.2, ZX_LINES leverages Oracle's Online Patching (ADOP) for maintenance. Indexes like ZX_LINES_N1 (on TRX_ID, TRX_LINE_ID) optimize query performance. Partitioning may be applied for high-volume environments.

Customization & Extensions

While Oracle discourages direct DML on ZX_LINES, extensions can be achieved via:

  • API: Use ZX_API_PUB for programmatic tax line creation.
  • Event Hooks: Customize tax logic using ZX_CONDITIONS and ZX_EXCEPTIONS.

Conclusion

The ZX_LINES table is central to Oracle EBS's tax functionality, ensuring accurate tax processing across financial modules. Its design reflects compliance with global tax regulations, while its integration with transactional and tax master data enables end-to-end tax lifecycle management. Proper understanding of this table is essential for troubleshooting tax issues or extending tax logic in implementations.

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