My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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.