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