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 MAY 04, 2023

Applies to:

Symptoms

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

ERROR
-----------------------
No Items Found.


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

:RESOURCE_IDENTIFIER_ID
:TIMECARD_BIND_START_DATE
:TIMECARD_BIND_END_DATE

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'

Changes

Cause

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