My Oracle Support Banner

"Created By" LOV In Iprocurement Search Does Not Show Terminated Employees (Doc ID 2721373.1)

Last updated on OCTOBER 19, 2020

Applies to:

Oracle iProcurement - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Requisition Management

ACTUAL BEHAVIOR
---------------
"Created By" List Of Values (LOV) in Iprocurement Search does not show terminated employees

Issue began to occur after upgrade from R12.2.7 to R12.2.9 and the database upgraded from 11 to 19c.

After the upgrade the "Created By" LOV in the Requisition Search and Receiving Search does not show terminated employees. 


EXPECTED BEHAVIOR
-----------------------
Expect to be able to see all employees who have created document regardless of whether working or terimated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iProcurement > Requisitions tab
2. Click on Search button > Search and Select: Requisition Created By
3. Search by Name for a known terminated employee
4. Unable to find terminated employee

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