E1: SEC: Exclusive Application Security not Working when a Business Function is called from a Grid Event
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.
Exclusive Application Security is not working if a business function is called from a grid column, event like "Col Exited & Changed - Inline", or from any grid event.
Row Security is set up for Business Unit (Alias: MCU). A custom application has been set up for Exclusive Application Security so as to be able to ignore this row security setting on MCU.
In the custom application, there is a business function call to "B0000130 - Retrieve Company from Business Unit" in the grid column "Business Unit", (Col Exited & Changed - Inline event) and this is the function that is throwing error 3091 for invalid business unit. Exclusive Application security added for the user is not taking effect.
The following error is shown in the jasdebug.log:
02 Nov 2011 14:26:47,639 [Line -1] [DEBUG ] JSTEST - [JDBJ] Using runtime property Exclusive Application Security connection value not set.
02 Nov 2011 14:26:47,639 [Line -1] [DEBUG ] JSTEST - [JDBJ] Using runtime property Application Name default value null.
02 Nov 2011 14:26:47,639 [Line -1] [DEBUG ] JSTEST - [JDBJ] (Ignored any system or jdbj.ini setting for Application Name because it can only be set programmatically on a specific logical connection.)
02 Nov 2011 14:26:47,639 [Line -1] [DEBUG ] JSTEST - [JDBJ] Checking exclusive application security, User = JSTEST, Environment: JPD900, Role:*ALL
02 Nov 2011 14:26:47,639 [Line -1] [DEBUG ] JSTEST - [JDBJ] No application name is specified. Exclusive application security is not in effect., User = JSTEST, Environment: JPD900, Role:*ALL
It is found that if the business function call is replaced by a Table I/O to F0006 table in the Column event, then Exclusive Application Security will work.
So row security is correctly suppressed when using table I/O but not through a second level BSFN call.
This means that Exclusive security does not apply to business function calls from column events or grid row events.
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