AME PO Approval Fails With "ORA-20108: The transaction ID specified returned an incorrect number of rows for <Column_name>" (Doc ID 1986519.1)

Last updated on AUGUST 11, 2016

Applies to:

Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Aug-2016***

Symptoms

Approval Management Engine (AME) Purchase Order (PO) approvals fail with the following error:


Steps:
   1. Set up an AME rule for transaction type "Purchase Order Approval".
   2. Submit a PO for approval or perform the Real Transaction Test from Approval Management Engine (AME) Workbench

This issue occurs even after applying the fix in <Note 1581227.1> "PO AME Attributes Error Out When Running Test In AME Workbench", bouncing the instance and confirming there are no invalids.

Changes

This issue occurs after an upgrade.

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