Oracle Fusion · Data dictionary
AP_TOLERANCE_TEMPLATES
PayablesUsed in 10 subject areas10 reporting columns
Payables (AP).
Primary key: TOLERANCE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| MAX_QTY_ORD_TOLERANCE | ● | Max quantity ord tolerance. | |
| MAX_QTY_REC_TOLERANCE | ● | Max quantity rec tolerance. | |
| PRICE_TOLERANCE | ● | Price tolerance. | |
| QTY_RECEIVED_TOLERANCE | ● | Quantity received tolerance. | |
| QUANTITY_TOLERANCE | ● | Quantity tolerance. | |
| RATE_AMT_TOLERANCE | ● | Rate amount tolerance. | |
| SHIP_AMT_TOLERANCE | ● | Shipment amount tolerance. | |
| TOLERANCE_ID | PK | ○ | Identifier for the tolerance. |
| TOLERANCE_NAME | ● | Name of the tolerance. | |
| TOLERANCE_TYPE | ● | Type of tolerance. | |
| TOTAL_AMT_TOLERANCE | ● | Total amount tolerance. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to AP_TOLERANCE_TEMPLATES.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Payables Invoices - Holds Real Time
- Payables Invoices - Installments Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Supplier - Supplier Real Time
- Supplier Import - Supplier Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for AP_TOLERANCE_TEMPLATES?
We ship parameterized SQL, BICC config, and dbt models you own.