Reapproved Promotions and Clearances Are Loaded in 'Delete' Status in Bulk Price Batch Process (Doc ID 1967708.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Symptoms

Reapproved promotions and clearances are loaded in 'Delete' status in the Store Inventory Management (SIM) bulk price process.

Steps to Reproduce:

1. Create a promotion/clearance in Retail Price Management (RPM) and approve it.
2. Run the following batch processes in RPM in order to get the data to SIM:
   
   For clearance:
     clearancePriceChangePublishBatch.sh
     clearancePriceChangePublishExport.sh
   
   For promotion:
     promotionPriceChangePublishBatch.sh
     promotionPriceChangePublishExport.sh
   
   
3. FTP the export file to SIM and run the following batch:
   
   For clearance:
      ClearancePriceChange.sh
   
   For promotion:
     PromotionPriceChange.sh
   
   
4. Confirm that the price changes exist in the RK_PRICE_CHANGE table within SIM.  They should have a status of '1' - 'New'.
5. In RPM, take the SAME promotion/clearance; put it into 'Worksheet' status and immediately approve it.
6. Run steps 2 and 3 again.
7. Observe that the file fails to process the CRE records.  It processes the DEL records correctly, and updates the status to be "9" - DELETED, but the CRE records are rejected.

Cause

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