Need a OTBI SQL Query to compare locator values for an Item between these two inventory FSM setups
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: