My Oracle Support Banner

Stock Locator Not Showing While Doing Misc Transaction - Locator Missing In LOV (Doc ID 2336287.1)

Last updated on JULY 02, 2020

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.


Actual Behavior

Find when the user is trying to do MISC transaction that time stock locator is not showing in locator LOV.

Stock locator(s) is(are) active at flexfield code combination as well as subinventory level.

At stock locator setup there is NO Inactive date mentioned.

When checking this locator in MTL_ITEM_LOCATION table, find END_DATE_ACTIVE column as a date.

Expected Behavior

Expect locator to show for transactions. (But see that there is an end date for the locator)


The issue can be reproduced at will with the following steps:

1. Perform Misc Transaction and find that locator is end dated and does not appear in the LOV


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

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