RPMtoORPOSPublishExport Batch Does Not Pick Simple Promotions Following a Location Move (Doc ID 2286700.1)

Last updated on MARCH 10, 2019

Applies to:

Symptoms

Following a location move into a zone with existing promotions, promotions appear to be picked up (there are correct entries in RPM_PROMO_ITEM_LOC_EXPL and RPM_FUTURE_RETAIL tables), but these never appear in the PRICINGEXTRACT.XML for the locations in question.

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Move a location into a zone with active simple promotions
2. Run LocMoveScheduleBatch and LocMoveBatch.
3. Note that the promotions now exist in RPM_PROMO_ITEM_LOC_EXPL and RPM_FUTURE_RETAIL for the new location in the zone.
4. Run RPMtoORPOSPublishBatch and RPMtoORPOSPublishExport.
5. Note that the promotions are not in the PricingExtract.xml for the new location in the zone.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.