Search Results what is mt-access in rrc setup request




The AP_WEB_VAT_SETUP_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for Value Added Tax (VAT) configuration data used by the Accounts Payable (AP) module. This table stores setup information that governs how VAT is calculated, reported, and validated for supplier invoices processed through the Oracle iSupplier Portal (now known as Oracle Supplier Portal) or other web-based interfaces. Below is a detailed technical breakdown of its structure, purpose, and functional relevance.

Table Overview

AP_WEB_VAT_SETUP_ALL is a multi-organization enabled table (_ALL suffix), meaning it stores data for multiple operating units within a single installation. It serves as the backbone for VAT-related configurations in web-enabled AP workflows, ensuring tax compliance across jurisdictions. The table is primarily referenced during invoice entry, validation, and tax calculation processes.

Key Columns and Their Significance

  • VAT_SETUP_ID: Primary key, uniquely identifying each VAT setup record.
  • ORG_ID: Operating Unit identifier, enforcing multi-org security.
  • TAX_CODE: References the tax code from AP_TAX_CODES_ALL, linking to specific VAT rates.
  • TAX_RATE: Stores the default VAT percentage applied to invoices.
  • ENABLED_FLAG: Boolean (Y/N) to activate/deactivate the VAT rule.
  • START_DATE_ACTIVE/END_DATE_ACTIVE: Defines the validity period for the VAT setup.
  • TAX_REGISTRATION_NUMBER: Mandatory for EU compliance, stores the supplier's VAT registration ID.
  • REVERSE_CHARGE_FLAG: Indicates if reverse charge mechanism applies (common in B2B EU transactions).
  • CREATED_BY/LAST_UPDATED_BY: Audit columns tracking user modifications.

Functional Integration

This table integrates with:
  • AP_INVOICES_ALL: VAT calculations during invoice entry.
  • AP_TAX_CODES_ALL: Tax rate definitions.
  • AP_TAX_REGISTRATIONS: Validates supplier VAT registration numbers.

Configuration Workflow

  1. Tax codes are defined in AP_TAX_CODES_ALL.
  2. VAT rules are mapped in AP_WEB_VAT_SETUP_ALL per operating unit.
  3. During invoice submission via iSupplier Portal, the system cross-references this table for tax applicability.
  4. VAT amounts are auto-calculated based on TAX_RATE and validated against TAX_REGISTRATION_NUMBER.

Technical Considerations

  • Indexes: Primary key index on VAT_SETUP_ID, secondary indexes on ORG_ID and TAX_CODE for performance.
  • Partitioning: In high-volume environments, partitioning by ORG_ID may be implemented.
  • Audit Trail: Changes are logged in FND_AUDIT_SCHEMA if audit policies are enabled.

Common Customizations

Extensions often include:
  • Triggers to enforce country-specific VAT logic.
  • Views joining with HR_OPERATING_UNITS for org-specific reporting.
  • API wrappers for bulk data loads during implementations.

Upgrade Implications

Between 12.1.1 and 12.2.2, the table structure remains largely unchanged, but enhancements in Tax Engine (e.g., Vertex/Oracle Tax Compliance integration) may affect data usage patterns. Always validate custom code post-upgrade. This table is pivotal for global VAT compliance, especially in multi-country deployments. Proper configuration ensures accurate tax reporting and minimizes audit risks.