My Oracle Support Banner

BDI Item Location History Extract Does Not Extract Late Sales (Doc ID 2585389.1)

Last updated on SEPTEMBER 06, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


BDI Item Location History Extract [BDI_ItemLocHist_Tx_PF_From_RMS_JOB] does not extract late sales. Due to this behavior, sales/returns for previous end-of-week (i.e. late sales) get missed.

Steps To Reproduce:

1. Process Sales/Returns with transaction date belonging to previous EOW_DATE.
2. Verify that step 1 is reflected in ITEM_LOC_HIST table as expected, i.e., EOW_DATE earlier than LAST_EOW_DATE in SYSTEM_VARIABLES.
3. Run BDI_ItemLocHist_Tx_PF_From_RMS_JOB when VDATE is EOW.
4. Note that extracted ItemLocHist data does not include the late sales.




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.