Search Results payables




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: ZXCLPPLR 12.1.1

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

  • Concurrent Program: ZXCLPPLR 12.2.2

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

  • Concurrent Program: ZXLEJAJL 12.2.2

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

  • Concurrent Program: ZXTWPSPC 12.2.2

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

  • Concurrent Program: ZXARPVBR 12.1.1

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

  • Concurrent Program: ZXARPVBR 12.2.2

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

  • Concurrent Program: ZXAPJAJL 12.1.1

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

  • Concurrent Program: ZXAPJAJL 12.2.2

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

  • Concurrent Program: ZXLEJAJL 12.1.1

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

  • Concurrent Program: ZXTWPSPC 12.1.1

    execution_filename: ZXAPJAJL ,  product: ZX - E-Business Tax ,  user_name: Payables Tax Report by Ledger/Operating Unit ,  description: Payables 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 , 

  • Lookup Type: ZX_TRL_PRODUCT_CODE 12.2.2

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

  • Concurrent Program: ZXTWPVAT 12.1.1

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

  • Concurrent Program: ZXTWPSPC_XML 12.1.1

    product: ZX - E-Business Tax ,  user_name: Taiwanese Payables Sales/Purchase Return and Discount Certificate (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Payables Sales/Purchase Return and Discount Certificate ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXTWPSPC_XML 12.2.2

    product: ZX - E-Business Tax ,  user_name: Taiwanese Payables Sales/Purchase Return and Discount Certificate (XML) - Not Supported: Reserved For Future Use ,  description: Taiwanese Payables Sales/Purchase Return and Discount Certificate ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ZXSGGF5 12.1.1

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

  • Concurrent Program: ZXSGAGAL 12.2.2

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

  • Concurrent Program: ZXTWPPRD 12.2.2

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

  • Concurrent Program: ZXTWPVAT 12.2.2

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

  • Concurrent Program: ZXXTATAT 12.2.2

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

  • Concurrent Program: ZXSGGF5 12.2.2

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

  • Concurrent Program: ZXXTATAT 12.1.1

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

  • Concurrent Program: ZXTWPPRD 12.1.1

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

  • Concurrent Program: ZXXTAVAR 12.2.2

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

  • Concurrent Program: ZXXTAVAR 12.1.1

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

  • Concurrent Program: ZXSGAGAL 12.1.1

    execution_filename: ZXAPJAJL ,  product: ZX - E-Business Tax ,  user_name: Payables Tax Report by Ledger/Operating Unit ,  description: Payables 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_PO_DEFAULT_HIERARCHY 12.1.1

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

  • Lookup Type: ZX_PO_DEFAULT_HIERARCHY 12.2.2

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

  • Lookup Type: ZX_AP_DEFAULT_HIERARCHY 12.2.2

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

  • Lookup Type: ZX_AP_DEFAULT_HIERARCHY 12.1.1

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