E1: 41: Inventory Transfer With Row Security Impacts Inventory Integrity (Doc ID 2605304.1)

Last updated on AUGUST 23, 2021

Applies to:

Symptoms

A specific user made an Inventory Transfer (P4113) of 274 lots from the Manufacturing Warehouse inventory to the Quality Facility. The lots were subtracted from the Manufacturing Branch and added to the Quality Branch in the Item Ledger (F4111) but in the Item Location (F41021) table, the transaction quantity was subtracted from the quantity on-hand in the Manufacturing Branch but was NOT added to the quantity on-hand in the Quality Branch.

Steps to Duplicate: 

1. The Security Workbench (P00950) is setup so the specific user can View, Add, Change or Delete Item Branch (F4102) records in the Quality Branch Plant 
2. The specific user is prevented from accessing Item Location (F41021) records in the Quality Branch Plant.
3. A specific user made an Inventory Transfer (P4113) of 274 lots from the Manufacturing Warehouse inventory to the Quality Facility.
4. The transaction was allowed and no error was issued, but the Inventory Transfer (P4113) system allowed the data to be corrupted.
   1. The transaction quantity was subtracted from the Manufacturing Branch and added to the Quality Branch in the Item Ledger (F4111)
   2. The Journal Entries (F0911) were created for the Manufacturing From Branch and the Quality To Branch
   3. In the Item Location (F41021) table, the transaction quantity was subtracted from the quantity on-hand in the Manufacturing Branch but was not added to the quantity on-hand in the Quality Branch. 

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.