Sourcing AME Based Award Approval Gets Error - The Transaction ID Specified Returned An Incorrect Number Of Rows - Upon Submit for Approval (Doc ID 1954590.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

In 12.1.3 Sourcing

Award Approval in Sourcing gets error that the AME transaction id returned an incorrect number of rows for custom attribute XXABC_PRJ_AB. As a result the Award cannot be submitted for approval.

Users expect the award to be submitted for approval without error since the dynamic query for this attribute XXABC_PRJ_AB returns a single row result when run directly in SQL Developer. But instead, the award submit for approval action gets the error and prevents the user from proceeding with the award approval.  Although the SQL Query returns one record which is added in the AME condition and rules, still the application gives this error.

ERRORS

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


STEPS TO REPRODUCE

1. Define custom Attribute in AME for use with award approval

 

2. Create a condition that uses this attribute

3. Create RFQ 1234

4. Receive responses to the RFQ and close the RFQ from further bidding

5. Award by Quote / Go

    Award Summary (RFQ 1234)
    Status = Award In Progress

6. Submit For Approval (button)
- Get the error

Users cannot approve the award for the RFQ because of the error that occurs when submitting the award for approval.

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