My Oracle Support Banner

E1: SOLEXP: P95921 Writes Event Type 14 (Remove User/Role Relationship) Record to F9312 for the Wrong User (Doc ID 2757829.1)

Last updated on MARCH 04, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In EnterpriseOne 9.2, Tools Release 9.2.3.3:

A Role was removed from a User in Work With Role Relationships, P95921, but the security history record, Event Type 14 (Remove User/Role Relationship) was written to the F9312 Security History table for the wrong User, and the Role also removed from the wrong User.

Steps:

1. P0092, Create USERA, add ROLEA to USERA
2. P0092, Create USERB, add ROLEB to USERB
3. FP to P98OWSEC Security Detail Revisions, Verify USERB is Active (User Status 01)
4. FP to P95921, inquire on USERB, verify ROLEB
5. FP to P98OWSEC Security Detail Revisions, Disable USERA (User Status 02)
6. In P95921, enter USERA in User field, tab out, do NOT press OK (Note ROLEB)
7. Remove ROLEB from USERA, Confirm Delete
8. Databrowser over F9312, User ID USERA, Event Type 14 Remove User/Role written with ROLEB
9. Databrowser over F9312, User ID USERB, no new record written
10.FP to P95921, inquire on USERB, no Role attached
11.Need to re-add ROLEB to USERB

The objective was to verify USERB was Active/Enabled then Disable USERA and remove the Role from USERA.

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.