Return To Vendor Information Is Not Captured For The Transaction Done From Physical Warehouse In RI
Last updated on JANUARY 29, 2018
Applies to:Oracle Retail Merchandising Insights - Version 16.0 and later
Information in this document applies to any platform.
Return to Vendor information is not captured for the transaction done from physical warehouse in RI.
When a RTV transaction is happening for an item from a physical warehouse in RMS, that corresponding record is not integrated to RI due to below reason.
In RI, while fetching the data from RMS it also checks for the item ranging in ITEM_LOC table, but in this scenario ranging will not be done for physical warehouse rather it will be done for virtual warehouse. So in RTV_HEAD we will have the location as physical warehouse and in ITEM_LOC that item is ranged to virtual warehouse, hence the condition fails and the corresponding record is not pulled into Retail Insights fact table.
Steps To Recreate the issue:
1. Subscribe to an RTV for a physical warehouse
2. Run SDE_RetailInventoryReturnToVendorFact
3. Notice that the RTV is not inserted to stage table
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms