Allow Different Material Status=No, Still Allows Misc Receipt When Lot Status Is Set To A Different Default (Doc ID 1598166.1)

Last updated on DECEMBER 13, 2023

Applies to:

Goal

Can the "Allow Different Material Status" Profile parameter prevent miscellaneous receipts from mixing statuses?

ACTUAL BEHAVIOR
Miscellaneous transactions (like account alias receipt) can receive mixed material statuses when onhand exists for the lot but the lot default is different.

* Similar result for OPM batches.

-- What is working --
* Lot status is correctly used if no onhand exists.
* Subinventory transfer correctly fails if the destination lot status is different than the source status.
* Purchase receipt correctly fails if receive when lot default status is different than existing onhand.

-- Setup --
Using lot, locator and Onhand status controls.
Org > Onhand status control is activated.
Org Parameter > Lot tab > Allow Different Material Status = No

-- What was tried --
Applied INV RUP6 (Patch 16328540) and INV RUP7 (Patch 16826285) but issue remains.

EXPECTED BEHAVIOR
Expect misc. receipts to fail if "Allow Different Material Status" = No when the onhand status is different than the lot default status.

STEPS
Setup:
* Org onhand status enabled.
* Org Allow different material status = No
* New item with no onhand quantity.
* Item uses Full Lot control, and Dynamic locator control.

1. Navigate to Inventory > transactions > misc transactions.
2. Receive 1 onhand in subinventory/lot/locator.
* Takes default lot status. (working correctly so far)
3. Navigate to Inventory > onhand > query item > Choose Tools > Update status
4. Change to another status.
5. Navigate to Inventory > transactions > misc transactions.
6. Receive another item onhand into same subinventory/lot/locator.
7. Lot takes status of existing onhand quantity.

Solution

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