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 APRIL 04, 2025

Applies to:

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

Symptoms

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
details.

Changes

Invoice approval list generated correctly when first initiating approval.

 

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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