Updating Store Order Quantities in SIM and Saving or Approving the Store Order Throws an Error in RMS

(Doc ID 2110911.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When a Store Order is edited and saved multiple times in the Store Inventory Management (SIM) application, it fails in Retail Merchandising System (RMS) with the following error recorded in RMS database table LOGGER_LOGS:

Error: "sql_lib.api_msg O_error_type: O_error_message:Could not update database record."


Steps to Recreate:

  1. Create a store order in SIM with an item and a quantity and save it.  DO NOT approve.
  2. Open the store order created in the step above. Change the quantity (decrease) and then click 'Save'.
  3. The store order save fails with a 'Severe system error'.
  4. Query RMS database table LOGGER_LOGS and find that the operation failed in RMS (causing the above error in SIM) with the following error:
      "sql_lib.api_msg O_error_type: O_error_message:Could not update database record."

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