EEX9.0+: Expense Profile Update Process (EX_EE_UPDATE) Creates Multiple Default Employee Profiles (Doc ID 1679404.1)

Last updated on MAY 02, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Employee Data Load (EX_EE_UPDATE) process creates multiple default profiles for an employee.
 
Steps
---------

1. Whenever an employee is Retired or Terminated and then Activated, the previous row should always be “non default”.
2. However, currently the app engine only makes default profile flag to N for terminated employees who have recently become active.
3. It takes no action for the Retired employees. As a result, when the retired employees become active, the default profile flag remain active: thus more than 1 default profile flag.


Actual result
-----------------
Expense Profile update process (EX_EE_UPDATE) creates multiple default expense profiles.

Expected result
--------------------
Employee should have only one default profile.

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