My Oracle Support Banner

R12: AP: Invoice is Stuck In Approval Workflow Due To Error APP-SQLAP-10000: ORA-20108: The Transaction ID Specified Returned an Incorrect Number of Rows (Doc ID 2992320.1)

Last updated on DECEMBER 11, 2023

Applies to:

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

Symptoms

Invoice is struck with approval status of initiated and no approval notification is sent and following
error can be seen while clicking on approval history

"APP-SQLAP-10000: ORA-20108: The Transaction ID specified returned an incorrect number of rows
for TRANSACTION_REQUESTOR_PERSON_ID"


==Steps To Reproduce==

1. Navigation: Payables Super User Responsibility->Invoices-Invoice workbench
2. Create new invoice
3. Initiate for approval
4. Click on Actions->Approval History

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