My Oracle Support Banner

When a Table is Locked While Performing a RCA, System Provides Non-Descriptive Error "Cannot Perform Insert" Error (Doc ID 1924626.1)

Last updated on OCTOBER 07, 2020

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:




    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

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