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

Last updated on OCTOBER 19, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.8 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release (SIM 13.2.9).
This article will be updated as official patch information becomes available.


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

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