"Cannot Perform Insert" Error Occurs on Cost Variance Resolution Screen (Doc ID 1908173.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

In Oracle Retail Invoice Matching (ReIM) 13.1.x, we find that users are unable to resolve cost discrepancies on the Cost Variance Resolution screen.  The following error occurs:


Steps to Reproduce:

  1. Create an order with items, one of which is a pack item.
  2. Create an ASN shipment but do not receive it.
  3. Cancel the ASN shipment.
  4. Ship/Receive the order from Retail Warehouse Management System (RWMS).
  5. Create an invoice with cost discrepancy.
  6. Try to resolve with RCA reason code and note the error: "Cannot Perform Insert"

 

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