API HR_PERSON_API.UPDATE_US_PERSON OR UPDATE_PERSON is Setting Email_address In FND USER FORM/ fnd_user table To $sys_def$ After Updating Person Information (Doc ID 2893993.1)

Last updated on JANUARY 03, 2024

Applies to:

Symptoms

On : 12.2.9 version, API

RUP Level =R12.HR_PF.C.Delta.15

ACTUAL BEHAVIOR
---------------
When user try to update person records(first name, middle name and last name) using " hr_person_pkg.update_us_person api or update_person ",  it is changing email address in FND_USER form/table to $sys_def$.
.
EXPECTED BEHAVIOR
-----------------------
It should not be update the email address if API is not updating the same.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to Application with System Administrator > Security > User > Define
2. Check the email address the Person/User
          Example xxxx.xx@xxx.com
3. Execute the script using hr_person_pkg.update_us_person api for the same person which was verified from the FND USER
4. Check the FND USER screen after API update.
5. FND USER email address seen as "$sys_def$"

Note: 1. This may happen in self service application.

         2. This issue comes only if workflow/approvals is enabled.

Cause

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