E1: 41: Inventory Transfer With Row Security Impacts Inventory Integrity
(Doc ID 2605304.1)
Last updated on NOVEMBER 12, 2019
Applies to:
JD Edwards EnterpriseOne Inventory Foundation - Version 9.2 and laterInformation in this document applies to any platform.
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:
- 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
- The specific user is prevented from accessing Item Location (F41021) records in the Quality Branch Plant.
- A specific user made an Inventory Transfer (P4113) of 274 lots from the Manufacturing Warehouse inventory to the Quality Facility.
- The transaction was allowed and no error was issued, but the Inventory Transfer (P4113) system allowed the data to be corrupted.
- The transaction quantity was subtracted from the Manufacturing Branch and added to the Quality Branch in the Item Ledger (F4111)
- The Journal Entries (F0911) were created for the Manufacturing From Branch and the Quality To Branch
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |