My Oracle Support Banner

Drop Ship POs In AME Test Work Bench Error With "The Transaction ID Specified Returned An Incorrect Number Of Rows For DELIVER_TO_LOCATION_CODE" (Doc ID 1683511.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.


On 12.2.3 version when using the Approval Management Engine (AME) Test Transaction Workbench, with the AME_APPROVAL_ID for a drop ship Purchase Order (PO), the test transaction fails with error:

The Transaction ID specified returned an incorrect number of rows for DELIVER_TO_LOCATION_CODE.
Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows

The same error will occur for SHIP_TO_LOCATION_CODE and PROJECT_NUMBER attributes as well.

The actual transaction, the drop ship PO itself, did not have an error when the PO was approved. The appropriate AME approvers were notified and the PO approved successfully.

It is only an issue in the AME Test Workbench.

The issue can be reproduced at will with the following steps:
1. Get the AME_APPROVAL_ID from PO_HEADERS_ALL for the drop ship PO
2. Run the Transaction Test
3. Error occurs


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.