My Oracle Support Banner

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:

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

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

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
Symptoms
Cause
Solution
References


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