Applying Leave in SSHR, Duration Not Calculated And Receive Error: FND_DATA_SECURITY.GET_SECURITY_PREDICATE_HELPER (Doc ID 750714.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.0.4 and later
Information in this document applies to any platform.
Oracle HRMS (Self Service) - Version: 12.0.4



Symptoms

On 12.0.4 in Production:

When attempting to apply leave using SSHR, on selecting Start Time or End Time which leads to calculation in decimals/fractions the following error occurs:

An unexpected situation occured while executing routine FND_DATA_SECURITY.GET_SECURITY_PREDICATE_HELPER. The cause was: The parameter p_object_name can not be 'GLOBAL'..

 
The absence creation works fine when duration is without decimals

 

The following test case works fine

start : 11:00
end time : 12:00
total hours = 1


Issue is with this case


start : 11:00
end time : 12:30
total hours = nothing is calculated

An unexpected situation occured while executing routine
FND_DATA_SECURITY.GET_SECURITY_PREDICATE_HELPER. The cause was: The parameter p_object_name can not be 'GLOBAL'..

  

Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1. Employee Self Service
2. Absence Management
3. Create Absence
4. Enter Start and End date
5. Enter Start and End time as 9:00 and 11:30 respectively

No duration is calculated and above error is shown

Users are able to proceed to the Review page and submit the transaction. On the review page duration is not displayed.
Once data gets comitted to the tables, duration is shown in core apps.



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