Error In Workflow APINVAPR 20108: The transaction ID specified returned an incorrect number of rows for DOCUMENT_CATEGORY (Doc ID 1672353.1)

Last updated on SEPTEMBER 05, 2014

Applies to:

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

Symptoms

Unable to approve invoices/expense reports from email.

Clicking on the Approved link appears to work correctly, but the user who recieves the email sees the following error within it:

ERROR
-----------------------
Error in Workflow APINVAPR/XXX_1 ORA-20108: The transaction ID specified returned an
incorrect number of rows for DOCUMENT_CATEGORY. Ensure you specify a valid transaction ID and the dynamic query of
the attribute returns correct n...



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. From email

2. Click on the Approved link

3. User who receives the email gets the error:

Error in Workflow APINVAPR/1249845_1 ORA-20108: The transaction ID specified returned an
incorrect number of rows for DOCUMENT_CATEGORY. Ensure you specify a valid transaction ID and the dynamic query of
the attribute returns correct n...

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot approve expense report.

Cause

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 hundreds of Community platforms