Price Change Import Jobs Fail When a Price Event Is Approved or Unapproved Multiple Times

(Doc ID 1968043.1)

Last updated on OCTOBER 19, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

In the Store Inventory Management (SIM) 14.0.x application, we  find that the RegularPriceChange.sh (and other bulk price batches) fail when a particular price event is approved or unapproved more than once in a day.  The batch aborts with the following error:


Steps to Reproduce:

  1. Create and approve a regular price change in Retail Price Management (RPM).
  2. Unapprove the same price change in RPM.
  3. Correct the price change amount and re-approve the same price change again in RPM.
  4. Validate that the payload tables have 3 entries for this price change (approve, delete, approve).
  5. Run the price export jobs in RPM.
  6. Use that file to run the RegularPriceChange.sh to load the price changes into SIM.
  7. Notice that the job fails with the above error.  The sim_server.log file shows the "ORA-30926: unable to get a stable set of rows in the source tables" error.
  8. Repeat the test with clearance and promotion price changes and run the respective SIM batches.  Notice the same error.

 

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