Transaction Using Custom Attribute Raises Error “The Transaction ID Specified Returned An Incorrect Number Of Rows”
(Doc ID 550619.1)
Last updated on OCTOBER 12, 2021
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.
***Checked for relevance on 12-May-2014***
-- 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