E1:41: Errors After Setting up Row Security on Field LOTS (Doc ID 1628171.1)

Last updated on OCTOBER 23, 2015

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

Customer needs to restrict all users from  updating a particular Lot Status "D", by using row security on the alias LOTS, for all tables. Users can update/delete other values for the lot status, with the exception of value "D".

After implementing row security on all tables for LOTS and value "D", they have issues when trying to create transactions for lots having Lot Status "blank".

Steps to duplicate:
Scenario 1:
1. Enable Row Security on Data Dictionary Item "LotStatusCode" Alias: LOTS.
2. Select any Branch / Plant and Stock End Item
Make sure there are two Locations (F4100) "R" and "D".
Use P4108:
3. Create new Lot Master record LOT1 with Lot Status <blank> (Approved).
4. Create new Lot Master record LOT2 with Lot Status <blank> (Approved).
Use P4114:
5. Make Inventory adjustment to add on hand quantity to LOT1 Location: R.
6. Make Inventory adjustment to add on hand quantity to LOT2 Location: R.
Use P4113:
7. Move Inventory for LOT1 from Location: "R" to "D" (Inventory transaction) leave some for later movement. Lot status used is always blank.
Apply Row Security for with Lot Status (Alias: LOTS) as follows (<User> = User performing test):
User / Role Object Name From Value Thru Value Security View Add Change Delete
Type
<User> *ALL *BLANKS C 4 Y Y Y Y
<User> *ALL D D 4 Y Y N N
<User> *ALL E Z 4 Y Y Y Y
Use P4113:
8. Move Inventory for LOT1 from Location: "R" to "D" (Inventory transaction). Lot status is blank.
9. Move Inventory for LOT2 from Location: "R" to "D" (Inventory transaction). Lot status used is blank.
Actual outcome:
• For LOT1 Inventory Ledger transaction (F4111) is created and Item Location on hand quantity (F41021) is update correctly.
• For LOT2 Inventory Ledger transaction (F4111) is created and BUT Item Location (F41021) is NOT created.
• Expected outcome:
For LOT1 Inventory Ledger transaction (F4111) is created and Item Location on hand quantity (F41021) is update correctly.
• For LOT1 Inventory Ledger transaction (F4111) is created and Item Location record (F41021) is created with correctly on hand quantity."

Scenario 2:
1. With above Row Security setup in place, user tries to enter an Inventory Adjustment (P4114) for an item with Lot Status 'blank'. The system throws error "Transaction failed. Not committed".
2. Without Row Security, P4114 does not throw any error.

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