Projects LOV Not Showing Any Values In Mobile Timecards When Referring To RESOURCE_IDENTIFIER_ID In Where Clause
Last updated on AUGUST 25, 2017
Applies to:Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Mobile Time Entry
Projects LOV not showing any values in mobile timecards App with the customized layout and facing the error message no items found when clicked on Projects LOV
No Items Found.
The issue can be reproduced at will with the following steps:
1. Login through mobile phone to Self Service Time responsibility
2. Select either Quick Time or Time Entry
5. Cannot retrieve the Project list of values instead
get "no Items Found".
LOV for attributes not displaying any values when the value set query refers to any of the following attributes.
We are using projects and payroll layout (customized). Our project list is based on the projects assigned to employee whose timecard is being entered.
This functionality is working fine in self-service.
Created new value set to accomplish the same in mobile timecards. The projects LOV does not display any values. Once we remove the where clause referring to the above parameters, it displays all projects in the system. Below is the SQL query :
select projectdetails, projectid from xxhc_tc_auth_proj_list_v where xxprft_pa_utils.dislay_project(p_project_id => projectid, p_person_id => :RESOURCE_IDENTIFIER_ID, p_effective_date => to_date (:TIMECARD_BIND_START_DATE), p_effective_end_date => to_date (:TIMECARD_BIND_END_DATE)) = 'Y'
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