My Oracle Support Banner

Projects LOV Not Showing Any Values In Mobile Timecards When Referring To RESOURCE_IDENTIFIER_ID In Where Clause (Doc ID 2135417.1)

Last updated on JULY 01, 2021

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

Additional Info:
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
where xxprft_pa_utils.dislay_project(p_project_id => projectid,
p_effective_date => to_date (:TIMECARD_BIND_START_DATE),
p_effective_end_date => to_date (:TIMECARD_BIND_END_DATE)) = 'Y'






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

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