My Oracle Support Banner

Transaction Using Custom Attribute Raises Error “The Transaction ID Specified Returned An Incorrect Number Of Rows” (Doc ID 550619.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Approvals Management - Version 12.0 and later
Oracle Self-Service Human Resources - Version 12.0 and later
Information in this document applies to any platform.


-- Problem Statement:
On 12.0 in Production:
Created a new custom attribute Called “Special Information” this attribute is used for SIT transaction ('HR_SIT_JSP_PRC’) and it is working fine in SIT transaction but the other rule for not SIT does not work like ( LoA , change hour ,…)
So, when run any transaction not SIT the following error occurs:

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

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1- Create new attribute which is used by SIT.
2- Test SIT it works as expected.
3- When try to run any other transaction under Self Service it raise error.


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.