R12: Master Note: Payables Invoice Validation Errors with APP-SQLAP-10000 and ORA-20001 Error Messages (Doc ID 1308938.1)

Last updated on MAY 31, 2017

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
APPRVL - Invoice Validation
APXINWKB - Invoice Workbench


Symptoms

Oracle Payables (AP) Information Center > Invoices > Note 1308938.1

Important Note: The objective of a Individual Error Note is to take a specific error message (usually a handled error message but can be an unhandled error in certain cases) and explain the various causes and solutions for that error.


Unable to validate invoice due to the following error:

ORA-20001: APP-SQLAP-10000: User-Defined Exception occurred in AP_FUNDS_CONTROL_PKG.Funds_Reserve

or

ORA-20001: Unexpected error occurred during Tax Calculation

or

ORA-20001: APP-SQLAP-10000: Frozen Tax Distribution Deleted by EBTax. This would cause orphan events occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions


Steps to Reproduce:
    Oracle Payables responsibility > Invoices > Entry > Invoices
    Actions1 button > Validate
    or
    Other > Requests > Run > Invoice Validation program


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms