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 NOVEMBER 05, 2018

Applies to:

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

Symptoms

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 an Invoice, then check the results in the menu option "Reports > View Invoice Approval History", and the Approver List is shown correctly as expected.
Then, the same Invoice is Validated.  But, this time there is a validation issue; the following message pops up right after checking [x]Validate and [OK] in the "Actions.." window.

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.