Issue With Public API Fnd_user_pkg.UpdateUser

(Doc ID 2032534.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Application Object Library - Version 12.1.2 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version,

ACTUAL BEHAVIOR
---------------
Issue cannot be consistently reproduced, but following is the steps and details -
1. OAM invokes public api fnd_user_pkg.UpdateUser to link a fnd record to their Employee (HR - per_all_people_f) record.

2. When the link happens correctly, the row in wf_roles and wf_local_roles that belongs to the fnd_user gets updated correctly with the orig_system value being updated to 'PER' and orig_system_id set to the person_id from per_all_people_f for the employee record to which the fnd record was linked via the API

3. When the link does not happen correctly, the row in wf_roles and wf_local_roles that belongs to the fnd_user continues to have the orig_system value 'FND_USR' and orig_system_id is the user_id from fnd_user.

EXPECTED BEHAVIOR
-----------------------
Link is not working occasionally - expect it to work consistently.

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