E1: SEC: Inclusive Row Security on MCU for *ALL tables Results in Failure in Distribution Applications and Tables F41001 and F41002 (Doc ID 645469.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Jul-2013***

Symptoms

I have set up inclusive row security on data item MCU for *ALL tables for valid range of values in the Business Unit Master Table F0006. However, some applications in Distribution are failing with Row Security Violations.  When reviewing the jdedebug log, it shows SQL Select on 2 tables : F41001 on MCU value of ALL and F41002 on MCU of space. Why?

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