Business is using locator status as well as stock status. Under an active locator stock can be inactive.
E.g. Under active locator A, stock X can be inactive
Under active locator B, stock X can be active
But in Oracle we can have only locator status. Is there any workaround to achieve the requirement.
We have suggested that when stock is active or inactive change the locator status to active or inactive respectively. But there is manual intervention to bring the actual locator status.