Search Results ap_tolerance_templates




Overview
Explore in AI Chat

Overview

AP_TOLERANCE_TEMPLATES is a Payables (AP) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores matching and invoice variance testing tolerance levels. Each row defines a named tolerance template that governs how the Payables matching and approval processes evaluate discrepancies between invoice, purchase order, and receipt amounts and quantities. When an invoice is matched to a purchase order or receipt, or when it is submitted for approval, the applicable tolerance template determines the acceptable variance thresholds before an invoice is placed on hold or rejected.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. This is a heuristic suggestion rather than a physical classification: AP_TOLERANCE_TEMPLATES behaves primarily as a descriptive satellite attached to a business key, with only lightweight referential links to FND_USER and FND_LOGINS for audit columns. The table carries no natural parent-child hierarchy within itself; it is a configuration master whose rows are referenced by operational Payables entities.

Key Information Stored

The table contains 19 documented columns. The surrogate primary key is TOLERANCE_ID, enforced by the AP_TOLERANCE_TEMPLATES_PK constraint and mirrored by the unique index AP_TOLERANCE_TEMPLATES_U1, which is the documented business-key candidate. TOLERANCE_ID is the column consumed by all referencing tables, so it functions as both the technical and the propagated integration key.

Common Use Cases and Queries

The most frequent operational scenario is determining which tolerance template applies to a supplier site or to the Payables system as a whole. Because AP_SYSTEM_PARAMETERS_ALL.TOLERANCE_ID and AP_SUPPLIER_SITES_ALL.TOLERANCE_ID both reference this table, a query joining these entities returns the effective tolerance definition:

  • Retrieve all templates for a tolerance setup review: SELECT tolerance_id, tolerance_name, tolerance_type, price_tolerance, quantity_tolerance FROM ap.ap_tolerance_templates;
  • Resolve the system-level default template: SELECT t.* FROM ap.ap_tolerance_templates t, ap.ap_system_parameters_all s WHERE t.tolerance_id = s.tolerance_id;
  • Resolve supplier-site-level templates: SELECT t.tolerance_name, s.vendor_site_code FROM ap.ap_tolerance_templates t, ap.ap_supplier_sites_all s WHERE t.tolerance_id = s.tolerance_id;
  • Audit configuration changes by joining LAST_UPDATED_BY to FND_USER to identify the last editor of each template.

Reporting use cases include reconciliation of invoice hold volume against tolerance settings, impact analysis before tightening thresholds, and data-migration validation when supplier site or system parameter records are staged in AP_SUPPLIER_SITES_INT with a TOLERANCE_ID.

Related Objects

  • AP_SYSTEM_PARAMETERS_ALL — references AP_TOLERANCE_TEMPLATES.TOLERANCE_ID via TOLERANCE_ID; supplies the system-level default tolerance template.
  • AP_SUPPLIER_SITES_ALL — references AP_TOLERANCE_TEMPLATES.TOLERANCE_ID via TOLERANCE_ID; assigns supplier-site-specific tolerance behavior.
  • AP_SUPPLIER_SITES_INT — references AP_TOLERANCE_TEMPLATES.TOLERANCE_ID via TOLERANCE_ID; carries tolerance assignments during supplier site interface processing.
  • FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY for audit traceability.
  • FND_LOGINS — referenced by LAST_UPDATE_LOGIN to capture the session that performed the last update.

These relationships confirm that AP_TOLERANCE_TEMPLATES is a referenced configuration table rather than a transaction table; changes to its rows propagate directly into matching behavior for any invoice processed under the associated system parameters or supplier site.