My Oracle Support Banner

Able To Perform Some Transactions Whereas Inventory Material Status Disallows All Transactions (Doc ID 1617784.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
Form: INVMSDEF.fmb - Define Material Status
Form: INVTDTTY.fmb - Define Transaction Type

Symptoms

Users are able to perform transactions for a locator (or a subinventory or an item lot) which material status disallows all transactions.
The problem occurs with some kinds of transactions and not with other.

Expectation
Expect the system to prevent users from performing any kind of transaction.

Steps
The issue can be replicated per the below steps:

Note: In this example, the material status is applicable to locators and transaction type is Account alias issue.

1. Get some on hand quantity in a locator being currently at Active status.

2. Create a new material status, let's say with Name as 'Frozen'.
Navigation: Inventory: (N) Setup : Transactions : Material Status
Set the material status as applicable to Locator and disallow all transactions like below:



3. Update the locator definition from Active to Frozen status as below:
Navigation: Inventory: (N) Setup : Organizations : Stock Locators



There is now on hand quantity in a Frozen locator as below:
Navigation: Inventory: (N) On-hand, Availability : On Hand Quantity



4. Try to perform an Alias account issue transaction.
Go to Inventory: (N) Transactions : Miscellaneous Transactions
Set Transaction Type = Account alias issue
Select an Account Alias
Press Transaction Lines
In Account alias issue window:
Enter the item and subinventory
Select the above locator
Enter the quantity
Save
See no error is raised

Business impact
Due to this issue, warehouse users cannot completely freeze a locator. (or a subinventory or an item lot)

 

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
References


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