My Oracle Support Banner

E1: 42: Stocking Type STKT Row Security Not Working In P4210 (Doc ID 2485042.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
Information in this document applies to any platform.


On : 9.1 version, Sales

E1 does not recognize *BLANKS E1 Row security configuration correctly when an application/UBE tries to insert a "" (blank) value into a table.  With E1 Inclusive Row security configuration activated on data item Stocking Type STKT, an Inclusive Row Security Violation error on F42UI130 is issued
preventing order entry. The error is JDB9900899 - Inclusive Row Level Security Violation:  attempted an INSERT on column ZCSTKT in table F42UI130.  Furthermore, P4210 issues a File Can Not Be Accessed hard error.  This issue is similar to Bug 20723531 which was fixed.

The issue can be reproduced at will with the following steps:
1. Enter a sales order after setting up the inclusive row security on STKT




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

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