My Oracle Support Banner

While Editing the, Manage User Profile Page, Upon Saving the Changes the Version Field on PSOPRDEFN, Is Not Being Updated Correctly (Doc ID 3023494.1)

Last updated on MAY 17, 2024

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When a supplier administrator navigates to Manage User Profiles page and makes an update, not every change made to the user profile triggers a VERSION update on PSOPRDEFN. We found that is causing access issues – the user could not see tiles as expected.


The issue can be reproduced at will with the following steps:
1. Login as supplier admin.
2. Navigate to: Maintain Supplier Information > Manage User Profiles.
3. Search for a supplier user ID and select one.
4. Check PSOPRDEFN for current VERSION value of the user. (Select * from PSOPRDEFN where OPRID= 'User1')
5. Add a role and save.
6. Check PSROLEUSER to make sure the Role was added. (Select * from PSROLEUSER where ROLEUSER= 'User1')
7. Check PSOPRDEFN for current version value
8 The Version remained the same. It was not updated.

Changes

 

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
Changes
Cause
Solution
References


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