E1: SEC: Row Security on F0030 Results in Duplicate Key Errors in P0030A Bank Accounts application (Doc ID 651716.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.

Symptoms

I have defined Inclusive row security on column AYBTKP in the F0030 Bank Transit Master table to secure users to a single From/Thru value for Add=Y Chg=Y Del=Y View=Y. When these users attempt to add a new record in the P0030A Bank Accounts application, they receive a Duplicate key error. 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