My Oracle Support Banner

SR Owner LOV does not display resource with end-date 4712 (Doc ID 1554415.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Teleservice - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.0 version, Service Request Form

ACTUAL BEHAVIOR
---------------
Resources that have an active_end_date set to 4712-12-31 which is often used as a default, result in the resource not appearing in the SR Owner LOV. The application considers this Resource to be end dated because 4712-12-31 is converted to 2012-12-31.

If the active_end_date is changed to 4713 or 2013 then Resource can be selected in the LOV.


EXPECTED BEHAVIOR
-----------------------
Resources should be available in the LOV even when they have an end date of 31-DEC-4712

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In the JTF Resource form confirm that the resource as an End Date with a year of 4712
2. In the Service Request forms Owner field look for that resource.
3. The resource is not available in the LOV


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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