FND_USER_PKG.UPDATEUSER Incorrectly Updating Records in AK_WEB_USER_SEC_ATTR_VALUES for ICX_HR_PERSON_ID and TO_PERSON_ID
Last updated on DECEMBER 13, 2016
Applies to:Oracle Application Object Library - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
On Oracle Applications 22.214.171.124 version,
FND_USER_PKG.UPDATEUSER API is incorrectly updating all records in AK.AK_WEB_USER_SEC_ATTR_VALUES for ICX_HR_PERSON_ID and TO_PERSON_ID for the user begin updated. The FND_USER_PKG.UPDATEUSER API is not updating securing attributes in ICX_HR_PERSON_ID.
Enhancement 7311235 / Bug 8222658 delivered some functionality to update these record. However, the effects of the bug is that any authorized delegate for Internet Expense Reporting who is updated via the FND_USER_PKG.UPDATEUSER API will lose the abillity to submit expense reports for someone else.
Note 358719.1 - Linking a New HR Record Causes ICX_HR_PERSON_ID to be Set to Person ID describes the bug found in FNDSCAUS.fmb and the patch released to fix it. Followed the Oracle Internet Expenses Implementation and Administration Guide, Mini-pack G (11i.OIE.G) Release 11i, Second Generation Part No. A80831-04 in order to enable the authorized delegate functionality in the first place using the ICX_HR_PERSON_ID securing attribute for the setup.
Patch 8519485 - 7311235 FORWARD PORT: UPDATE FND_USER_PKG APIS TO ADD SECURING ATTRIBUTES has also been applied.
Currently at AFSCUSRB.pls version 115.159.
Applied Patch 6241631 - 11i.ATG_PF.H.RUP7 and 8519485 - 7311235 FORWARD PORT: UPDATE FND_USER_PKG APIS TO ADD SECURING ATTRIBUTES.
The issue can be reproduced at will with the following steps:
First, add an ICX_HR_PERSON_ID to a user with a value of another employee person ID using the Define User form.
Then, run the FND_USER_PKG.UPDATEUSER API on the user. An example of this would be to run it to change the users password.
Manually change the ICX_HR_PERSON_ID back to what it should be using in the Define User form (FNDSCAUS.fmb).
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