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 NOVEMBER 19, 2020

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***

Symptoms

-- 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:

ERROR
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.

Cause

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
Symptoms
Cause
Solution

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