Applying Leave in SSHR, Duration Not Calculated And Receive Error: FND_DATA_SECURITY.GET_SECURITY_PREDICATE_HELPER
Last updated on DECEMBER 21, 2017
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
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:
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms