Search Results ap_tolerance_templates_pk

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.

• TOLERANCE_NAME and DESCRIPTION — the user-facing identifier and explanatory text for the template.
• TOLERANCE_TYPE — the category that determines which matching or variance rule set the template applies to.
• PRICE_TOLERANCE, QUANTITY_TOLERANCE, and QTY_RECEIVED_TOLERANCE — core thresholds for price variance, ordered-quantity variance, and received-quantity variance during matching.
• TAX_TOLERANCE and TAX_TOL_AMT_RANGE — thresholds governing acceptable tax variance and the monetary range within which tax tolerance is evaluated.
• MAX_QTY_ORD_TOLERANCE and MAX_QTY_REC_TOLERANCE — maximum quantity tolerances relative to ordered and received quantities.
• SHIP_AMT_TOLERANCE, RATE_AMT_TOLERANCE, and TOTAL_AMT_TOLERANCE — monetary tolerance limits for shipment, rate, and total invoice amounts.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard audit columns linked to FND_USER and FND_LOGINS.

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.