Search Results receivables




The ZX_REP_TRX_DETAIL_T table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for tax reporting and compliance data. It stores transactional tax details that are essential for generating tax reports, reconciling tax liabilities, and ensuring regulatory adherence. This table is part of the Oracle E-Business Tax (ZX) module, which manages tax calculations, reporting, and compliance across financial and supply chain transactions.

Table Structure and Key Columns

The ZX_REP_TRX_DETAIL_T table contains detailed tax information for each transaction, including tax amounts, rates, jurisdictions, and tax-registration details. Key columns include:

  • TRX_ID: Unique identifier for the transaction.
  • TAX_EVENT_CLASS_CODE: Classifies the tax event (e.g., invoice, receipt).
  • TAX_REGIME_CODE: Identifies the tax regime (e.g., VAT, GST).
  • TAX: Tax amount calculated for the transaction.
  • TAX_STATUS_CODE: Status of the tax (e.g., calculated, accounted).
  • TAX_RATE_CODE: The applied tax rate.
  • JURISDICTION_CODE: Geographic jurisdiction for the tax.
  • LEGAL_ENTITY_ID: Links to the legal entity responsible for the tax.

Functional Role in Oracle EBS

The table serves as the backbone for tax reporting processes, including:

  • Tax Reporting: Data from this table feeds into standard and custom tax reports, such as VAT returns or sales tax filings.
  • Reconciliation: Ensures tax calculations align with general ledger postings.
  • Audit Support: Provides traceability for tax authorities by storing granular transaction-level details.
  • Compliance: Supports region-specific tax rules and updates, ensuring adherence to changing regulations.

Integration with Other Modules

ZX_REP_TRX_DETAIL_T integrates with:

  • AP/AR: Captures tax details from invoices and receipts.
  • GL: Links tax data to accounting entries for reconciliation.
  • Inventory: Tracks tax on goods movements.
  • E-Business Tax Engine: Populates the table with calculated tax data during transaction processing.

Technical Considerations

  • Indexing: Optimized for query performance on TRX_ID, TAX_EVENT_CLASS_CODE, and LEGAL_ENTITY_ID.
  • Partitioning: In high-volume environments, partitioning by date or legal entity improves maintenance and performance.
  • Purge Policies: Data retention policies should align with statutory requirements to avoid unnecessary storage overhead.

Customization and Extensions

Organizations often extend this table for:

  • Custom Tax Attributes: Adding columns for region-specific tax fields.
  • Reporting Views: Creating summary views for analytics.
  • API Integrations: Building interfaces to third-party tax engines or compliance tools.

Conclusion

The ZX_REP_TRX_DETAIL_T table is a cornerstone of Oracle EBS tax functionality, ensuring accurate tax reporting and compliance. Its design supports scalability, integration, and customization, making it indispensable for multinational organizations navigating complex tax landscapes. Proper configuration and maintenance of this table are vital for audit readiness and operational efficiency.

  • Concurrent Program: ZXCLRSLL 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRUIL 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXLERECV 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRZTR 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRUIL 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRZTR 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXCOARSW 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXARRECV 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXARRECV 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXCLRSLL 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXCOARSB 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXLERECV 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXCOARSB 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXCOARSW 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXZZTVSR 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXZZTVSR 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRUIL_XML 12.1.1

    product: ZX - E-Business Tax ,  user_name: Taiwanese Receivables Government Uniform Invoice Report (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Receivables Government Uniform Invoice Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXTWRZTR_XML 12.2.2

    product: ZX - E-Business Tax ,  user_name: Taiwanese Receivables Zero-Rate Tax Report (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Receivables Zero Rate Tax Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXTWRZTR_XML 12.1.1

    product: ZX - E-Business Tax ,  user_name: Taiwanese Receivables Zero-Rate Tax Report (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Receivables Zero Rate Tax Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXXSTVRR 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXXSTVRR 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: ZX_TRL_PRODUCT_CODE 12.1.1

    product: ZX - E-Business Tax ,  meaning: TRL Product Code ,  description: Product Code , 

  • Concurrent Program: ZXTWRUIL_XML 12.2.2

    product: ZX - E-Business Tax ,  user_name: Taiwanese Receivables Government Uniform Invoice Report (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Receivables Government Uniform Invoice Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXXVATRN 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: ZX_TRL_PRODUCT_CODE 12.2.2

    product: ZX - E-Business Tax ,  meaning: TRL Product Code ,  description: Product Code , 

  • Concurrent Program: ZXTWSPRF 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXXVATRN 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRVAT 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRSRD 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXXCDE 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRVAT 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXXCDE 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWSPRF 12.2.2

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ZXTWRSRD 12.1.1

    execution_filename: ZXARRECV ,  product: ZX - E-Business Tax ,  user_name: Receivables Tax Report by Ledger/Operating Unit ,  description: Receivables Tax Report by Ledger/Operating Unit ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Table: ZX_REP_TRX_DETAIL_T 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REP_TRX_DETAIL_T,  object_name:ZX_REP_TRX_DETAIL_T,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax lines information from Payables, Receivables and General Ledger. ,  implementation_dba_data: ZX.ZX_REP_TRX_DETAIL_T , 

  • Table: ZX_REP_TRX_DETAIL_T 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REP_TRX_DETAIL_T,  object_name:ZX_REP_TRX_DETAIL_T,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax lines information from Payables, Receivables and General Ledger. ,  implementation_dba_data: ZX.ZX_REP_TRX_DETAIL_T , 

  • Lookup Type: ZX_AR_DEFAULT_HIERARCHY 12.2.2

    product: ZX - E-Business Tax ,  meaning: AR Defaulting Hierarchy for Tax Codes , 

  • Lookup Type: ZX_AR_DEFAULT_HIERARCHY 12.1.1

    product: ZX - E-Business Tax ,  meaning: AR Defaulting Hierarchy for Tax Codes , 

  • Lookup Type: ZX_PA_DEFAULT_HIERARCHY 12.2.2

    product: ZX - E-Business Tax ,  meaning: PA Defaulting Hierarchy for Tax Codes , 

  • Lookup Type: ZX_PA_DEFAULT_HIERARCHY 12.1.1

    product: ZX - E-Business Tax ,  meaning: PA Defaulting Hierarchy for Tax Codes ,