Need a OTBI SQL Query to compare locator values for an Item between these two inventory FSM setups — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a OTBI SQL Query to compare locator values for an Item between these two inventory FSM setups

edited Aug 15, 2025 2:43PM in Inventory Management 4 comments

Hello Oracle Fusion Cloud Community - I need an OTBI SQL Query to compare locator values for an Item between the "Manage Item Transaction Defaults" & the "Manage Item Locators" setups in Oracle Fusion Cloud. Any help will be much appreciated. Thanks in advance.

Reason for asking: We had an issue where there was an item which had different locator values in these two setups because of which we could not perform receiving in inventory management. We are trying to perform an audit to avoid this issue in the long term for the other items in our inventory.

Ideally, the SQL Query would give the data mentioned below:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!