When a Table Is Locked While Performing an RCA, System Provides Non-Descriptive "Cannot Perform Insert" Error

(Doc ID 1924626.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Retail Invoice Matching - Version to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


When the record to perform a Receiver Cost Adjustment (RCA) in Retail Invoice Matching (ReIM) is locked by Retail Merchandising System (RMS) for an any reason, ReIM throws a "Cannot Perform Insert" error. 
This should be changed to something more descriptive, such as 'This record is already locked; Please try again later'.

Steps to Reproduce:

  1. Create a purchase order (PO); ship and receive it.
  2. Raise an invoice against it, but with less cost (to generate cost discrepancy).
  3. Run the AUTOMATCH batch.
  4. Update any column in ITEM_LOC_SOH table for same ITEM and LOC used on the invoice.  Do not commit.
  5. Resolve the cost discrepancy with an RCA.
  6. Click OK and see the error "Cannot perform insert".
  7. Note that the actual error on the back end shows as:




    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