My Oracle Support Banner

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

Last updated on APRIL 28, 2023

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


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.