Skip to main content

R12: Payables Holds Explained – Why They are Applied and How to Remove


Invoice Validation checks the matching, tax, period status, exchange rate, and distribution information for invoices you enter. If an invoice has a hold, you can release the hold by correcting the exception that caused Invoice Validation to apply the hold by updating the invoice or the purchase order, or changing the invoice tolerances. Then resubmit Invoice Validation to release the hold.
In the Invoice Holds tab, you can manually release certain invoice holds, even if you have not resolved the matching error condition.
Here are some of the regular holds and explanation
Account HoldsPayables uses holds with this type to identify invoices with invalid or incorrect accounts. An invalid account prevents payment of an invoice and prevents Payables from creating accounting entries for an invoice or payment.
  • Dist Acct Invalid: Invoice distribution distributed to invalid account. To release the holds you must correct account and resubmit invoice validation.
  • ERV Acct Invalid: Payables created invalid Exchange Rate Variance account for invoice distribution. Used only if you enable Automatic Offsets. To release the holds you must correct account and resubmit invoice validation.
Invoice HoldsPayables applies holds with this type to invoices. You can manually apply as many of these holds to an invoice as you require when you enter or adjust the invoice.
  • Amount: Invoice amount is more than the invoice amount limit you specify for a supplier site. There are different ways to remove this hold:
    • Adjust invoice amount and resubmit invoice validation.
    • Change invoice amount limit option for supplier site and resubmit invoice validation.
    • Manually release in the invoice holds tab.
  • Invalid PO: You apply this hold when a supplier does not provide a valid purchase order number for matching. Manually release it in the Invoice Holds tab. (Note: you can submit the Invalid PO Supplier Notice to request a valid PO from the supplier).
  • Natural Account Tax: You assigned a tax code to an expense or asset account in the Tax Options window, and you enabled the Enforce Tax From Account Payables option. The tax code on the invoice does not match the tax code assigned to the account. There are different ways to remove this hold:
    • Change the tax code on the invoice to match the tax code assigned to the account.
    • Disable the Enforce Tax From Account in E-Business Tax Defaults and Controls: Configuration Owner Tax Options tab.
    • In the Tax Options window in General Ledger, change the tax code association.
    • Manually release the hold in the invoice holds tab.
  • Supplier:You enabled the hold unvalidated invoices option for a supplier site in the Suppliers Sites window. You can manually release in the Invoice Holds tab. To prevent future Supplier holds, disable
    the hold unvalidated invoices supplier site option.
  • Withholding Tax:Payables cannot perform automatic withholding of tax. Correct error that caused automatic withholding of tax to fail. For example, you may need to set up a period in the withholding tax special calendar.
Matching Holds
Payables applies holds with this type to an invoice if the invoice violates predefined matching criteria.
  • AMT ORD:Amount Billed is greater than Amount Ordered * (1 + % Ordered tolerance). There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Holds tab.
  • AMT REC:Amount Billed is greater than Amount Received * (1 + % Received tolerance). There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Holds tab.
  • MAX AMT ORD:Amount Billed is greater than the sum of Amount Ordered and Maximum Amount Ordered
    Tolerance Amount. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Holds tab.
  • MAX AMT REC:
    Amount Billed is greater than the sum of Amount Received and Maximum Amount Received
    Tolerance Amount. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Holds tab.
  • MILESTONE:Quantity or Amount Billed is not equal to the total Quantity or Amount Ordered. This is a System hold – Correct PO or invoice and resubmit Invoice Validation or release the hold manually.
  • Can’t Close PO:Online receipt accrual enabled in Purchasing and Purchase order quantity delivered is not equal to the quantity received. Resolve purchase order delivery information in Purchasing and resubmit
    Invoice Validation or release the hold manually.
  • Can’t Try Final Close:Invoice (final matched to purchase order) placed on hold during Invoice Validation. Release hold that caused invoice to be placed on hold and resubmit Invoice Validation.
  • Final Matching:Invoice is matched to a purchase order that was final matched by another invoice. Reverse the distribution and resubmit Invoice Validation to remove the Final Matching hold.
  • Matching Required:
    You have enabled the Hold Unmatched Invoices option in the Supplier Sites window, and the invoice is not matched to purchase order or receipt. Match invoice to purchase order or
    receipt and resubmit Invoice Validation or release the hold manually.
  • Max Qty Ord:Quantity billed more than the sum of (quantity ordered plus the tolerance amount). There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Max Qty Rec:Quantity billed is more than the sum of (quantity received plus the tolerance amount). There are different ways to remove this hold:
    • Correct invoice or receipt and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Max Rate Amount:Exchange rate variance exceeds amount tolerance limit. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Max Ship Amount:Variance between invoice and shipment amount exceeds amount tolerance limit. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Max Total Amount:Sum of invoice and exchange rate variances exceeds amount tolerance limit. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Price:Weighted average price of all distributions on the matched invoice and all price corrections related to the invoice is more than [purchase order unit price (1 plus % tolerance)]. There are different ways to remove this hold:
    • Correct PO, invoice, or price corrections and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Qty Ord:Quantity billed is more than [quantity ordered (1 plus % tolerance)]. There are different ways to remove this hold:
    • Correct PO or invoice and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Qty Rec:Quantity billed is more than [quantity received (1 plus % tolerance)]. There are different ways to remove this hold:
    • Enter receipt in Purchasing and resubmit Invoice Validation.
    • Adjust tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Quality:Quantity billed is more than quantity accepted. Enter acceptance in Purchasing and resubmit Invoice Validation or release the hold manually.
  • Rec Exception:Purchase order receipt indicates exception. Please note this hold is not set at invoice validation time. It’s created manually in Purchasing. You can release it manually in the Invoice Holds tab.
  • Tax Difference:Invoice tax code value is not equal to the purchase order tax code. Invoice tax code value = purchase order tax code value, but taxable flag set to No for PO shipments. Correct PO or invoice and resubmit Invoice Validation or release the hold manually.
Variance HoldsPayables applies the Dist Variance hold to an invoice if the total of the invoice distributions does not equal the invoice amount. Payables applies the Tax Variance and Tax Amount Range holds by verifying that the invoice’s distribution tax amount matches the calculated tax for the Tax Code within the amount tolerance or percentage tolerance or both that you define. If the variance exceeds a percentage tolerance, Payables applies the Tax Variance hold. If the variance exceeds an amount tolerance, Payables applies the Tax Amount Range hold.
  • Dist Variance:
    Invoice line amount is not equal to the related sum of invoice distribution amounts. Adjust invoice distributions or invoice amount and resubmit Invoice Validation. If adjustment is not possible reverse distribution line and re-enter a new one or discard line.
  • Line Variance:Sum of invoice line amounts is not equal to the invoice header amount. Add an invoice line, adjust invoice lines or invoice amount and resubmit Invoice Validation. If adjustment is not possible discard line and re-enter a new one.
  • Prepaid Amount:The prepaid amount including tax exceeds the invoice amount. Unapply the prepayment and apply a lower amount.
  • Tax Amount Range:
    Tax amount is less than [(tax rate taxable dist line total) - tolerance amount] or Tax amount is more than [(tax rate taxable dist line total) + tolerance amount]. There are different ways to remove this hold:
    • Adjust tax rate for tax code and resubmit Invoice Validation.
    • Change tax code or tax group on invoice distributions and resubmit Invoice Validation.
    • Adjust tax tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
  • Tax Variance:Tax amount is less than [(tax rate taxable dist line total) (1 - % tolerance)] or Tax amount is more than [(tax rate taxable dist line total) (1 + % tolerance)]. There are different ways to remove this hold:
    • Adjust tax rate for tax code and resubmit Invoice Validation.
    • Change tax code values on invoice distributions and resubmit Invoice Validation.
    • Adjust tax tolerance and resubmit Invoice Validation.
    • Manually release in the Invoice Holds tab.
Miscellaneous Holds
Miscellaneous predefined Hold that Payables uses to apply holds to invoices.
  • No Rate:
    No exchange rate for foreign currency invoice. Enter exchange rate and resubmit Invoice Validation or submit AutoRate and resubmit Invoice Validation.
  • All Payments:You enabled the Hold All Payments option for the invoice’s supplier site. Disable the Hold All Payments option in the Supplier Sites window and Payables allows you to select the supplier site’s invoices for payment if they are validated  (and approved, if the invoice requires invoice approval) or create a manual payment for any of the held invoices.
  • Supplier:Hold all unvalidated invoices for a supplier. Remove the hold in the Invoice Holds tab, or use the Actions button. To disable completely, disable the Hold Unvalidated Invoices option at the supplier site.

Comments

Popular posts from this blog

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...