E1: SEC: Row Security Errors with Updates on Tables Due to Row Security Engine Change Securing Future Values

(Doc ID 660738.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

After upgrading our Tools Release, several processes that involve row security have started to fail across EnterpriseOne applications.
 
Only users with row security are affected. The problem happens in multiple environments and the same user does not have any problem when repeating the process in the previous tools release.  Sometimes applications will display the error message

Error: File cannot be accessed

The log contains one of the following error messages :

JDB9900410 - Inclusive Row Level Security Violation: [UserID] attempted an UPDATE in table [Fxxxx]

or

JDB9900200 - Row Level Security Violation: [UserID] attempted an UPDATE on column [ALIAS] in table [Fxxxx]

Cause

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