My Oracle Support Banner

R12: AP: AME Fails With "APP-SQLAP-10000: ORA-20001: The Transaction ID Specified Returned An Incorrect Number Of Rows", During Invoice Validation (Doc ID 2468791.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


An invoice is created with tax and freight against a distribution that has budgetary control warnings, approval list generates correctly when first initiating approval but errors after Invoice Validation executed.  Invoice Approval is initiated for the invoice, then check the results in the menu option "Reports > View Invoice Approval History", and the Approver List is shown correctly, as expected.  Then, validation is attempted, but the following error occurs:

APP-SQLAP-10815: This invoice, line or distribution passed
budgetary control with advisory warnings. Please View
Budgetary Control Results from the Tools menu to see


Invoice approval list generated correctly when first initiating approval.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.