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 AUGUST 25, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

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'

 

 

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