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 OCTOBER 15, 2023

Applies to:

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

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