My Oracle Support Banner

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 later
Information 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: 

  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

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


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