FND_USER_PKG.UPDATEUSER Incorrectly Updating Records in AK_WEB_USER_SEC_ATTR_VALUES for ICX_HR_PERSON_ID and TO_PERSON_ID
(Doc ID 1378017.1)
Last updated on JANUARY 18, 2025
Applies to:
Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Symptoms
On Oracle Applications 11.5.10.2 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.
Workaround:
Manually change the ICX_HR_PERSON_ID back to what it should be using in the Define User form (FNDSCAUS.fmb).
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 |