E1: Need to Prevent Duplicate Lots While Implementing Row Security (P00950) at Branch Plant (MCU) Level (Doc ID 2826461.1)

Last updated on DECEMBER 07, 2021

Applies to:

Symptoms

Item Reclassification (P4116) is creating a duplicate lot even though “Allow Duplicate Lots” in System Constants (P41001) is set to 3 (Do not allow duplicate lots). This occurs when Row Security allows access to a specific Branch Plant (MCU) and the duplicate lot resides in a Branch Plant the user cannot access.

The client used the following steps to reproduce the error”

1. Allow Duplicate Lots in System Constants (P41001) is set to 3 (Do not allow duplicate lots)
2. Set Row Security in Security Workbench Row Security for Branch Plant 8XX to "N" for View, Add, Change, and Delete for the User ID.
3. In Security Workbench Row Security for Branch Plant 3XXX is set to "Y" for View, Add, Change, and Delete for the User ID.
4. In the Lot Master (F4108) verify a specific Lot Number already exists in Branch 8XX for a different Item than what the user wants to use.
5. The User enters an Inventory Reclassification (P4116)
   1. From Item Number and Branch Plant 3XXX with a different lot number
   2. To Item Number and Branch Plant 3XXX with the Lot Number that already exists in Branch 8XX under a different Item Number.
6. The system does NOT issue the error "Lot already exists for a different item".(Error ID 2501)
7. The transaction is allowed.
8. After the transaction, the Lot Master Inquiry (P4108) shows two different Item Numbers now exist with the same Lot Number.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.