Issue With Public API Fnd_user_pkg.UpdateUser
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.
On : 12.1.2 version,
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.
Link is not working occasionally - expect it to work consistently.
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