AME PO Approval Fails With "ORA-20108: The transaction ID specified returned an incorrect number of rows for <Column_name>"
Last updated on JANUARY 12, 2018
Applies to:Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Jan-2018***
Approval Management Engine (AME) Purchase Order (PO) approvals fail with the following error:
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.
This issue occurs after an upgrade.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms