E1: SEC: Exclusive Application Security not Working when a Business Function is called from a Grid Event (Doc ID 1425096.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

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] Setting connection runtime property Exclusive Application Security to not set.
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.

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